Dealing with Excel
larry.bates at websafe.com
Wed Oct 19 16:50:34 CEST 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.
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?
More information about the Python-list