in reply to only 16383 rows in Spreadsheet::ParseExcel

I have no idea on whether it's actually possible... but I doubt it. This was originally a limitiation in an old version of Excel, I think it was Excel 5.0/95. So more rows than that is actually stored internally in the file in an incompatible way. Just like the old limitation of cells to 255 characters, you occasionally get weird results if you have longer text in one cell, simply because there are several ways to store the same data in the spreadsheet.

I guess that if it was simply possible to get past the 16383 rows limitation in Spreadsheet::ParseExcel, that it then would support it transparently, without any action required from your behalf. And that's why I'm guessing that it is not possible. Not with the version of the module you have. Perhaps in the future...

But actually, it's just a guess.

  • Comment on Re: only 16383 rows in Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^2: only 16383 rows in Spreadsheet::ParseExcel
by Anonymous Monk on Apr 16, 2005 at 16:58 UTC
    Hi and Thanks,

    1st it is - I think - because of the old Excel-row-limitation.

    2nd, I don't have Windows, so an Excel-export is not possible.

    3rd, Finally I load the file into Gnumeric (all 65500 rows), but exporting to text ot csv did work, so I

    4th, copied (ctrl-c -> ctrl-v) all in several slices to an text editor and saved that.
    So I've found a solution but it make me believe that computers are s.th. very, very new.

    Have a nice weekend,
    Carl