Posted 4 April 2023, 1:32 am EST
We are looking at ways to support editing really big files with SpreadJS and I’m reaching out in search of advice.
Given there are several ways to load data I was wondering what would be the best approach to load really big files like for example:
a) CSV file with 5 million records and 100 columns.
b) XLSX file with 1 million records and 100 columns.
(are these sizes reasonable to load in SpreadJS according to your experience?)
Any advice on how to prevent or handle out of memory errors from the browser?.
Does SpreadJS support partially loading a file? In the sense that more data is loaded when user scrolls or moves around the file.
Note: These are the ways to load data I’ve found so far: