Convert CSV files to an Excel Workbook in powershell without having Excel installed -


this question has answer here:

i'm running powershell script on remote servers generates reports in form of .csv files. want club these csv files individual worksheets of single excel workbook.

however, remote servers not have office installed, cannot use com-object approach.

in addition both 'microsoft.jet.oledb.4.0' , 'microsoft.ace.oledb.12.0' providers not registered on machine.

i cannot download anything, since script has generic , should able work on server large pool of servers.

is there way can reach goal or have hit dead end?

or possible may able link csv files in such way may click on 1 cell, , other csv file opens up?

quick appreciated.

check if fits needs:

csvs multi-sheet xls without excel installed. powershell

you neeed have powershell module on server intend generate excel workbook.


Comments