Powershell函数，使用excel在文件格式之间进行转换

function Convert-ExcelToFile {
    param(
        [Parameter(Mandatory=$true)]
        [string]$ExcelFilePath,
        [Parameter(Mandatory=$true)]
        [string]$OutputFilePath,
        [Parameter(Mandatory=$true)]
        [string]$OutputFormat
    )

    # 加载Excel相关的COM对象
    $excel = New-Object -ComObject Excel.Application
    $excel.Visible = $false

    # 打开Excel文件
    $workbook = $excel.Workbooks.Open($ExcelFilePath)

    # 根据输出格式保存文件
    switch ($OutputFormat) {
        "CSV" {
            $workbook.SaveAs($OutputFilePath, [Microsoft.Office.Interop.Excel.XlFileFormat]::xlCSV)
        }
        "PDF" {
            $workbook.SaveAs($OutputFilePath, [Microsoft.Office.Interop.Excel.XlFileFormat]::xlPDF)
        }
        "HTML" {
            $workbook.SaveAs($OutputFilePath, [Microsoft.Office.Interop.Excel.XlFileFormat]::xlHtml)
        }
        default {
            Write-Host "Unsupported output format: $OutputFormat"
        }
    }

    # 关闭Excel文件和应用程序
    $workbook.Close()
    $excel.Quit()
}