I want export to excel more than 3 lakhs(hundred thousands) records, is there any othere way in .NET to do that?

Question

1.00/5 (1 vote)

See more:

Dear Friends,

In my application there is situation to export to excel more than 3 lakhs records. so far I did through below link.

Export DataTable to Excel with Formatting in C#[^]

But it is getting lots of time to export and open that excel file. Please share your thoughts is there any way to do that. It is very urgent for me.

Thanks,
Ram.

Posted 26-May-14 4:01am

sethupathiram

Updated 26-May-14 5:42am

Manikandan10

v3

Add a Solution

Comments

phil.o 26-May-14 10:07am

Urgency is only relevant to you, not to us, sorry.
Rember we participate here on our own time ; stating your urgency is considered as rude.
Moreover, here is not a code-ordering site ; no one is going to write a full export library for you.
Finally, don't you think handling that much records in an excel file is the problem per se?

sethupathiram 27-May-14 4:44am

When you face similar kind of situation like that then you will realize. Untill unless you not aware of that. Dont you try to show diplomaitc answer.

phil.o 27-May-14 4:56am

Ain't no more deaf than who doesn't want to listen.
Good luck, anyway.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NewPast · Answer 1 · 2014-05-26T04:11:00

Solution 1

try to use string builder
* store each 100 record in the string builder then export the 100 record response object
* flush content after each response write

Posted 26-May-14 4:11am

NewPast

Comments

sethupathiram 27-May-14 3:28am

Yeah i aggree your thoughts. if we do that throught stringbuilder, can we have do format and apply style over excel through our progrming. Please share sample link..

Thanks,
Ram