How to get the last column index reading excel file?

Question

How do i get the index of the last column when reading a xlsx file using the Apache POI API?

There's a getLastRowNum method, but I can't find nothing related to the number of columns...

EDIT: I'm dealing with XLSX files

Answer 1

I think you'll have to iterate through the rows and check HSSFRow.getLastCellNum() on each of them.

Answer 2

Check each Row and call Row.getLastCellNum() the max cell number is the last column number.

Row r = sheet.getRow(rowNum);
int maxCell=  r.getLastCellNum();