Printing Excel sheets with COM interface

Question

I've programatically made a bunch of Excel sheets with xlwt in python. It's all gone fine, but now I need to convert them all to pdf. I've been trying to do this with pywin32 and the com interface. I can get somewhat close by going like this:

import win32com.client
o = win32com.client.Dispatch("Excel.Application")
o.Visible = 1
wb = o.Workbooks.Open('foo.xls')
ws = wb.Worksheets[1]
ws.printout()

But unfortunately when I do this it pops up the adobe printer screen asking me for the path I want to save the pdf to, and if I have to enter that in or click ok for every page it defeats the purpose of doing it programatically. Is there any way I can enter this path in the python code rather than manually? Is there a better way of converting each of these sheets in each of these workbooks to pdf? Thanks a lot, Alex

Unfortunately that's the default behavior of the Adobe PDF printer driver. — Chris Laplante
– Chris Laplante, Commented Feb 1, 2012 at 2:01

Rachel Hettinger · Accepted Answer · 2012-02-01 06:45:17Z

4

Instead of using the PrintOut method, use ExportAsFixedFormat. You can specify the pdf format and supply a file name. Try this:

ws.ExportAsFixedFormat(0, 'c:\users\alex\foo.pdf')

edited Feb 1, 2012 at 6:45

answered Feb 1, 2012 at 6:22

Rachel Hettinger

8,4872 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raymond Hettinger · Accepted Answer · 2012-02-01 02:40:31Z

0

You can do a save as PDF or print to PDF. That should bypass your print driver issues.

answered Feb 1, 2012 at 2:40

Raymond Hettinger

229k67 gold badges405 silver badges504 bronze badges

1 Comment

Alex S Over a year ago

hmm ok, sorry how do I do that?

Collectives™ on Stack Overflow

Printing Excel sheets with COM interface

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related