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
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
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
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).
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
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
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
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
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
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
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
11 matches
Mail list logo