excel - Convert multiple xls to csv using powershell

Question

I'm trying to convert multiple excel files (xls) to csv which is located in a folder using powershell.

I can convert a single file but need help converting multiple files in a folder. But need advise on how to convert multiple files.

$ExcelWB = new-object -comobject excel.application
$Workbook = $ExcelWB.Workbooks.Open(c:empemp.xls) 
$Workbook.SaveAs("c:empemp.csv",6)
$Workbook.Close($false)
$ExcelWB.quit()

Answer 1

You can just wrap it in a loop that iterates over all the files and change the xls extension to csv:

foreach($file in (Get-ChildItem "C:emp")) {

  $newname = $file.FullName -replace '.xls$', '.csv'
  $ExcelWB = new-object -comobject excel.application
  $Workbook = $ExcelWB.Workbooks.Open($file.FullName) 
  $Workbook.SaveAs($newname,6)
  $Workbook.Close($false)
  $ExcelWB.quit()

}