using System.Data.OleDb;OleDbConnection objConn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bookl.xls" +
";Extended Properties=Excel 8.0;");
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", objConn);
try
{
da.Fill(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
objConn.Close();
return;
}
dataGridView1.DataSource = ds.Tables[0];
objConn.Close();
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bookl.xls" +
";Extended Properties=Excel 8.0;");
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", objConn);
try
{
da.Fill(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
objConn.Close();
return;
}
dataGridView1.DataSource = ds.Tables[0];
objConn.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货