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