RSS category feeds

RSS site feeds

A simple Excel to PDF Converter 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

Recommended

Comments

  • The general Concept of the API hasn`t change so much. But the Concept of storing... More...
  • Very interesting article. I haven't seen much on V6 automation. I don't recogniz... More...
  • This will not work with either Outlook 2007 or 2010. The default usage is of Sim... More...
  • This script is very useful. If you are having trouble to utilize this script you... More...
  • this instant django site has been down for a while now, if anyone has the execut... More...

Login Form






Lost Password?
No account yet? Register

Exits

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.