exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Ericktux · 2021-04-23 01:44

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 · 2021-04-23 07:24

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?

----------------------------------------------------------------------
Ericktux · 2021-04-26 10:21

Thanks for responding, I will do the tests and let you know friend,
greetings