@Test
public void col_number_from_cell_ref() throws Exception {

    Assertions.assertThat(XlsUtils.getColumnNumberFromCellRef("A5")).isEqualTo(0);
    Assertions.assertThat(XlsUtils.getColumnNumberFromCellRef("D5")).isEqualTo(3);
    Assertions.assertThat(XlsUtils.getColumnNumberFromCellRef("A15")).isEqualTo(0);
    Assertions.assertThat(XlsUtils.getColumnNumberFromCellRef("AG142")).isEqualTo(32);
    Assertions.assertThat(XlsUtils.getColumnNumberFromCellRef("BB11")).isEqualTo(53);
}