使用Powershell将多个工作簿合并为一个工作簿工作表

$excel = New-Object -ComObject Excel.Application

$workbook1 = $excel.Workbooks.Open("path\to\workbook1.xlsx")
$workbook2 = $excel.Workbooks.Open("path\to\workbook2.xlsx", 0, $false, $true, "password")

$worksheet1 = $workbook1.Worksheets.Item(1)
$worksheet2 = $workbook2.Worksheets.Item(1)

$worksheet1.Copy($newWorkbook.Worksheets.Item($newWorkbook.Worksheets.Count))
$worksheet2.Copy($newWorkbook.Worksheets.Item($newWorkbook.Worksheets.Count))

$newWorkbook.SaveAs("path\to\newWorkbook.xlsx")
$newWorkbook.Close()

$workbook1.Close()
$workbook2.Close()

$excel = New-Object -ComObject Excel.Application

$workbook1 = $excel.Workbooks.Open("path\to\workbook1.xlsx")
$workbook2 = $excel.Workbooks.Open("path\to\workbook2.xlsx", 0, $false, $true, "password")

$newWorkbook = $excel.Workbooks.Add()

$worksheet1 = $workbook1.Worksheets.Item(1)
$worksheet2 = $workbook2.Worksheets.Item(1)

$worksheet1.Copy($newWorkbook.Worksheets.Item($newWorkbook.Worksheets.Count))
$worksheet2.Copy($newWorkbook.Worksheets.Item($newWorkbook.Worksheets.Count))

$newWorkbook.SaveAs("path\to\newWorkbook.xlsx")
$newWorkbook.Close()

$workbook1.Close()
$workbook2.Close()

$excel.Quit()