/// <summary>
/// 将Excel中的数据读入DataSet
/// </summary>
/// <param name="fileName">文件路径和文件名</param>
/// <returns>DataSet</returns>
private DataSet ReadExcel(string fileName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ fileName +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
strExcel="select * from [sheet1$]";//从默认的sheet1表中读入数据
myCommand = new OleDbDataAdapter(strExcel, strConn);
DataSet ds = new DataSet();
myCommand.Fill(ds,"Data");
conn.Close();
return ds;
}
一个c#与Excel的例子
最新推荐文章于 2016-01-12 10:20:04 发布