get number of columns of a particular row in given excel using Java

Question

I want the number of columns of a particular row in excel. How is that possible? I used POI API

but I could get only columns count to 7 .

    try             {                 fileInputStream = new FileInputStream(file);                 workbook = new HSSFWorkbook(fileInputStream);                 Sheet sheet = workbook.getSheet("0");                   int numberOfCells = 0;                 Iterator rowIterator = sheet.rowIterator();                 /**                  * Escape the header row *                  */                 if (rowIterator.hasNext())                 {                     Row headerRow = (Row) rowIterator.next();                     //get the number of cells in the header row                     numberOfCells = headerRow.getPhysicalNumberOfCells();                 }                 System.out.println("number of cells "+numberOfCells);  } 

I want the number of columns at a particular row number say 10 . The excel columns are not same

Answer 1

There are two Things you can do

use

int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); 

or

int noOfColumns = sh.getRow(0).getLastCellNum(); 

There is a fine difference between them

1. Option 1 gives the no of columns which are actually filled with contents(If the 2nd column of 10 columns is not filled you will get 9)
2. Option 2 just gives you the index of last column. Hence done 'getLastCellNum()'