RSS category feeds

RSS site feeds

More

A simple Excel to PDF Converter PDF Print E-mail
This is a simple PDF Converter which watches in a directory for incoming Excel documents and converts them to PDF. Ghostscript and a Postscript printer has to be installed.
 
path_to_watch = "D:\\share\\"
 
 
before = dict ([(f, None) for f in os.listdir (path_to_watch)])
def convert(filename):
    tmpfile = path_to_watch + 'tmp\\'+filename+'.ps'
    if filename[-3:]=='xls':
        pythoncom.CoInitializeEx(pythoncom.COINIT_APARTMENTTHREADED)
        myExcel = win32com.client.DispatchEx('Excel.Application')
        Excel = myExcel.Workbooks.Open(path_to_watch+filename, 0, False, 2)
        Excel.PrintOut(1, 5000, 1, False, 'Rumborak PDF-Writer Plus 1.0 RC5', 
          True, False, tmpfile)
        Excel.Saved = 1
        Excel.Close()
        myExcel.Quit()
        del Excel
        del myExcel
        os.popen('c:\\gs\\gs8.15\\bin\\gswin32c.exe -sDEVICE=pdfwrite -r300 -dNOPAUSE \
           -dBATCH -dSAFER -sPAPERSIZE=a4 \
           -sOutputFile="'+path_to_watch+filename+'.pdf" "'+tmpfile+'"')
        #os.remove(path_to_watch+filename)
        os.remove(tmpfile)
        pythoncom.CoUninitialize()
while 1:
  time.sleep (0.1)
  after = dict ([(f, None) for f in os.listdir (path_to_watch)])
  added = [f for f in after if not f in before]
  if added and added[0][-3:]=='xls':
      starttime = time.clock()
      print "File ", ", ".join (added), "added to queue"
      convert(added[0])
      stoptime = time.clock()
      print "OK. It took", stoptime-starttime, 'seconds.\n'
  before = after
Last Updated ( Thursday, 02 February 2006 )
 
< Prev   Next >

Feedback

Advertisement

Comments

  • I have run your code on my own machine, but I just got the last paragraph of the... More...
  • Hello Gabriel, It seem that the linked site moved to github.com/.../weboutlook (... More...
  • There is no script to download, could you provide the right link More...
  • Interesting but doesn't really help me. I do not see what the 'xxxxx' in the Ses... More...
  • You can see more python editor comparison: sparkledge.com/.../ (http://sparkledg... More...

Login Form






Lost Password?

My prefered Python IDE

My prefered Python editor is Pyscripter from MMExperts. It is not only an editor. Pyscripter is a full Python IDE including (remote) debugging, a class browser, and all other nice helpers which a full featured IDE needs.

Do you have a script for me ?

Do you have an interesting Python script which does some really cool thing on Windows ? Please post them to this site. It`s very simple - simply copy&paste it to this form. No login is requiered.

Hint: For syntax highlighting and correct Python intendation place your code between html tags <pre> and </pre>.

My prefered web framework

My prefered web framework for developing web applications is Django. Django calls itself The web framework for perfectionists with deadlines. It is a really fast, scalable and (thanks Python) the sexiest web framework of the world.