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

Hi Chetan,

 

Please see the below links.

 

https://pauliom.com/2009/04/30/how-to-remove-items-from-a-bound-list-box-or-how-to-avoid-operation-not-supported-on-read-only-collection/