creating excel work sheets using  powershell scripts

mlcomcast · 2020-03-02T12:50:11.000Z

how can I code in power shell to build excel spread sheets.

spiceuser-9suz5 · 2020-03-02T13:06:04.000Z

There are a lot of convoluted ways to handle this, but I think simplicity is best here.

You can export to CSV (Comma Separated Value) natively with Powershell.

Export-Csv

You can then convert to a spreadsheet with Excel.

big-green-man · 2020-03-02T13:18:52.000Z

Give this a read:

Rambling Cookie Monster

PSExcel: Excel automation without Excel

Who wants Excel on a server?

Neally · 2020-03-04T00:02:53.000Z

There are really only 2 options [that I’m aware of]

Use the ImportExcel Module From Doug Finke

GitHub

GitHub - dfinke/ImportExcel: PowerShell module to import/export Excel...

PowerShell module to import/export Excel spreadsheets, without Excel - dfinke/ImportExcel

OR

write your own com-object based Excel integration [it works but it’s a PITA]

Nosirrah:

There are a lot of convoluted ways to handle this, but I think simplicity is best here.

You can export to CSV (Comma Separated Value) natively with Powershell.

Export-Csv

You can then convert to a spreadsheet with Excel.

This has ZERO to do with Excel. A CSV is just a ‘comma separated values’ files and yes, Excel can read it, but so can notepad or any text editor, whereas XLS/XLSX is specific to Excel. But to be honest, OP did not give a lot of info.

OP, what is the end-goal of this “building Spreadsheet in Excel via PowerShell”?

DoctorDNS · 2020-03-04T08:23:03.000Z

To answer the question, there are no built in commands to integrate with Excel (or any of the Office products).

There is a COM interface you can use. It is non-trivial (well to me anyway) but it is doable.

The other way is to use the Import-Excel module. See this link for details: PowerShell and Excel: Harness the Power of ImportExcel

martin9700 · 2020-03-04T09:38:49.000Z

Big Green Man:

Give this a read:

PSExcel: Excel automation without Excel – Rambling Cookie Monster

PSExcel was a fork of the ImportExcel module back in it’s early days. Warren no longer supports it so I’d pass on it.

martin9700 · 2020-03-04T09:42:45.000Z

MLcomcast:

how can I code in power shell to build excel spread sheets.

Hi @mlcomcast , welcome to Spiceworks. When posting questions, it’s always important to frame the question properly, like what is the problem you are actually trying to solve? Why is exporting to Excel the answer and not just a simple CSV? What is your experience with PowerShell? Are you writing your own modules and tools or is this the first time you’ve ever thought about it?

I could go on! Try reading this too, might help.

spiceuser-9suz5 · 2020-03-04T16:17:52.000Z

Given the information available, and that there is no true way to “code in power shell to build excel spread sheets”; the answer was the best that could be given.