Lazarus

Programming => Packages and Libraries => FPSpreadsheet => Topic started by: Ericktux on April 23, 2021, 03:44:40 am

Title: exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)
Post by: Ericktux on April 23, 2021, 03:44:40 am
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?
Title: Re: exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)
Post by: wp 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?
Title: Re: exceed the maximum number of rows in sWorksheetGrid (FPSpreadsheet)
Post by: Ericktux 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