使用Powershell在Excel列中添加时间戳

$excel = New-Object -ComObject Excel.Application

$workbook = $excel.Workbooks.Open("C:\path\to\your\excel\file.xlsx")

$worksheet = $workbook.Worksheets.Item(1)
$column = $worksheet.Columns.Item(1)

$timestamp = Get-Date -Format "yyyy-MM-dd HH:mm:ss"
$column.Cells | ForEach-Object { $_.Value2 = $timestamp }

$workbook.Save()
$workbook.Close()

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\path\to\your\excel\file.xlsx")
$worksheet = $workbook.Worksheets.Item(1)
$column = $worksheet.Columns.Item(1)
$timestamp = Get-Date -Format "yyyy-MM-dd HH:mm:ss"
$column.Cells | ForEach-Object { $_.Value2 = $timestamp }
$workbook.Save()
$workbook.Close()