ExcelImportUtils { public static String convertIntIndexToString( final int index ) { return ( index / 26 > 0 ? String.valueOf( (char) ( index / 26 + 'A' - 1 ) ) : "" ) + (char) ( index % 26 + 'A' ); } 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 convertIntIndexToString() { assertEquals("A", ExcelImportUtils.convertIntIndexToString(0)); assertEquals("B", ExcelImportUtils.convertIntIndexToString(1)); assertEquals("Z", ExcelImportUtils.convertIntIndexToString(25)); assertEquals("AA", ExcelImportUtils.convertIntIndexToString(26)); assertEquals("AB", ExcelExportUtils.convertIntIndexToString(27)); assertEquals("FB", ExcelImportUtils.convertIntIndexToString(157)); }