Multiple csv files to xlsx

adnan-salahuddin · June 9, 2015, 7:11pm

Hi PowerShell,

((New-Object-ComObject"Excel.Application").workbooks.open(‘c:\list.csv’)).SaveAs(‘c:\list.xlsx’,51)

How to multiple csv files into same xlsx file?
Thanks

kvprasoon · June 10, 2015, 2:35am

Hi,
You mean,to merge multiple .csv files to a single excel…?

Could you make your requirement little more clear…

Regards,
KVPRASOON

Topic		Replies	Views
Converting .xlsx to .csv PowerShell Help	1	159	October 25, 2023
combine multiple text files into one excel spreadsheet powershell PowerShell Help	1	150	November 12, 2014
Merging multiple excel fiels into multiple sheet of an excel PowerShell Help	0	152	December 31, 2011
Creating a Script to Convert Excel to CSV, with additional goals PowerShell Help	6	186	May 31, 2019
Performace XLSX PowerShell Help	1	119	July 9, 2015