public final void buildCategoryList ( final CTAxDataSource ctAxDs ) { List < ParsedCell > cells = new ArrayList <> ( ) ; try { String fullRangeName = ctAxDs . getStrRef ( ) . getF ( ) ; String sheetName = WebSheetUtility . getSheetNameFromFullCellRefName ( fullRangeName ) ; CellRangeAddress region = CellRangeAddress . valueOf ( WebSheetUtility . removeSheetNameFromFullCellRefName ( fullRangeName ) ) ; for ( int row = region . getFirstRow ( ) ; row <= region . getLastRow ( ) ; row ++ ) { for ( int col = region . getFirstColumn ( ) ; col <= region . getLastColumn ( ) ; col ++ ) { cells . add ( new ParsedCell ( sheetName , row , col ) ) ; } } } catch ( Exception ex ) { LOG . log ( Level . FINE , "failed in buildCategoryList" , ex ) ; } this . setCategoryList ( cells ) ; }
build categotry list .