Recent

Author Topic: exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)  (Read 1314 times)

Ericktux

  • Full Member
  • ***
  • Posts: 241
Hello friends, I am doing a project to import and read an excel spreadsheet (XLSX).
I am currently using the "sWorksheetGrid" component from the "FPSpreadsheet" palette and for the moment it works perfect for me.
The problem I have now is that it does not allow me to import a 1,000,000 row XLSX file. the limit is around 50,000.

How can I solve it please?

wp

  • Hero Member
  • *****
  • Posts: 9021
Re: exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)
« Reply #1 on: April 23, 2021, 09:24:47 am »
Are you on a 32-bit platform? There you certainly run out of memory - switch to the 64-bit Lazarus where I just confirmed that 1M rows can be written to xlsx successfully (the limitation of the file format is at 1,048,576 rows (and 16,384 columns)); it takes some time, though...

Can't resist to ask this question: With so many rows, are you sure that a spreadsheet is the correct tool?
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

Ericktux

  • Full Member
  • ***
  • Posts: 241
Re: exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)
« Reply #2 on: April 26, 2021, 12:21:28 pm »
Thanks for responding, I will do the tests and let you know friend, greetings

 

TinyPortal © 2005-2018