I`m playing with Excel export task using SpreadProcessing.
I`ve notice that when i`m using merge for cellSelection - time needed to write to workbook increases dramatically.
I made simple test - cycle with 10000 inserts operations and merges of two cells (horizontal merge).
The results for cycle:
- with merge takes 00:00:06.3593555
- without merge takes 00:00:00.1815065
var workbook = CreateWorkbook();
var worksheet = workbook.ActiveWorksheet;
i = 0; i < 10000; i++)
CellIndex cellIndex =
worksheet.Cells[i, 0, i, 2].MergeAcross();
Although, I made test with merge from 0 to 8 column. Result - 00:00:15.4579052.
Is there any workaround of such perfomance issue?