Datagridview export to excel using savefiledialog

Question

5.00/5 (1 vote)

See more:

hi can anyone help me in exporting a datagridview to an excel. I want to display in excel in specific format, like each row in datagridview should be displayed as columns in excel. File name should not be defined in the code behind. The user should be able to dynamically defined in the save file dialog box. Can anyone help me in code snippet which is quite simple. I used Microsoft.Office.Interop.Excel as reference
Thanks in advance

Posted 25-Aug-11 20:26pm

CyborgForever

Add a Solution

Comments

Suresh Suthar 26-Aug-11 2:30am

You want the whole code from us? Why would we do this?
If you got stuck somewhere than please post your code, we will surly help you.

maya-123 26-Aug-11 2:41am

Refer
http://www.codeproject.com/KB/grid/ExportDatagridviewToExcel.aspx

2 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)

Sergey Alexandrovich Kryukov · Answer 1 · 2011-08-25T20:56:00

This approach is wrong in principle. Don't export any controls to any documents; export data.

You should have a distinct data layer. Data layer can be bound to UI. If you don't use formal binding, the idea is the same, only implemented "manually": you populate data to you data grid, use events in your data grid to invalidate/update the data layer. In this way, you support synchronization between UI controls and data.

If this is done this way, you always use data persistence, data export/import, reporting, printing and similar functionality on data layer and never on UI controls.

I suggest you learn and analyze applicability of the following architectural patterns (http://en.wikipedia.org/wiki/Architectural_pattern_(computer_science)[^]):

MVVM — Model View View Model,
http://en.wikipedia.org/wiki/Model_View_ViewModel[^],

MVC — Model-View-Controller,
http://en.wikipedia.org/wiki/Model-view-controller[^]),

MVA — Model-View-Adapter,
http://en.wikipedia.org/wiki/Model–view–adapter[^],

MVP — Model-View-Presenter,
http://en.wikipedia.org/wiki/Model-view-presenter[^].

Pay attention for the motivation of those architectures. If you understand it, you would be able to create better design ideas.

—SA

Mankalp · Answer 2 · 2011-08-25T20:32:00

Solution 1

Please use the following code lines to export to Excel,

string attachment = "attachment; filename=Test.xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

GridView1.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

Posted 25-Aug-11 20:32pm

Mankalp

Comments

CyborgForever 26-Aug-11 2:34am

I just asked for datagridview in windwos

Suresh Suthar 26-Aug-11 2:56am

You should add/update tag WinForms.