2 Answers
Best Answer
$excelFile = $script:FilePath + $excelFileName
$Excelapp = New-Object -ComObject Excel.Application
$Excelapp.Visible = $false
$Excelapp.DisplayAlerts = $false
$Workbooks = $Excelapp.Workbooks.Open($excelFile)
foreach ($Worksheet in $Workbooks.Worksheets)
{
$csvname = $excelFileName.split(‘.’)[0] + $script:spchar + $Worksheet.Name
$Worksheet.SaveAs($csvFilePath + $csvname + “.csv”, 6)
}
可以挨个sheet另存成csv,核心代码如上,请自行测试。