PowerShell save as xlsx without excel

[dpierce4776]

Hello All
I have a PowerShell script that takes a txt file that is output from our monitoring software sorts it by headers and converts it to a CSV file. my issue is that I need this file in xlsx format and I do not have Excel installed on the server. does anyone know of anyway to do this?

 

[VulcanJedi]

come on another separate post in the vbscript forum?
for example a family tree related csv
Import-csv yourfile.csv|select person, surname, given, gender|sort gender, surname,given|export-csv newfile.csv
open the csv in xl or rename it to xls..etc

 

[SkipVought]

You cannot merely rename a TEXT file to .xls* it's still a text file!

 

[markdmac]

dpierce4776,

I am not aware of any way to do the conversion you are looking for without having Excel installed. Microsoft provides a free Excel viewer that would allow you to read an Excel file without having Excel installed, but nothing to let you go the other way.

What you could however do is use a remote PowerShell session to a system that does have Excel installed, have that system open the CSV file and then perform the SaveAs to convert it.

I hope that helps.

Regards,

Mark

No trees were harmed in posting this message, however a significant number of electrons were terribly inconvenienced.

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER.

 

[dpierce4776]

Thank you markdmac
I have been researching it and seen others try to make cmdlets for PowerShell to make it work but when I try it it errors out

 

[markdmac]

dpierce4776, start with getting code to work locally on a machine that does have Excel. Then you just need to put the wrapper of the remote session around it.

Here is some quick code I put together and tested to verify it works locally for you.

$xl = New-Object -ComObject Excel.Application
$xl.Visible = $True
$WorkBook = $xl.Workbooks.Open("C:\Temp\Printers.csv")
$xl.ActiveWorkBook.SaveAs("C:\Temp\Printers.xlsx")

I hope that helps.

Regards,

Mark

No trees were harmed in posting this message, however a significant number of electrons were terribly inconvenienced.

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER.

 

[markdmac]

PS this should really be in the PowerShell forum.

http://www.tek-tips.com/threadminder.cfm?pid=1619

I hope that helps.

Regards,

Mark

No trees were harmed in posting this message, however a significant number of electrons were terribly inconvenienced.

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER.