C # how to import data from datagride to excel

lajx626

Using C # as a website, I want to import the data in the datagride of the client into Excel by clicking the button. How can I achieve this?

lin3412048

/// <summary>
/// export to Excel
/// </ summary>
/// <param name = "sender"> </ param>
/// <param name = "e"> </ param>
private void Button1_Click (object sender, System.EventArgs e)
{
Response.Clear ();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader ("Content-Disposition", "attachment; filename = FileName.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding ("GB2312"); // Set the output stream to Simplified Chinese
Response.ContentType = "application / ms-excel"; // Set the output file type to an excel file.
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo ("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter (myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter (oStringWriter);
this.DataGrid1.RenderControl (oHtmlTextWriter);
Response.Write (oStringWriter.ToString ());
Response.End ();
}

pyonus

private void HtmlToExcel (string FileType, string FileName)
        {
            Response.Clear ();
            Response.Charset = "utf-8";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding ("utf-8");
            Response.AppendHeader ("Content-Disposition", "attachment; filename =" + Server.UrlEncode (FileName));
            Response.ContentType = FileType;
            this.EnableViewState = false;
            StringWriter tw = new StringWriter ();
            HtmlTextWriter hw = new HtmlTextWriter (tw);
            divtest.RenderControl (hw);
            Response.Write (tw.ToString ());
            Response.End ();
}



// Then call this function in the button:
HtmlToExcel ("application / ms-excel", "Test.xls"); // where "Test.xls" is the file name of EXCEL

pyonus

Hehe, I forgot to tell the landlord to change the "divtest" in the code I posted to the DataGrid name.

qwer000

The easiest way is to take datagird1.innerHTML (or outerHTML) from the page, saveas into an xsl file, the format data is all there, and excel can parse the html

lajx626

Thank you very much.