Spreadsheet cannot parse the data number of rows 10,000.

Dear Developer,

May I know, What is the maximum number of rows in a spreadsheet?
I cannot parse the data to a spreadsheet with the number of rows 10,000 and the number of columns is one.
How do I use large data in spreadsheets?
Is there any limitation for the number of rows and columns?

I am using this:
$$(“spreadsheet”).parse(data,“json”);

Thanks,
Naing Oo

@markdigi

It would be great if you help us detect and resolve the issue by providing a sample of your data. Otherwise, the only thing we can do is to guess.
The code with test data works fine and no freezes are observed.

Please send us a sample of your data, so we could reproduce the problem.

As an employee of a Digital marketing company, I want to store more than 10K data, so I need a solution for it.

Hi, @NaingOo

The limit of the rows goes far beyond 10,000. The thing is that after ~8,000 rows the processing can be a bit slower. As I can see processing of 10k rows with dummy data is pretty smooth.

Could you please provide a sample with your data?

P.S. If your function lifts heavy calculations with a big number of cells involved it do can oppress the performance.

Update,

This is working after I had updated the spreadsheet version to “@xbs/spreadsheet”: “^8.3.2” but the page is freezing when I perform some function in the spreadsheet.

The limit of the rows goes far beyond 10,000. The thing is that after ~8,000 rows the processing can be a bit slower.
spreadsheet