To Save or Open the data of Asp.net DataGrid into Excel sheet.

code to save the data of asp.net datagrid into excel sheet. excel app must be installed on client machine.

 save the data of Asp.net DataGrid in excel sheet

Note - GridAllRecord is the name of DataGrid in given code.

Response.Clear();
        Response.Buffer = true;
        Response.ContentType="application/vnd.ms-excel";
        Response.Charset = "";
        this.EnableViewState = false;
        System.IO.StringWriter  oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        GridAllRecord.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();