How to export data to excel sheet

Question

0.00/5 (No votes)

See more:

I have created an application in which I have used data gridview.

Now I want to save this DataGridView's data into an excel sheet by clicking on Button
How to do this? can u help me?

Posted 13-Sep-11 19:07pm

kami124

Updated 13-Sep-11 19:50pm

Suresh Suthar

v2

Add a Solution

4 solutions

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)

Suresh Suthar · Answer 1 · 2011-09-13T19:48:00

Solution 2

Go through this article[^].

Posted 13-Sep-11 19:48pm

Suresh Suthar

Comments

Simon Bang Terkildsen 14-Sep-11 1:58am

While using office interop is a possibility it's a bad idea, it's not supported, full of bugs and and the code is not easy to read later on.
A 4 from me, I still believe a library is a better option ven if it just wraps office interop.

uspatel · Answer 2 · 2011-09-13T20:00:00

Solution 3

try to use this free dll
Export to Excel

Posted 13-Sep-11 20:00pm

uspatel

Updated 13-Sep-11 20:13pm

v2

MaulikDusara · Answer 3 · 2011-09-13T20:24:00

Solution 4

Hi,

try this.

9 Solutions to Export Data to Excel for ASP.NET[^]

Posted 13-Sep-11 20:24pm

MaulikDusara

Simon Bang Terkildsen · Answer 4 · 2011-09-13T19:16:00

Solution 1

You can do that with a 3rd party library or using office interop, I suggest you go for a 3rd party library.

A quick google search yielded http://www.libxl.com/[^] amongst others

Posted 13-Sep-11 19:16pm

Simon Bang Terkildsen

Comments

kami124 14-Sep-11 1:33am

what do u mean by 3rd party library
i create it using text.csv
but the problem over there is header filed is not saved
how to save the header

Simon Bang Terkildsen 14-Sep-11 2:05am

by 3rd party library I mean a library, a set of one or more dlls, which you get from another source, that can be an open source project or something you buy.

i create it using text.csv
So you have actually saved your data, really? I don't see that in your question would have been a good idea to include. So we could answer your actual question instead of the one you posted.