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 . 

Answer 1

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?

Answer 2

check your thread time for this.

I think some thread takes more time to execute. 

Answer 3

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"); 

Answer 4

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?