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

Question

In Excel, I need to know how many columns make up a specific row. How is that even doable? I applied POI API.

but I could only increase the number of columns 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 to know how many columns there are at, let's say, row 10. The columns in Excel are different.

Answer 1

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 that 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 the last column. Hence done 'getLastCellNum()'