Santhosh Subramaniam

Santhosh Subramaniam

  • NA
  • 226
  • 103.3k

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

Aug 4 2015 10:58 AM
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 . 

Answers (4)