Community discussion forum

Back to discussion

How to Export Datagridview contents to Excel

Last post was 04 Nov 2009 at 13:35
Tags: csharp, db Nigeria
  • 1 year ago

    I have to export the data present in the datagridview to Microsoft Excel.  It is a window application using c#.  Does anyone know how to do it.  Please help.

    Thanks

     

    Report abuse
  • 1 year ago

    See DataGridView Extension from CompletIT - it's free and you can export to Excel, tml, Pdf and do 1000 more things ;)

    Report abuse
  • 1 year ago

    I think this would be useful

     

    Response.Clear()
            Response.AddHeader("content-disposition", "attachment;filename=filename.xls")
            Response.Charset = ""
            Response.Cache.SetCacheability(HttpCacheability.NoCache)
            Response.ContentType = "application/vnd.xls"
            Dim stringWrite As New System.IO.StringWriter
            Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
            Dim dGrid As New DataGrid
            dGrid.DataSource = tempDataset
            dGrid.DataBind()

            dGrid.RenderControl(htmlWrite)
            Response.Write(stringWrite.ToString())
            Response.End()

    Report abuse
  • 1 year ago

    By using C# is it possible to use the code you have given??

    Report abuse
  • 1 year ago

     Hi Nitin,

    Check this link you can get some help from this link. 

    http://www.eggheadcafe.com/community/aspnet/2/10017590/export-to-excel.aspx 

    Report abuse
  • 1 year ago

    hi nitin004 ,
    You can easily export content of DataGridView to Excel sheet. There are several articles based on it.
    Just checkout the given links.

    http://www.codeproject.com/KB/database/ExportDataToExcelUsingCS.aspx
    http://www.codeproject.com/KB/office/office_automation.aspx
    http://www.codeproject.com/KB/cs/export2excel.aspx
    http://www.codeproject.com/KB/dotnet/ExportToExcel.aspx?df=100&forumid=146533&exp=0&select=1357703
    http://www.dotnetspider.com/qa/Question45425.aspx

    Or just checkout the given code. 

    Microsoft.Office.Interop.Excel.Application wapp;
    Microsoft.Office.Interop.Excel.    Worksheet wsheet;
    Microsoft.Office.Interop.Excel.    Workbook wbook;
    wapp =     new Microsoft.Office.Interop.Excel.Application();
    wapp.Visible =     false;
    wbook = wapp.Workbooks.Add(    true);
    wsheet = (    Worksheet)wbook.ActiveSheet;
    try
    {
       int iX;
       int iY;
       for (int i = 0; i < this.DataGridResults.Columns.Count; i++)
       {
           wsheet.Cells[1, i + 1] =     this.DataGridResults.Columns[i].HeaderText;
           wsheet.Font.Bold =     true;
       }

       for (int i = 0; i < this.DataGridResults.Rows.Count; i++)
       {      
           DataGridViewRow     row = this.DataGridResults.Rows[i];
               for (int j = 0; j < row.Cells.Count; j++)
           {
                   DataGridViewCell cell = row.Cells[j];
                   try
                   {
                       wsheet.Cells[i + 2, j + 1] = (cell.Value ==     null) ? "" : cell.Value.ToString();
               }
                   catch (Exception ex)
               {
                          MessageBox.Show(ex.Message);
               }
            }
        }
        wapp.Visible =     true;
     }
         catch (Exception ex1)
     {
              MessageBox.Show(ex1.Message);
     }
    wapp.UserControl =     true;

    Hope this will help you.
    Thanks & Regards
    Dilipv

    Report abuse
  • 1 year ago
    I developed this function which i think is fantastic and wants to share it with the rest of the world: //fxn that exports content of a datagridview object to an excel file public static void export_datagridview_to_excel(DataGridView dgv, string excel_file) { int cols; //open file StreamWriter wr = new StreamWriter(excel_file); //determine the number of columns and write columns to file cols = dgv.Columns.Count; for (int i = 0; i < cols; i++) { wr.Write(dgv.Columns[i].Name.ToString().ToUpper() + "\t"); } wr.WriteLine(); //write rows to excel file for (int i = 0; i < (dgv.Rows.Count - 1); i++) { for (int j = 0; j < cols; j++) { if (dgv.Rows[i].Cells[j].Value != null) wr.Write(dgv.Rows[i].Cells[j].Value + "\t"); else { wr.Write("\t"); } } wr.WriteLine(); } //close file wr.Close(); }
    Report abuse
  • 1 year ago
    //please import: System.IO
    Report abuse
  • 19 days ago

    Hi!

    You can certainly do this with Excel Automation, but I suggest not to use it. For details see Excel Interop issues.

    Try to find some 3rd party library that reads and writes Excel files without use of Excel Automation.

    I use GemBox.Spreadsheet for some time now, and it is great. It is very fast and easy to use.

    Here is an example how to export DataGrid to Excel with GemBox.Spreadsheet library.

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

Ask a question

Related discussion

Quick links

Recent activity

Languages

Web Development

Frameworks & Architecture

Other major sections

Cancel
Want to stay in touch with what's going on? Follow us on twitter!