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.

Expand|Select|Wrap|Line Numbers

 
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 programmatically. 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...

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

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ