Decimating Excel files
jean-michel bain-cornu
pythonnews at nospam.jmbc.fr
Sun Feb 4 04:31:14 EST 2007
Hi,
> We have a data acquisition program that saves its output to Excel's
> ..xls format. Unfortunately, the programmer was too stupid to write
> files the average user can read.
>
> I'd like some advice on how to go about:
> 1. Reading a large Excel file and chop it into many Excel files (with
> only 65535 lines per file)
> or
> 2. Decimate an Excel file & write... say every other line (user
> selectable)... to a new file.
>
> I'm pretty experienced at reading and writing simple text files, but
> this is my first foray into using COM. I would imagine either choice 1
> or 2 is pretty simple once I can get the file open.
When I have Excel stuff to do, I use :
http://sourceforge.net/projects/pyexcelerator
May be it can cover your needs ?
From my point of view, COM is something to avoid : no docs, lot of
investigations, weak results.
Regards
jm
More information about the Python-list
mailing list