PowerShell把Excel表格转换成PDF文档

############################################################
# Convert Excel document to PDF
############################################################
function Convert-ExcelToPdf
{
  param(
  [io.fileinfo]$DocPath,
  [string]$PdfPath
  )
    $xlFixedFormat = “Microsoft.Office.Interop.Excel.xlFixedFormatType” -as [type] 
    $objExcel = New-Object -ComObject excel.application 
    $workbook = $objExcel.workbooks.open($DocPath.fullname, 3) 
    $workbook.ActiveSheet.PageSetup.Orientation = 2
    $objExcel.PrintCommunication = $false
    $workbook.ActiveSheet.PageSetup.FitToPagesTall = $false
    $workbook.ActiveSheet.PageSetup.FitToPagesWide = 1
    $objExcel.PrintCommunication = $true
    $workbook.Saved = $true 
    $workbook.ExportAsFixedFormat($xlFixedFormat::xlTypePDF, $PdfPath) 
    $objExcel.Workbooks.close() 
    $objExcel.Quit()
}