Reading .xlsx file in c#

I'm trying to read .xlsx sheet in c# whose contents are spread over sheet. It's not a single table.Please look at the image -> http://i.stack.imgur.com/aaXxz.png

I've highlighted the things which I want to read separately, in dataTables , if possible.
I've used Following code but it only works when there is only one table is present in the sheet.

public DataSet ReadXlsx(string filepath)
{

try 
{ 
   FileStream stream = File.Open(filepath, FileMode.Open, FileAccess.Read);
    //2. Reading from a OpenXml Excel file (2007 format; *.xlsx) 
   IExcelDataReader excelReader2 = ExcelReaderFactory.CreateOpenXmlReader(stream);
    //... //4. DataSet - Create column names from first row
   excelReader2.IsFirstRowAsColumnNames = true; 
   DataSet result2 = excelReader2.AsDataSet(); return result2; 
} 
catch (Exception ex)
 { 
   return null;
 }

Please help. Thanks.

Hi,

I am using following code in my project to read the Excel file in to C# win / web.

//variables
OpenFileDialogofd=newOpenFileDialog();
OleDbConnectioncon;

on the form i have an open button which will call ofd.showdialog method.

And then i have below code.

stringconnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\'"+ofd.FileName+"\';ExtendedProperties='Excel8.0';";
if(txtFPath.Text.ToString().ToLower().Contains(".xlsx"))
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\'"+ofd.FileName+"\';ExtendedProperties='Excel12.0';";
elseif(txtFPath.Text.ToLower().Contains(".xls"))
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\'"+ofd.FileName+"\';ExtendedProperties='Excel8.0';";
con=newOleDbConnection(connectionString);
con.Open();
DataTableDtTbl=con.GetSchema("Tables");//con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);
con.Close();
CmbSheet.Items.Clear();
if(DtTbl.Rows.Count==0)
{
MessageBox.Show("Nosheetsfound.","Error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
return;
}

If you have any query please let me know.

Hope it helps.

Thanks...

Cheers...