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

Santhosh Subramaniam

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 .

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User11y ago
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 Shahi11y ago
check your thread time for this.
I think some thread takes more time to execute.
Santhosh Subramaniam11y ago
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");
Guest User11y ago
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?