Code:

xlApp = New Excel.ApplicationClass
xlWorkBook = xlApp.Workbooks.Open("c:\vbexcel.xlsx")
xlWorkSheet = xlWorkBook.Worksheets("sheet1")

range = xlWorkSheet.UsedRange

For rCnt = 1 To range.Rows.Count
For cCnt = 1 To range.Columns.Count
Obj = CType(range.Cells(rCnt, cCnt), Excel.Range)
MsgBox(Obj.value)
Next
Next

Code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace MyTry
{
    public partial class Form1 : Form
    {
        BindingSource tblNameBs = new BindingSource();
        
        public Form1()
        {
            InitializeComponent();
        }

        private void btnImport_Click(object sender, EventArgs e)
        {
            try
            {
                OleDbConnection conn = new OleDbConnection();
                conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\Cp\My Documents\MyExample.xlsm" + @";Extended Properties=""Excel 12.0 Macro;HDR=Yes;IMEX=1;ImpoertMixedTypes=Text;TypeGuessRows=0""";

                string comm = "select * from [MyRangeNameOne]";

                String comm2 = "select * from [MyRangeNameTwo]";

                OleDbCommand command = new OleDbCommand(comm, conn);
                OleDbCommand command2 = new OleDbCommand(comm2, conn);


                DataSet dsDvds = new DataSet();
                DataSet dsDvds2 = new DataSet();

                OleDbDataAdapter adapter = new OleDbDataAdapter(command);
                OleDbDataAdapter adapter2 = new OleDbDataAdapter(command2);

                OleDbCommandBuilder Builder = new OleDbCommandBuilder(adapter);
                OleDbCommandBuilder Builder2 = new OleDbCommandBuilder(adapter2);

                adapter.Fill(dsDvds);
                

                dtgViewTab1.DataSource = dsDvds.Tables[0];
                tblNameBs.DataSource = dsDvds.Tables[0];

           

                adapter2.Fill(dsDvds2);
                
                dtgViewTab2 .DataSource = dsDvds2.Tables[0];
                
                tblNameBs.DataSource = dsDvds2.Tables[0];
          
            }

            catch (Exception ex)
            {
                MessageBox.Show("Error Occurs: "+ex .ToString ());
            }
    
        }
    }
}