How to read multiple rows and column data in excel sheet.

See more:

C#

MS-Excel

selenium

I want to read the multiple Excel Rows and columns data. Currently i am only able to read first row and column data(A, 12) without any loop. While iterating i am not able to get the data of multiple rows and column at the same time. Below i have mentioned the excel like view. I need to get the data (a,12) and store them into two separate variables. So, that i can use them further for loading.

Col A Col B
Username Password

Row1. a 12

Row2. b 34

What I have tried:

<pre> int rCnt;
            int cCnt;
            string workbookPath = "f:\\Test\\TestData.xlsx";

            Excel.Application excelApp;
            Excel.Workbook excelWorkbook;
            Excel.Sheets excelSheets;
            Excel.Worksheet excelWorksheet;
            Excel.Range range;

            string currentSheet = "DataSet";
            
            excelApp = new Excel.Application();
            excelWorkbook = excelApp.Workbooks.Add(workbookPath);
            excelSheets = excelWorkbook.Sheets;
            excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);
            range = excelWorksheet.UsedRange;            

for (rCnt = 2; rCnt <= range.Rows.Count; rCnt++)
            {
                for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
                {
                    Loginname = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value;
                    Password = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value;
                }