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

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();