ExcelImportUtils { public static int convertStringIndexToInt( final String strIndex ) { return convertStringIndexToIntRecurs( strIndex ) - 1; } private  ExcelImportUtils(); static int convertStringIndexToInt( final String strIndex ); static String convertIntIndexToString( final int index ); static Date getDate( final Cell cell ); static String getString( final Cell cell ); static Double getDouble( final Cell cell ); static Integer getInteger( final Cell cell ); static Long getLong( final Cell cell ); static Workbook loadWorkbook( final InputStream io ); static Workbook loadWorkbook( final InputStream io, WorkbookSettings settings );  }
@Test public void testConvertStringIndexToInt() { assertEquals(0, ExcelImportUtils.convertStringIndexToInt("A")); assertEquals(1, ExcelImportUtils.convertStringIndexToInt("B")); assertEquals(25, ExcelImportUtils.convertStringIndexToInt("Z")); assertEquals(26, ExcelImportUtils.convertStringIndexToInt("AA")); assertEquals(27, ExcelExportUtils.convertStringIndexToInt("AB")); assertEquals(157, ExcelImportUtils.convertStringIndexToInt("FB")); }