Hi,
I have an asp.net webpage with a Datagrid (displaying english & french content) which will have to be exported to MS Excel. The exported excel looks good only for english content. The French contents are replaced by some special characters in the excel. Is there a way to overcome this issue?
Below is my code
'clean up the response.object
response.Clear()
response.Charset = ""
'set the response mime type for excel
response.ContentType = "application/vnd.ms-excel"
'create a string writer
Dim stringWrite As New System.IO.StringWriter()
'create an htmltextwriter which uses the stringwriter
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
'style to format number as string
Dim strStyle As String = "<style>.text { mso-number-format:\@; } </style>"
'tell the datagri ...
Go to the complete details ...