Get columns' names in Excel file using Apache POI

Question

How to get the column names in an Excel file using Apache POI, to make sure that the columns are ordered as expected.

Answer 1

There is a convenience method for this:

CellReference.convertNumToColString(cell.getColumnIndex());

To get the full name:

private static String getCellName(Cell cell)
{
    return CellReference.convertNumToColString(cell.getColumnIndex()) + (cell.getRowIndex() + 1);
}