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

Question

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.

Yogendra Sahu · Answer

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 Koona · Answer

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); }