c#读取excel sheet 名称，筛选之后，跟原来的不一样

Question

c#excelsheet乱码

Answer 1

  string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=2;'";            
            OleDbConnection conn = new OleDbConnection(strConn);
            string strExcel = "";
            DataSet ds = new DataSet();
            strExcel = "select * from [sheet1$]";            
            OleDbDataAdapter da = new OleDbDataAdapter(strExcel, strConn);
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];