convert many excel files to pdf in batch

Discussion in 'Python' started by Wensui Liu, Feb 28, 2007.

  1. Wensui Liu

    Wensui Liu Guest

    Dear all,
    right now, I have 20 something excel reports that need to be converted
    to pdf and I have pdf write installed on my PC.
    Is there a way that I can do so in python?
     
    Wensui Liu, Feb 28, 2007
    #1
    1. Advertisements

  2. Wensui Liu

    Adam Guest

    1. Get PDFCreator
    2. Install
    3. Set as default printer
    4. Have all excel files in same folder
    5. Select all excel files
    6. Right click
    7. Select Print
    8. Save Each PDF to a location
    9. ???
    10. Profit!!!!

    Never done it with Adobe Writer. I'm a cheapskate.

    Regards,
    Adam
     
    Adam, Feb 28, 2007
    #2
    1. Advertisements

  3. Wensui Liu

    Wensui Liu Guest

    Adam,
    If you could come up with a way without using Adobe writer, it should
    also work for me.
    thanks.

    On 28 Feb 2007 12:53:52 -0800, Adam <> wrote:
    > 1. Get PDFCreator
    > 2. Install
    > 3. Set as default printer
    > 4. Have all excel files in same folder
    > 5. Select all excel files
    > 6. Right click
    > 7. Select Print
    > 8. Save Each PDF to a location
    > 9. ???
    > 10. Profit!!!!
    >
    > Never done it with Adobe Writer. I'm a cheapskate.
    >
    > Regards,
    > Adam
    >
    > --
    > http://mail.python.org/mailman/listinfo/python-list
    >



    --
    WenSui Liu
    A lousy statistician who happens to know a little programming
    (http://spaces.msn.com/statcompute/blog)
     
    Wensui Liu, Feb 28, 2007
    #3
  4. Wensui Liu wrote:

    > Adam,
    > If you could come up with a way without using Adobe writer, it should
    > also work for me.
    > thanks.
    >
    > On 28 Feb 2007 12:53:52 -0800, Adam <> wrote:
    >> 1. Get PDFCreator
    >> 2. Install
    >> 3. Set as default printer
    >> 4. Have all excel files in same folder
    >> 5. Select all excel files
    >> 6. Right click
    >> 7. Select Print
    >> 8. Save Each PDF to a location
    >> 9. ???
    >> 10. Profit!!!!
    >>
    >> Never done it with Adobe Writer. I'm a cheapskate.


    He didn't use Adobe Writer! In fact he said he didn't. PDFCreator is a
    free utility. Download it here:
    http://www.pdfforge.org/products/pdfcreator/

    j

    --
    Joshua Kugler
    Lead System Admin -- Senior Programmer
    http://www.eeinternet.com
    PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE

    --
    Posted via a free Usenet account from http://www.teranews.com
     
    Joshua J. Kugler, Mar 1, 2007
    #4
  5. Wensui Liu

    Bob Guest

    OpenOffice Calc can read EXCEL files and can export them as PDF.
    It has its own macro capability and can run Python

    How well it works I don't know; I haven't tried running Python yet.

    OpenOffice.org is FREE!

    Bob
     
    Bob, Mar 1, 2007
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dee
    Replies:
    2
    Views:
    542
  2. crazyprakash
    Replies:
    4
    Views:
    3,691
    adrian
    Oct 30, 2005
  3. Davor
    Replies:
    4
    Views:
    675
    Davor
    Jun 14, 2006
  4. srinivasan srinivas

    Python Modules To convert PDF files to HTML files

    srinivasan srinivas, Jul 30, 2008, in forum: Python
    Replies:
    0
    Views:
    465
    srinivasan srinivas
    Jul 30, 2008
  5. Matias Surdi

    Re: Converting .py files to batch files.

    Matias Surdi, Sep 15, 2008, in forum: Python
    Replies:
    4
    Views:
    643
  6. Ricardo Pog
    Replies:
    1
    Views:
    800
    Austin Ziegler
    Mar 26, 2008
  7. Sean Nakasone
    Replies:
    1
    Views:
    676
    Farrel Lifson
    Apr 14, 2008
  8. Keerthivrao

    Convert HTML 2 PDF MS-WORD MS-EXCEL

    Keerthivrao, Nov 17, 2005, in forum: Perl Misc
    Replies:
    4
    Views:
    643
    Matt Garrish
    Nov 17, 2005
Loading...