How to update the huge range of data in excel sheet fastly as possible?

Sudip Rai 1 Reputation point
2022-11-11T19:53:01.673+00:00

excel sheet in the SharePoint.
The data range is about 130 column and 16000 rows.
So i did tried updating the data by dividing it into the smaller chunkz. Still its taking a lot of time, say about 30-40 minutes to update those amount of data in sheet. (Time includes fetching those data from sheet, manupulting and updating)

I am doing it programmatically using the java.
So is there any way posiible I can reduce those times.

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.