Posted on: 3/24/2011 1:19:32 PM | Views : 253

I am trying to export data from a gridview to an excel spreadsheet. The data contains peoples names, many of which are foreign and contain special characters with accents etc. When I open the .csv file in Excel, I get Á instead of Á and é instead of é. I am opening the file in excel using Data > Import External Data > Import Data > File Origin: 65001:Unicode UTF-8
Here is my code:
public static void ExportGridToExcel(Page webPageInstance, GridView grdGridView, string fileName1)
        {
            Label Label1 = new Label();
            grdGridView.AllowPaging = false;
            grdGridView.AllowSorting = false;
            grdGridView.ForeColor = ...

Go to the complete details ...