class XlsUtils {

    public static int getColumnNumberFromCellRef(String lastCell) {

        StringBuilder letters = new StringBuilder();
        // get all letters to remove row number
        StringCharacterIterator iter = new StringCharacterIterator(lastCell);
        for (char c = iter.first(); c != StringCharacterIterator.DONE; c = iter.next()) {
            if (!NumberUtils.isNumber(String.valueOf(c))) {
                letters.append(c);
            }
        }
        // use poi api to calculate column number from an excell column format
        return CellReference.convertColStringToIndex(letters.toString());

    }

    private  XlsUtils();

}