Excelの各セルのフォント名（フォントファミリー）を変更するPowerShellのサンプルコード

powershell -ExecutionPolicy RemoteSigned -File "setExcelFontName.ps1"

$excel = New-Object -ComObject Excel.Application
$book = $null

$excel.Visible = $false
$excel.DisplayAlerts = $false

$fileName  = "Book1.xlsx"
$filePath = (Convert-Path .) + "/" + $fileName

$book = $excel.Workbooks.Open($filePath)
$sheet = $book.Sheets("Sheet1")

$cell = $sheet.Cells(1,1)
$cell.font.Name = "ＭＳ Ｐゴシック"

$cell = $sheet.Cells(2,1)
$cell.font.Name = "ＭＳ ゴシック"

$cell = $sheet.Cells(3,1)
$cell.font.Name = "ＭＳ 明朝"

$cell = $sheet.Cells(4,1)
$cell.font.Name = "メイリオ"

$cell = $sheet.Cells(5,1)
$cell.font.Name = "游ゴシック"


[void]$book.Save()
[void]$book.Close($false)
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($book)

[void]$excel.Quit()
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)

Pause