question

theaiwork-0535 avatar image
0 Votes"
theaiwork-0535 asked

Is there a way to load "n" number of rows from table iteratively in excel table office js api

I am working on developing add-in which business users will use to interact with enterprise apps. User can have thousands of records in excel sheet in table, we need to call backend API, want to do it iteratively by n (say equal 100 rows), is there a way to load only n number of rows in proxy object or it's fine to load all rows, what if number of rows are really large, like 200k, wont that cause memory issue?

office-scripts-excel-devoffice-js-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers