import org.apache.poi.ss.usermodel.* import org.apache.poi.hssf.usermodel.* import org.apache.poi.xssf.usermodel.* import org.apache.poi.ss.util.* def fs = new FileInputStream ("Path to excel file") Workbook wb = WorkbookFactory.create(fs); def ws = wb.getSheet("Sheet1") def r = ws.getPhysicalNumberOfRows() log.info r