Forum Discussion
Convert CSV to XLSX via PowerShell not working with Task scheduler
Hi, I tried to using this csv to Excel convert in one of storage Capacity reporting script. In script the storage cmd will run and generate a CSV data and I tried to put it as source for this script....
What if you use the excell module and do something like this?
https://blogs.technet.microsoft.com/heyscriptingguy/2015/11/25/introducing-the-powershell-excel-module-2/
$csv = import-csv c:\temp\test.csv
$csv | export-excel c:\temp\test.xlsx