Excel数据导入到Grid

 方法一：

private void ExcelToDataGrid()
{
 string strSource = Server.MapPath("../xls_bang/bang.xls")；//"d://vba.xls";//File1.Value;

 string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strSource + ";Extended Properties=Excel 8.0";
 string query = "select * from [Sheet1$]";//Sheet1表示表

 OleDbConnection oleCon=new OleDbConnection(strCon);
 OleDbCommand oleCommand = new OleDbCommand(query, oleCon);
 OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
 DataSet ds = new DataSet();

 // 将 Excel 的[Sheet1]表内容填充到 DataSet 对象
 oleAdapter.Fill(ds);

 // 数据绑定
 DataGrid1.DataSource=ds;
 DataGrid1.DataBind();
}

方法二：（与一相差不大）

   string strSource = File1.Value;

   string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strSource + ";Extended Properties=Excel 8.0";
   string query = "SELECT * FROM [Sheet1$]";//Sheet1表示表

   OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(ConnStr));
   OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
   DataSet myDataSet = new DataSet();

   // 将 Excel 的[Sheet1]表内容填充到 DataSet 对象
   oleAdapter.Fill(myDataSet, "[Sheet1$]");

   // 数据绑定
   DataGrid1.DataSource = myDataSet;
   DataGrid1.DataMember = "[Sheet1$]";
   DataGrid1.DataBind();