search

zdavatz / spreadsheet

The Ruby Spreadsheet by ywesee GmbH
http://spreadsheet.ch
GNU General Public License v3.0
1.13k stars 240 forks source link

No read Excel rows more then 65353 #264

Closed Sega100500 closed 2 years ago

Sega100500 commented 2 years ago

No read rows from Excel more than 65535 I have Excel with rows ~88000 rows. Process stop after read row 65535 (unsigned int 2 bytes)

zdavatz commented 2 years ago
  1. Ok, interesting.
  2. What platform are you on? Windows, Mac, Linux?
  3. Which Ruby version?
  4. Can you share some code and the file?
  5. Can you open the file with LibreOffice, save it and try again?
Sega100500 commented 2 years ago

Most likely, this is a limitation of Excel 97-2003, xls extension

  1. Ok, interesting.

    1. What platform are you on? Windows, Mac, Linux?

    2. Which Ruby version?

    3. Can you share some code and the file?

    4. Can you open the file with LibreOffice, save it and try again?

Sega100500 commented 2 years ago

Most likely, this is a limitation of Excel 97-2003, xls extension

  1. Ok, interesting.

    1. What platform are you on? Windows, Mac, Linux?

    2. Which Ruby version?

    3. Can you share some code and the file?

    4. Can you open the file with LibreOffice, save it and try again?

zdavatz commented 2 years ago

Yes, that is what I also thought. Thank you.