参考一下这个吧!
/// <summary>
/// 将Excel保存到DataSet
/// </summary>
/// <param name="file">Excel文件</param>
/// <returns></returns>
private static DataSet ImportExcel(string file)
{
DataSet dsExcel = new DataSet();
FileInfo fileinto = new FileInfo(file);
if (!fileinto.Exists)
return null;
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file +
";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"; OleDbConnection conn = new OleDbConnection(strConn); try
{
conn.Open();
string strSql = "select * from [Cy_BigType$]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
da.Fill(dsExcel);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
return dsExcel;
}
/// <summary>
/// 将Excel保存到DataSet
/// </summary>
/// <param name="file">Excel文件</param>
/// <returns></returns>
private static DataSet ImportExcel(string file)
{
DataSet dsExcel = new DataSet();
FileInfo fileinto = new FileInfo(file);
if (!fileinto.Exists)
return null;
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file +
";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"; OleDbConnection conn = new OleDbConnection(strConn); try
{
conn.Open();
string strSql = "select * from [Cy_BigType$]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
da.Fill(dsExcel);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
return dsExcel;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货