[CSV] RE: Number of lines in CSV files

[Kevin Altis]

> From: Cliff Wells
>
> Another thing that just occurred to me is that Excel has historically
> been limited in the number of rows and columns that it can import.  This
> number has increased with recent versions (I think it was 32K lines in
> Excel 97, Kevin informs me it's 64K in Excel 2000).
>
> Since export will be a feature of the CSV module, should we have some
> sort of warning or raise an exception when exporting data larger than
> the target application can handle, or should we just punt on this?

+1 on punt

The user may not actually be trying to import into Excel, they may be using
Access, later versions of Excel might support more rows, whatever. Plus,
Excel still imports the data, it just can't deal with more than 64K rows in
Excel 2000.

Now we could very well have some stats generated, maybe as a separate
function if someone wanted to know all the gritty details of which columns
of which rows contained embedded newlines, escaped characters, which rows
had an odd number of columns, total number of rows, whatever. Sort of a CSV
verifier if you will.

ka