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

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 l

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 f

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 th

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 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 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 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

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 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).