How to count no. of rows in excel sheet in selenium using C#

Yogendra Sahu

I working on selenium automation using C# language, for performing crud, I am taking input from excel sheet and I have to count the total number of rows that contain data in the excel sheet.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Yogendra Sahu8y ago
I am using this to read the data from Excel sheet

and I using C# language

public static Excel._Worksheet excelworkSheets;
public static Excel.Application excelApp = new Excel.Application();
public static Excel.Workbook excelworkBook;
excelworkBook = excelApp.Workbooks.Open("E:\\Yogendra\\Yogendra Project\\iMedTrans5_Selenium\\iMedTrans5_SeleniumDatas.xlsx");
excelworkSheets = excelworkBook.Sheets[2];
Sai Kumar Koona8y ago
Hi,

You didn't mention the tool you are using to read Excel sheet but the below code will demonstrate your problem by using POI for reading excel sheet information.
public static void main(String[] args) throws IOException {

        // Making of excel file object
        File myFile = new File(CommonMethods.getFilePath("testdata", "Login.xlsx"));
        FileInputStream fis = new FileInputStream(myFile);
        XSSFWorkbook myWorkBook = new XSSFWorkbook(fis);
        XSSFSheet mySheet = myWorkBook.getSheet("Logout");
        XSSFRow row = null;

        // Making the object of excel row
        row = mySheet.getRow(0);

        int colCount = row.getLastCellNum();
        System.out.println("Column Count :- " + colCount);

        int rowCount = mySheet.getLastRowNum() + 1;
        System.out.println("Row Count :- " + rowCount);
    }