I have a product where I’m collecting data from a database and, after some massaging, plotting the data into excel via Aspose’s Cell.
One of the largest bottlenecks I have right now is the amount of time it takes for the InsertColumn or InsertRow to execute.
The code executes in this fashion:
foreach (output item in masterList)
Find out which line is my starting point and plot the values for each column (IE: data needs to be plotted at row 6, start there, do B6, C6, D6)
If we’re bursting data, we need to insert a row at B6 and plot the data again.
Repeat for the loop about 3 thousand times.
If more information is needed, I would be glad to provide it.
I’m looking for advice on how I may optimize this process.