Member Avatar for BalagurunathanS

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...

Balagurunathan s

  • 2 Contributors
  • 1 Reply
  • 100 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by sarad
Member Avatar for sarad

Hi ,

I am also having the same problem. I am exporting 16 digit Acct # from Datagrid to excel in asp.net and it export 15 digit properly and place 0 for 16 digit.

Would u please tell me the solution how u did that?

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.