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

Sudip Rai 1 Reputation point

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.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,702 questions
0 comments No comments
{count} votes