PowerShell で Excel のメタデータ（個人情報）を削除する方法

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false

$wb = $excel.Workbooks.Open("C:\Path\To\Your\File.xlsx")
$wb.RemovePersonalInformation = $true
$wb.Save()
$wb.Close($false)

$excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null