1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| "Conversion Excel vers pdf ..."
$folderpath = $(get-location)
$FicPDF = "C:\test\mails\20241021\2139769.PDF"
$FicXLS = "C:\test\mails\20241021\2139769.XLS"
#Convert Excel formats to pdf
$xlTypePDF = 0 # Microsoft.Office.Interop.Excel.XlFixedFormatType
$xlQualityStandard = 0 # Microsoft.Office.Interop.Excel.XlFixedFormatQuality
$objExcel = New-Object -ComObject excel.application
$ci = [System.Globalization.CultureInfo]'en-US'
$objExcel.visible = $false
$workbook = $objExcel.workbooks.open($FicXLS,*3)*
$workbook.ExportAsFixedFormat($xlTypePDF, $FicPDF, $xlQualityStandard)
$workbook.Save()
$objExcel.Workbooks.close()*
$objExcel.Quit() |
Partager