Excel(xlsm) to PDF conversion failing,error "Save as method of Wroksheet class failed

[SukumarMaddineni1]

Hi,

I have one xlsm document , Using python I tried to convert that
document to PDF,

but COM raising pywintypes error "Save as method of Wroksheet class
failed".

Below is my code.

workbook = MicrosoftExcel.Workbooks.Open(document.filePath, 0, False, 2)
workbook.Application.AskToUpdateLinks = 0
outputFileFolder = outputFolder+'\\'+str(ncount)
outputFile = outputFileFolder+'\\'+str(ncount)+'.pdf'
workbook.SaveAs(outputFile, 57)  # at this line error is coming

Please help in this regards

Thanks & regards
Sukumar Maddineni

[dwblas]

You will likely have to convert the xls to text and use PyPdf or ReportLab to format as a pdf file if you want to do it programmaticall y. You should be able to convert within Excel as well. Generally you can print to file and choose PDF format instead of postscript.

[papin]

You should install a PDF printer driver (such as PDF Creator) and produce your PDF directly from Excel. This is so basic nowadays...