用powershell将对象输出到excel中

$excel = New-Object -ComObject Excel.Application

$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)

$row = 1
$column = 1

foreach ($item in $data) {
    $worksheet.Cells.Item($row, $column) = $item
    $row++
}

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

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

$data = @("Item 1", "Item 2", "Item 3")

$row = 1
$column = 1

foreach ($item in $data) {
    $worksheet.Cells.Item($row, $column) = $item
    $row++
}

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