Excelのシートの並び順を逆順にするPowerShellのサンプルコード

powershell -ExecutionPolicy RemoteSigned -File "ReserveSheet.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)

# シート名取得(逆順)
$sheetCount = $book.worksheets.count
$workArray = @()
for( $i=0; $i -lt $sheetCount;$i++){
    $workArray += $book.sheets($sheetCount-$i).name
}

# シート入れ替え
for( $i=0; $i -le $workArray.Count-1;$i++){
    write-host("name:" + $workArray[$i] + " to position:" + ($i+1))
    $book.worksheets($workArray[$i]).Move($book.worksheets($i+1))
}

[void]$book.Save()
[void]$book.Close($false)
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($book)|Out-Null
[void]$excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)|Out-Null

Pause