1. 打开文件获取到FilePath;
2. 读取Sheet名称TABLENAME;
3. 将数据Fill到DataSet中;
public DataSet ExcelToDataSet(string filePath, string TABLENAME)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
DataSet ds = new DataSet();
strExcel = "select * from [" + TABLENAME + "$]";
OleDbDataAdapter myCommand = new OleDbDataAdapter(strExcel, strConn);
myCommand.Fill(ds, "table1");
return ds;
}