I'm having issues retrieving large number of cells using ewa.workbook.getRange(). I need to retrieve about 500 rows and 46 columns (23,000 cells). When i try to do this, i nothing really happens. It does not even throw an error. I tried to reduce the number of rows and I was successful in getting about 350 rows. Is there a limit to the number or cells / rows / columns i can retrieve using the ewa.workbook.getRange() method?

What would be the best way to retrieve values these many cells from the workbook using JavaScript in SharePoint?

Any help would be appreciated! Thanks!

Hi,

According to your description, my understanding is that you want to  get large numbers of excel cell data.

Per my knowledge, if you want to handle large number data, JavaScript is not the best option to achieve it. JavaScript has data size limitation when handling large number data.

I suggest you can use OpenXML SDK to get the large number cell data.

More information:

Parsing and Reading Large Excel Files with the Open XML SDK

Thanks

Best Rgeards

Thank you.

I will try this out and let you know how it goes!