将CSV数据从CMD导入Excel (Powershell中给出的示例)

$csvFilePath = "C:\path\to\input.csv"
$excelFilePath = "C:\path\to\output.xlsx"

# 创建Excel应用程序对象
$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false

# 打开Excel文件或创建新文件
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)

# 读取CSV文件数据
$csvData = Import-Csv -Path $csvFilePath

# 将CSV数据写入Excel文件
$row = 1
$col = 1
foreach ($dataRow in $csvData) {
    foreach ($property in $dataRow.psobject.Properties) {
        $worksheet.Cells.Item($row, $col) = $property.Value
        $col++
    }
    $row++
    $col = 1
}

# 保存并关闭Excel文件
$workbook.SaveAs($excelFilePath)
$workbook.Close()
$excel.Quit()

# 释放Excel对象
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($worksheet) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbook) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null
[System.GC]::Collect()
[System.GC]::WaitForPendingFinalizers()

Write-Host "CSV数据已成功导入Excel文件。"