Decimating Excel files

[mensanator at aol.com]

On Feb 5, 5:46 pm, "Gabriel Genellina" <gagsl... at yahoo.com.ar> wrote:
> En Sat, 03 Feb 2007 18:52:10 -0300, mensana... at aol.com  
> <mensana... 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.

My first thought was how would that be possible?

But then, nothing's stopping someone from making
a million line .csv file (which Excel thinks it "owns")
that would be too big for Excel to open.

If that's the case, then chasing COM is barking up
the wrong tree.

> I'd try the "xlrd" package - it is capable of reading Excel files on any  
> platform.
>
> --
> Gabriel Genellina