New answers tagged encoding
I know that's not the best solution and that's just a patch... but it gets the job done! It's important that you put some comments in your code telling why you do that. So, after GridView2.RenderControl(htmlTextWriter);, try htmlTextWriter.Position = 0; string correctedXLS = new StreamReader(htmlTextWriter).ReadToEnd(); correctedXLS = ...
It should be possible by using the File -> Advanced Save Options.. menu in Visual Studio when you have opened the file with incorrect encoding. I think Western Europe (1252) should work as well in your scenario, besides UTF-8
Ignore the '&' character and try i.e. for list named AT&T, try ATT.
Top 50 recent answers are included