Forum Discussion

Rahul Udayabhanu's avatar
Rahul Udayabhanu
Copper Contributor
May 14, 2018

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....
powershell
PowerShell Commands
  • Rahul Udayabhanu's avatar
    Rahul Udayabhanu
    Copper Contributor
    May 18, 2018

    Hi,

    I tried this method for manual script run. its not generating the output in a formatted way.

     

    $slgcsv = "D:\Temp\UnityScript\Logs\FS_UTIL" +".csv" #Location of the source file

     

    #EMC Storage cmd which give CSV output#EMC Storage cmd which give CSV output with Delimiter ","

    uemcli -d XXX -u XXX -p XXX /stor/prov/fs show -output csv -filter "Name,Health details,Server,Protocol,Size,Size used,Replication destination" >> $slgcsv
     
    $csv = import-csv D:\Temp\UnityScript\Logs\FS_UTIL.csv 
    $csv | export-excel D:\Temp\UnityScript\Logs\test.xlsx

     

     

    o/p of storage command is like below:-

    Storage system address: X.X.X.X
    Storage system port: 443
    HTTPS connection
    "Name","Health details","Server","Protocol","Size","Size used","Replication destination"
    "XXXX","""The component is operating normally. No action is required.""","nas_2","cifs","107374182400 (100.0G)","38179020800 (35.5G)","no"
    "XXXX","""The component is operating normally. No action is required.""","nas_4","cifs","107374182400 (100.0G)","57654591488 (53.6G)","no"
     

Resources