如何通过Powershell将DataTable导出为Excel文件？

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)

$row = 1
$column = 1

# 写入表头
foreach ($columnName in $dataTable.Columns.ColumnName) {
    $worksheet.Cells.Item($row, $column) = $columnName
    $column++
}

# 写入数据行
foreach ($dataRow in $dataTable.Rows) {
    $row++
    $column = 1
    foreach ($item in $dataRow.ItemArray) {
        $worksheet.Cells.Item($row, $column) = $item
        $column++
    }
}

$workbook.SaveAs("C:\path\to\output.xlsx")
$workbook.Close()
$excel.Quit()

# 导入COM对象
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)

# 写入表头
$row = 1
$column = 1
foreach ($columnName in $dataTable.Columns.ColumnName) {
    $worksheet.Cells.Item($row, $column) = $columnName
    $column++
}

# 写入数据行
foreach ($dataRow in $dataTable.Rows) {
    $row++
    $column = 1
    foreach ($item in $dataRow.ItemArray) {
        $worksheet.Cells.Item($row, $column) = $item
        $column++
    }
}

# 保存并关闭Excel文件
$workbook.SaveAs("C:\path\to\output.xlsx")
$workbook.Close()
$excel.Quit()