Decimating Excel files
Gabriel Genellina
gagsl-py at yahoo.com.ar
Mon Feb 5 18:46:45 EST 2007
En Sat, 03 Feb 2007 18:52:10 -0300, mensanator at aol.com
<mensanator at aol.com> escribió:
> On Feb 3, 1:43?pm, gonzlobo <gonzl... at gmail.com> wrote:
>> 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)
>
> An Excel sheet only has 65535 lines. Or do yo mean it has
> multiple sheets?
As I understand the problem, the OP has a program that generates the .xls
files, but it's so dumb that writes files too large for Excel to read.
I'd try the "xlrd" package - it is capable of reading Excel files on any
platform.
--
Gabriel Genellina
More information about the Python-list
mailing list