C# 如何把Excle数据显示在datagrideview中

Answer 1

先读取Excel中的数据到C#中，读取出来的应该是文件流，然后再转化成DataTable，之后绑定到DataGridView就行了

Answer 2

//获取Excle数据,到变量
string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + fPath + "';Extended Properties=Excel 8.0";
OleDbConnection cnnxls = new OleDbConnection(mystring);
//conn.Open();
//OleDbCommand myCmd = null;
sql = "SELECT ClsUpId,ClsUpName FROM [Sheet1$] GROUP BY ClsUpId,ClsUpName ORDER BY ClsUpId";
OleDbDataAdapter myDa = new OleDbDataAdapter(sql, cnnxls);
DataSet myDs = new DataSet();
myDa.Fill(myDs);
DataTable dtClsUpExcel = myDs.Tables[0];

//显示在datagrideview
datagrideview1.DataSource = dtClsUpExcel;