Problem in writing from a datagrid to Excel..
-
Hi all.. I have a aspx page with a datagrid holding values in it..I need to write the datagrid values in the excel for which i use the following code.. Private Sub btnexcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnexcel.Click Response.Clear() Response.AddHeader("content-disposition", "attachment;filename=FileName.xls") Response.Charset = "" Response.Cache.SetCacheability(HttpCacheability.Public) Response.ContentType = "application/vnd.xls" Dim stringWrite As New System.IO.StringWriter Dim htmlwrite As New System.Web.UI.HtmlTextWriter(stringWrite) dtgdisplay.RenderControl(htmlwrite) Response.Write(stringWrite.ToString()) Response.End() End Sub Everything is ok..But the datagrid contains column and rows with numeric values(16 digits).So when i write it in excel i am getting them in scientific format..Even when i am formatting the cells ,i couldn't the exact values which are in the datagrid.. Someone help in this regard...
Balaguru
-
Hi all.. I have a aspx page with a datagrid holding values in it..I need to write the datagrid values in the excel for which i use the following code.. Private Sub btnexcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnexcel.Click Response.Clear() Response.AddHeader("content-disposition", "attachment;filename=FileName.xls") Response.Charset = "" Response.Cache.SetCacheability(HttpCacheability.Public) Response.ContentType = "application/vnd.xls" Dim stringWrite As New System.IO.StringWriter Dim htmlwrite As New System.Web.UI.HtmlTextWriter(stringWrite) dtgdisplay.RenderControl(htmlwrite) Response.Write(stringWrite.ToString()) Response.End() End Sub Everything is ok..But the datagrid contains column and rows with numeric values(16 digits).So when i write it in excel i am getting them in scientific format..Even when i am formatting the cells ,i couldn't the exact values which are in the datagrid.. Someone help in this regard...
Balaguru
Try this - This code is in c# and you need to use your way to get datatable instead over sqlhepler. ----------------------- string sql = 'Select * from user_MASTER'; DataTable dt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, sql); Response.AddHeader("Content-Disposition", "inline;filename=Final.xls"); int i; for (int icol = 0; icol < dt.Columns.Count; icol++) { Response.Write(dt.Columns[icol].ToString() + "\t"); } Response.Write("\n"); foreach (DataRow dr in dt.Rows) { for (i = 0; i < dt.Columns.Count; i++) { Response.Write(dr[i].ToString() + "\t"); } Response.Write("\r"); } Response.End();
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India