Write huge data in Excel using OpenXMLPower Tool in c#?

Question

Hi In my application i am creating excel file with huge data using OpenXML PowerTool in c# the excel file contains 7 sheets and each having 15 columns. it takes long time to generate excel file . Sno # Total Records Appr. Time 1 5452 30 Seconds 2 10452 1 mint 10 Sec 3 15452 2 mins 15 Sec 4 18549 4 mins 5 21049 5 mins 6 23545 7 Mins 7 48617 20 Mins this constant time or we can reduce time Please help me. Thanks In advance .

pritaeas · Answer

I am not familiar with OpenXML PowerTool. We use EPPlus here and it has the ability to export an entire sheet from a DataSet instead of manually looping every result and setting the cell. Perhaps your tool provides this too?

Upendra Pratap Shahi · Answer

check your thread time for this. I think some thread takes more time to execute.

Santhosh Subramaniam · Answer

Hi Pritaeas I am getting data using parallel thread but filling sheet by sheet only. It takes long time to fill the sheet no format applied Sample code : WorksheetAccessor.SetCellValue(doc sheet rowID columnID  Cell Value);

pritaeas · Answer

Perhaps there is a way to export the sheets in parallel. Do you know where the bottle neck is? Is it the filling of the sheet or perhaps additional processing or markup?

Sno	# Total Records	Appr. Time
1	5452	30 Seconds
2	10452	1 mint 10 Sec
3	15452	2 mins 15 Sec
4	18549	4 mins
5	21049	5 mins
6	23545	7 Mins
7	48617	20 Mins