Hi,I am exporting data from gridview to excel file.My problem is that for all the string which contain "+", the rest of data begining from it is missing in excel file.For example: PWE-WER+78, when exported it will become PWE-WER.Below is my code. Response.ClearContent()
Response.Buffer = True
Response.AddHeader("Content-Disposition", "attachment;filename=" & "ExportedExcel.xls")
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
lobjStringWriter = New StringWriter
lobjHtmlWriter = New HtmlTextWriter(lobjStringWriter)
Response.End() I have search through online but no solution.Does anyone has idea on this?
View Complete Post