Newbie - Exporting Excel Spreadsheet

Marc Poulin marc at verinet.com
Thu Dec 6 05:50:06 CET 2001


You might want to look at this:
http://www.python.org/windows/win32com/

(I guess I'm a little surprised that you are using 
ODBC and SQL to retrieve data from a spreadsheet.)

Marc

In article <673dc1dc.0112051334.370c75f2 at posting.google.com>, "James
Fugard" <jfugard at traq.com> wrote:

> TIA for any help that I may get. I have a small project that I'm trying
> to do in Python...and I'm a hack at best! Here is what I'm trying to do.
> Call and capture a row in an Excel spreadsheet and then use manipulate
> the data in the cell of the various columns.
> 
> Here is what I've been able to get some far:
> 
> # Call all used modules
> import os,win32api,glob,odbc,dbi,time # Make the database connection
> using the system DNS MyConnection = odbc.odbc('Client_Data_Log')
> MyCursor = MyConnection.cursor()
> MyCursor.execute('SELECT * FROM "Client Data Log$"') # the sheet name
> print MyCursor.fetchall()
> 
> This will give me everything + a bunch of dbi time stuff. If someone
> could tell me where to find info on calling a particular cell or a piece
> of sample code to follow(like G12 for example) that would be great.
> Thanks again. James



More information about the Python-list mailing list