Re: Dealing with Excel

2005-10-19 Thread Francois Lepoutre
Robert Hicks wrote: I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? Robert http://sourceforge.net/projects/pyexcelerator/ http://sourceforge.net/projects/pyxlwriter/ We use the latter

Re: Dealing with Excel

2005-10-19 Thread Larry Bates
Using ODBC interface to Oracle Excel can do this without any external (Python) program. Just: 1) Create a ODBC DSN that interfaces with Oracle 2) In Excel do Data-Get External Data-New Database Query 3) Tell Excel what tables/columns/order/filtering you want You can even save the Database Query

Dealing with Excel

2005-10-18 Thread Robert Hicks
I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? Robert -- http://mail.python.org/mailman/listinfo/python-list

Re: Dealing with Excel

2005-10-18 Thread McBooCzech
Robert Hicks wrote: I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? It is possible to control Excel directly from the Python code (you do not need to write Excel macros within the Excel).

Re: Dealing with Excel

2005-10-18 Thread Robert Hicks
I just want to be and maybe I am not reading your response right. I am talking about reading in bunch of rows out of Oracle and writing them to an excel file, not using macros. Robert -- http://mail.python.org/mailman/listinfo/python-list

Re: Dealing with Excel

2005-10-18 Thread Thomas Bartkus
Robert Hicks [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? What does one use to bind Microsoft libraries to Python? I think it

Re: Dealing with Excel

2005-10-18 Thread Carl Friedrich Bolz
Hi! Robert Hicks wrote: I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? if it is enough to produce a file that excel can read (in contrast to a real .xls file), you could use the csv

Re: Dealing with Excel

2005-10-18 Thread McBooCzech
Robert Sorry I was not more clear in my posting. I am solving similar problem as you are. 1) I am getting my data from the Firebird SQL database - directly, using SQL commands (kinterbasdb module), not using ODBC, or ADODB or what ever - some people here can suggest you how to connect directly to

Re: Dealing with Excel

2005-10-18 Thread Robert Hicks
No, I have to format fields and everything sad to say. Another poster up the chain of this posting gave me the nudge in the direction I needed. Thanks all, Robert -- http://mail.python.org/mailman/listinfo/python-list

Re: Dealing with Excel

2005-10-18 Thread Chris Smith
Robert == Robert Hicks [EMAIL PROTECTED] writes: Robert I need to pull data out of Oracle and stuff it into an Robert Excel spreadsheet. What modules have you used to interface Robert with Excel and would you recommend it? Robert Robert For simple enough tasks, I think you can

Re: Dealing with Excel

2005-10-18 Thread Peter Hansen
Robert Hicks wrote: No, I have to format fields and everything sad to say. Another poster up the chain of this posting gave me the nudge in the direction I needed. Doesn't Excel also support (in addition to binary .xls and simple text .csv files) an XML format, which allows full access to