Newbie : Python and Excel

drs drs at ecp.cc
Sat May 24 17:24:40 EDT 2003


"LeMAS" <3141 at laposte.net> wrote in message
news:Xns9385E440C28AC3141lapostenet at 193.252.19.141...
> i'm trying to save an excel file to a CVS txt file format thru the com
> client interface and it's going pretty bad !!
>
>
> Any clues ?

2 good ways to do this ...

1. open the excel file and record a macro saving a file as a cvs file.
Then, look at the recorded VBA and translate it into python.

2. grab the data via ADO and output it to a CVS file bypassing excel.

-d






More information about the Python-list mailing list