Convert Excel(multiple sheets) to CSV using powershell.
#Convert Excel(multiple sheets) to CSV using powershell. $a=gci nba* $xls=new-object -comobject excel.application $sheets=$xls.workbooks.open($a.fullname).worksheets $xls.displayalerts=$false $foreach($sheet in $sheets){$sheet.saveas($a.directoryname + "\" + $sheet.name + ".csv",6)} import-csv(gci *.csv)|export-csv all.csv
#Convert Excel(multiple sheets) to CSV using powershell. $a=gci nba* $xls=new-object -comobject excel.application $sheets=$xls.workbooks.open($a.fullname).worksheets $xls.displayalerts=$false $foreach($sheet in $sheets){$sheet.saveas($a.directoryname + "\" + $sheet.name + ".csv",6)} import-csv(gci *.csv)|export-csv all.csv