Export Datagrid to Excel file
-
Hi, how can i export an excel file from a datagrid. When I am exporting a set of numbers like this 54564564588956 .. the excel file is showing me as this: 5422F12 Why is this?? Can someone help me on this problem!! Its killing me :(
Adrian De Battista - Web Designer, Web Programmer, Software Programmer From Malta. My Website .. www.MaltaTrade.org
-
Hi, how can i export an excel file from a datagrid. When I am exporting a set of numbers like this 54564564588956 .. the excel file is showing me as this: 5422F12 Why is this?? Can someone help me on this problem!! Its killing me :(
Adrian De Battista - Web Designer, Web Programmer, Software Programmer From Malta. My Website .. www.MaltaTrade.org
Hello, if your DataGrid name is dgGrid then try the following code System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); DataGrid dgGrid = new DataGrid(); dgGrid.DataSource = dsExport; // Get the HTML for the control. dgGrid.HeaderStyle.Font.Bold = true; dgGrid.DataBind(); dgGrid.RenderControl(hw); // Write the HTML back to the browser. Response.ContentType = "application/vnd.ms-excel"; this.EnableViewState = false; Response.Write(tw.ToString()); Response.End();
Mehedi Hasan
-
Hello, if your DataGrid name is dgGrid then try the following code System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); DataGrid dgGrid = new DataGrid(); dgGrid.DataSource = dsExport; // Get the HTML for the control. dgGrid.HeaderStyle.Font.Bold = true; dgGrid.DataBind(); dgGrid.RenderControl(hw); // Write the HTML back to the browser. Response.ContentType = "application/vnd.ms-excel"; this.EnableViewState = false; Response.Write(tw.ToString()); Response.End();
Mehedi Hasan
Hi, The problem remains the same but :( .. when I am exporting a large set of numbers the excel is showing them as this 4433F12 and I am exporting the number like this 4433131123342342 How can i solve this problem pls :(
Adrian De Battista - Web Designer, Web Programmer, Software Programmer From Malta. My Website .. www.MaltaTrade.org