C# ado.net 导入Excel中文出现乱码，求解决办法

[MR.老刘]

以下是读取的代码：

List<string> cols = new List<string>();

            OleDbConnection conn = new OleDbConnection(string.Format(ExcelConnstring, fileName, "Excel 8.0;HDR=Yes;IMEX=1"));//处理Excel数据类型和文本类型不确定时
            conn.Open();
            //返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等 
            DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
            //取到第一个表的表名
            string strTableName = dtSheetName.Rows[0]["TABLE_NAME"].ToString();
            OleDbDataAdapter myCommand = null;
            string strSelect = "select * from [" + strTableName + "]";
            myCommand = new OleDbDataAdapter(strSelect, conn);
            string dataTableName = Path.GetFileNameWithoutExtension(fileName);

            this.DataSetImportCell.Tables.Clear();
            myCommand.Fill(DataSetImportCell, dataTableName);
            myCommand.Dispose();

            foreach (DataColumn temp in DataSetImportCell.Tables[dataTableName].Columns)
            {
                cols.Add(temp.ColumnName);
            }
            conn.Close();

读取出来的数据，中文出现乱码，但是还有一个现象，我将这个excel另存为07的格式，然后再另存为xls回来，再读取就正常了，求怎么在代码中解决这个问题。谢谢，很着急！

[uvvvw]

没遇到过，我读那么多excel文档，从来都没见过乱码情况

[deknight]

Class:

public class ExcelExport
    {
public ExcelExport(string SQLCOndition, string title)
        {

            Microsoft.Office.Interop.Excel.Application excel;
            Microsoft.Office.Interop.Excel._Workbook xBk;
            Microsoft.Office.Interop.Excel._Worksheet xSt;
            Microsoft.Office.Interop.Excel._QueryTable xQt;

            SqlConnection tmpUpdConn = new SqlConnection(@"Server=" + ConfigurationManager.AppSettings["DBAddr"].ToString() + ";Initial Catalog=" + ConfigurationManager.AppSettings["DBName"].ToString() + ";Uid=" + ConfigurationManager.AppSettings["UserName"].ToString() + ";Pwd=" + ConfigurationManager.AppSettings["UserPwd"].ToString() + ";");
            tmpUpdConn.Open();
            SqlCommand tmpUpdCmd = new SqlCommand(SQLCOndition, tmpUpdConn);
            tmpUpdCmd.CommandTimeout = 6000;
            SqlDataAdapter tmpada = new SqlDataAdapter(tmpUpdCmd);
            DataSet tmpds = new DataSet();
            tmpada.Fill(tmpds);
            System.Data.DataTable tmpt = tmpds.Tables[0];
            tmpUpdConn.Close();
           if (tmpt.Rows.Count <= 0)
            {
                CreateExcel_51.App_Code.Global.isNull = true;
                GC.Collect();
                tmpds.Dispose();
                tmpada.Dispose();
                tmpt.Dispose();
                return;
            }

            string Conn = "ODBC;DRIVER=SQL Server;SERVER=" + ConfigurationManager.AppSettings["DBAddr"].ToString() + ";UID=" + ConfigurationManager.AppSettings["UserName"].ToString() + ";PWD=" + ConfigurationManager.AppSettings["UserPwd"].ToString() + ";DATABASE=" + ConfigurationManager.AppSettings["DBName"].ToString() + "";
            string Select = SQLCOndition;
            excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
            xBk = excel.Workbooks.Add(true);
            xSt = (Microsoft.Office.Interop.Excel._Worksheet)xBk.ActiveSheet;
            xQt = xSt.QueryTables.Add(Conn, xSt.get_Range(excel.Cells[1, 1], excel.Cells[1, 1]), Select);
            xQt.Name = "";
            xQt.FieldNames = true;
            xQt.RowNumbers = false;
            xQt.FillAdjacentFormulas = false;
            xQt.PreserveFormatting = false;
            xQt.BackgroundQuery = false;
            xQt.RefreshStyle = Microsoft.Office.Interop.Excel.XlCellInsertionMode.xlInsertDeleteCells;
            xQt.AdjustColumnWidth = true;
            xQt.RefreshPeriod = 0;
            xQt.PreserveColumnInfo = true;
            xQt.Refresh(xQt.BackgroundQuery);
            string Dir = "d:\\test\\" + ConfigurationManager.AppSettings["ExcelDir"].ToString() + "\\files_";
            string FileName = CreateExcel_51.App_Code.Global.n + "_Profile.xls";

            string ExcelFileName = Dir + FileName;
            while (File.Exists(ExcelFileName))
            {
                FileName = CreateExcel_51.App_Code.Global.n + 1 + "_Profile.xls";
                ExcelFileName = Dir + FileName;
                CreateExcel_51.App_Code.Global.n += 1;
            }
            excel.ActiveWorkbook.SaveCopyAs(ExcelFileName);
            excel.DisplayAlerts = false;
            excel.Quit();
            GC.Collect();
            Console.WriteLine("xxxxxxxxx");
        }
    }

调用

DataTableToExcel.ExcelExport ex = new DataTableToExcel.ExcelExport(sql条件,"");