how i can export datagridview in ms-word,excel,pdf

Question

1.00/5 (5 votes)

See more:

ADO.NET

:omg: i m waitting u r rply. plzzzzzz hurrry....

Posted 25-Mar-10 4:54am

sumit_007

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)

jagadishgurram · Answer 1 · 2010-10-04T02:15:00

XML

dlg = new SaveFileDialog();
                   dlg.Filter = "Microsoft Excel (*.xls)|*.xls";
                   dlg.DefaultExt = "xls";
                   //dlg.Filter = "Microsoft Excel (*.doc)|*.doc";
                   //dlg.DefaultExt = "doc";
                   if (dlg.ShowDialog().Value)
                   {
                       // forming stringbuilder table
                       strBuilder.Append("<table>");
                       // Starts adding grid headers to excel
                       strBuilder.Append("<tr style='background:#7f7f7f;height:25px;'>");
                       foreach (DataGridColumn item in dtgGrid.Columns)
                       {
                           if (item.Visibility == Visibility.Visible)
                           {
                               if (item is DataGridBoundColumn)
                               {
                                   strBuilder.Append("<td><b>" + item.Header.ToString() + "</b></td><td style='width:1px;background:#000000;'></td>");
                               }
                               // checking for button control in datagridtemplatecolumn then eleminating
                               else if (item is DataGridTemplateColumn)
                               {
                                   foreach (object data in dtgGrid.ItemsSource)
                                   {
                                       FrameworkElement element = dtgGrid.Columns[GetcolumnIndex(item.Header.ToString(), dtgGrid)].GetCellContent(data) as FrameworkElement;
                                       if (element is TextBlock)
                                       {
                                           if ((element as TextBlock).Text != null)
                                               strBuilder.Append("<td><b>" + item.Header.ToString() + "</b></td><td style='width:1px;background:#000000;'></td>");
                                       }
                                       else if (element is Label)
                                       {
                                           if ((element as Label).Content != null)
                                               strBuilder.Append("<td><b>" + item.Header.ToString() + "</b></td><td style='width:1px;background:#000000;'></td>");
                                       }
                                       break;
                                   }
                               }
                           }
                       }
                       strBuilder.Append("</tr>");
                       strBuilder.Append("<tr style='height:1px;background:#000000;'></td></tr>");
                       // EOF adding grid headers to excel

                       // starts adding grid data to excel
                       // Looping every row of datagrid
                       foreach (object data in dtgGrid.ItemsSource)
                       {
                           strBuilder.Append("<tr style='background:#d8d8d8;'>");
                           // Looping every column of each row datagrid
                           foreach (DataGridColumn col in dtgGrid.Columns)
                           {
                               if (col.Visibility == Visibility.Visible)
                               {
                                   if (col is DataGridBoundColumn)
                                   {
                                       binding = (col as DataGridBoundColumn).Binding;
                                       colPath = binding.Path.Path;
                                       propInfo = data.GetType().GetProperty(colPath);
                                       if (propInfo != null)
                                       {
                                           strBuilder.Append("<td style='font:11px arial;color:black;'>" + propInfo.GetValue(data, null).ToString() + "</td><td style='width:1px;background:#000000;'></td>");
                                       }
                                   }
                                   else
                                   {
                                       FrameworkElement element = dtgGrid.Columns[GetcolumnIndex(col.Header.ToString(), dtgGrid)].GetCellContent(data) as FrameworkElement;
                                       if (element != null)
                                       {
                                           if (element is TextBlock)
                                           {
                                               if ((element as TextBlock).Text != null)
                                                   strBuilder.Append("<td style='font:11px arial;color:black;'>" + (element as TextBlock).Text + " </td><td style='width:1px;background:#000000;'></td>");
                                           }
                                           else if (element is Label)
                                           {
                                               if ((element as Label).Content != null)
                                                   strBuilder.Append("<td style='font:11px arial;color:black;'>" + (element as Label).Content + " </td><td style='width:1px;background:#000000;'></td>");
                                           }
                                           //else if (element is Button)
                                           //{
                                           //    if ((element as Button).Content != null)
                                           //        strBuilder.Append("<td style='font:11px arial;color:black;'>" + (element as Button).Content + " </td><td style='width:1px;background:#000000;'></td>");
                                           //}
                                       }
                                   }
                               }
                           }
                           strBuilder.Append("</tr>");
                           // ends Looping every column of datagrid row &
                           // adding line break
                           strBuilder.Append("<tr style='height:1px;background:#000000;'></td></tr>");
                       }
                       // EOF adding grid data to excel
                       strBuilder.Append("</table>");

                       using (Stream stream = dlg.OpenFile())
                       {
                           using (StreamWriter writer = new StreamWriter(stream))
                           {
                               writer.Write(strBuilder);
                               // closing streamwriter from writing content to a file
                               writer.Close();
                           }
                           // closing stream to release resource
                           stream.Close();
                           MessageBox.Show("Report is exported successfully");
                       }
                   }

Kschuler · Answer 2 · 2010-03-25T05:25:00

Not many people are going to respond if you demand them to hurry, nor will they respond if it seems like you are asking them to do all of your work. You must put in some effort.

If you really want help, you need to provide us with more information about your project and what problems you are having. Perhaps include some of your code. At the least you should tell us what language you are programming in.

Now, in response to your question it sounds like you are going to have to do a tie in with Microsoft Office. You could start by researching CodeProject articles that deal with Excel[^], Word[^], and PDFs[^].

Hope this helps you get started.

Gary Stafford · Answer 3 · 2010-04-04T16:08:00

I have web-based sales projection system that displays sales reports to the user in a asp:GridView. The user have the option to save it out and open in MS Excel. This is my method to accomplish the task. You can easily modify for MS Word also:

C#

private void ExportGridView()
{
    string attachment = "attachment; filename=SalesReport.xls";
    Response.ClearContent();
    Response.Charset = "";
    EnableViewState = false;
    Response.AddHeader("content-disposition", attachment);
    Response.ContentType = "application/ms-excel";
    using (HtmlForm frm = new HtmlForm())
    {
        Controls.Add(frm);
        frm.Controls.Add(gvSalesReport);
        using (StringWriter sw = new StringWriter())
        {
            using (HtmlTextWriter htw = new HtmlTextWriter(sw))
                frm.RenderControl(htw);
            Response.Write(sw.ToString());
        }
    }
    Response.End();
}

bouchachihamza · Answer 4 · 2012-03-13T11:24:00

Solution 4

i search a solution for winforms please evrybody

Posted 13-Mar-12 11:24am

bouchachihamza

how i can export datagridview in ms-word,excel,pdf

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0