public DataSet ImportFromExcel(string filePath)

{

DataSet ds = new DataSet();

string connString = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + filePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";

DataTable table = OleDbHelper.GetExcelTables(connString);

if(table == null || table.Rows.Count <= 0)

{

return null;

}

foreach(DataRow dr in table.Rows)

{

string cmdText = "select * from [" + dr["TABLE_NAME"].ToString() + "]";

DataTable dt = OleDbHelper.FillDataTable(connString, cmdText);

dt.TableName = dr["TABLE_NAME"].ToString();

ds.Tables.Add(dt);

}

return ds;

}