No of rows in Excel
807605Sep 13 2007 — edited Sep 13 2007Hi,
I have a xls file which contains 10 rows. But when i invoke the
getPhysicalNumberOfRows and getLastRowNumber method on HSSFSheet, i get values
as 224 and 223. Here's the code:
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("c:\\TEST.XLS"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
for (int i=0;i<wb.getNumberOfSheets();i++){
HSSFSheet sheet = wb.getSheetAt(i);
System.out.println("Physical number of rows: " +
sheet.getPhysicalNumberOfRows());
System.out.println("Number of rows: " + sheet.getLastRowNum());
}
I need how can i check the no of rows (fields)