Dealing with Excel
Larry Bates
larry.bates at websafe.com
Wed Oct 19 10:50:34 EDT 2005
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 for later re-use.
If you want, you can automate this process using Python
COM+ interface to Excel.
Larry Bates
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
>
More information about the Python-list
mailing list