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