如何使用导入从所有标题中删除'A_‘-excel Powershell

# 导入Excel模块
Import-Module -Name ImportExcel

# 读取Excel文件
$excelFile = 'C:\path\to\your\excel\file.xlsx'
$worksheet = Import-Excel -Path $excelFile

# 遍历每个标题并删除'A_'
foreach ($column in $worksheet | Get-Member -MemberType NoteProperty) {
    $columnName = $column.Name
    $newColumnName = $columnName -replace '^A_', ''
    $worksheet | Rename-ExcelWorksheetColumn -ColumnName $columnName -NewColumnName $newColumnName
}

# 保存修改后的Excel文件
$worksheet | Export-Excel -Path $excelFile -NoNumberConversion -AutoSize

# 输出结果
Write-Host "已成功删除标题中的'A_'"

Install-Module -Name ImportExcel