src/org/tiefaces/components/websheet/service/WebSheetLoader.java
private List<HeaderCell> loadHeaderRowWithConfigurationTab(final SheetConfiguration sheetConfig,
			final RangeBuildRef rangeBuildRef, final int currentRow, final Map<String, CellRangeAddress> cellRangeMap,
			final List<String> skippedRegionCells) {

		Sheet sheet1 = rangeBuildRef.getSheet();
		int left = rangeBuildRef.getLeft();
		int right = rangeBuildRef.getRight();
		double totalWidth = (double) rangeBuildRef.getTotalWidth();
		Row row = sheet1.getRow(currentRow);
		List<HeaderCell> headercells = new ArrayList<>();
		for (int cindex = left; cindex <= right; cindex++) {
			String cellindex = CellUtility.getCellIndexNumberKey(cindex, currentRow);

			if (!skippedRegionCells.contains(cellindex) && !sheet1.isColumnHidden(cindex)) {
				Cell cell = null;
				if (row != null) {
					cell = row.getCell(cindex, MissingCellPolicy.CREATE_NULL_AS_BLANK);
				}
				int originRowIndex = ConfigurationUtility.getOriginalRowNumInHiddenColumn(row);
				if (cell != null) {
					FacesCell fcell = new FacesCell();

					CellUtility.convertCell(sheetConfig, fcell, cell, cellRangeMap, originRowIndex,
							parent.getCellAttributesMap(), null);
					parent.getPicHelper().setupFacesCellPictureCharts(sheet1, fcell, cell,
							WebSheetUtility.getFullCellRefName(sheet1, cell));
					CellStyleUtility.setupCellStyle(parent.getWb(), fcell, cell, row.getHeightInPoints());
					fcell.setColumnStyle(fcell.getColumnStyle()
							+ getColumnWidthStyle(sheet1, cellRangeMap, cellindex, cindex, totalWidth));
					fcell.setColumnIndex(cindex);

					headercells.add(
							new HeaderCell(Integer.toString(fcell.getRowspan()), Integer.toString(fcell.getColspan()),
									fcell.getStyle(), fcell.getColumnStyle(), CellUtility.getCellValueWithFormat(cell,
											parent.getFormulaEvaluator(), parent.getDataFormatter()),
									true, true));
				}
			}

		}
		fillToMaxColumns(headercells);
		return headercells;
	}
private List<HeaderCell> loadHeaderRowWithConfigurationTab(final SheetConfiguration sheetConfig,
			final RangeBuildRef rangeBuildRef, final int currentRow, final Map<String, CellRangeAddress> cellRangeMap,
			final List<String> skippedRegionCells) {

		Sheet sheet1 = rangeBuildRef.getSheet();
		int left = rangeBuildRef.getLeft();
		int right = rangeBuildRef.getRight();
		double totalWidth = (double) rangeBuildRef.getTotalWidth();
		Row row = sheet1.getRow(currentRow);
		List<HeaderCell> headercells = new ArrayList<>();
		for (int cindex = left; cindex <= right; cindex++) {
			String cellindex = CellUtility.getCellIndexNumberKey(cindex, currentRow);

			if (!skippedRegionCells.contains(cellindex) && !sheet1.isColumnHidden(cindex)) {
				Cell cell = null;
				if (row != null) {
					cell = row.getCell(cindex, MissingCellPolicy.CREATE_NULL_AS_BLANK);
				}
				int originRowIndex = ConfigurationUtility.getOriginalRowNumInHiddenColumn(row);
				if (cell != null) {
					FacesCell fcell = new FacesCell();

					CellUtility.convertCell(sheetConfig, fcell, cell, cellRangeMap, originRowIndex,
							parent.getCellAttributesMap(), null);
					parent.getPicHelper().setupFacesCellPictureCharts(sheet1, fcell, cell,
							WebSheetUtility.getFullCellRefName(sheet1, cell));
					CellStyleUtility.setupCellStyle(parent.getWb(), fcell, cell, row.getHeightInPoints());
					fcell.setColumnStyle(fcell.getColumnStyle()
							+ getColumnWidthStyle(sheet1, cellRangeMap, cellindex, cindex, totalWidth));
					fcell.setColumnIndex(cindex);

					headercells.add(
							new HeaderCell(Integer.toString(fcell.getRowspan()), Integer.toString(fcell.getColspan()),
									fcell.getStyle(), fcell.getColumnStyle(), CellUtility.getCellValueWithFormat(cell,
											parent.getFormulaEvaluator(), parent.getDataFormatter()),
									true, true));
				}
			}

		}
		fillToMaxColumns(headercells);
		return headercells;
	}
private List < HeaderCell > loadHeaderRowWithConfigurationTab ( final SheetConfiguration sheetConfig , final RangeBuildRef rangeBuildRef , final int currentRow , final Map < String , CellRangeAddress > cellRangeMap , final List < String > skippedRegionCells ) { Sheet sheet1 = rangeBuildRef . getSheet ( ) ; int left = rangeBuildRef . getLeft ( ) ; int right = rangeBuildRef . getRight ( ) ; double totalWidth = ( double ) rangeBuildRef . getTotalWidth ( ) ; Row row = sheet1 . getRow ( currentRow ) ; List < HeaderCell > headercells = new ArrayList <> ( ) ; for ( int cindex = left ; cindex <= right ; cindex ++ ) { String cellindex = CellUtility . getCellIndexNumberKey ( cindex , currentRow ) ; if ( ! skippedRegionCells . contains ( cellindex ) && ! sheet1 . isColumnHidden ( cindex ) ) { Cell cell = null ; if ( row != null ) { cell = row . getCell ( cindex , MissingCellPolicy . CREATE_NULL_AS_BLANK ) ; } int originRowIndex = ConfigurationUtility . getOriginalRowNumInHiddenColumn ( row ) ; if ( cell != null ) { FacesCell fcell = new FacesCell ( ) ; CellUtility . convertCell ( sheetConfig , fcell , cell , cellRangeMap , originRowIndex , parent . getCellAttributesMap ( ) , null ) ; parent . getPicHelper ( ) . setupFacesCellPictureCharts ( sheet1 , fcell , cell , WebSheetUtility . getFullCellRefName ( sheet1 , cell ) ) ; CellStyleUtility . setupCellStyle ( parent . getWb ( ) , fcell , cell , row . getHeightInPoints ( ) ) ; fcell . setColumnStyle ( fcell . getColumnStyle ( ) + getColumnWidthStyle ( sheet1 , cellRangeMap , cellindex , cindex , totalWidth ) ) ; fcell . setColumnIndex ( cindex ) ; headercells . add ( new HeaderCell ( Integer . toString ( fcell . getRowspan ( ) ) , Integer . toString ( fcell . getColspan ( ) ) , fcell . getStyle ( ) , fcell . getColumnStyle ( ) , CellUtility . getCellValueWithFormat ( cell , parent . getFormulaEvaluator ( ) , parent . getDataFormatter ( ) ) , true , true ) ) ; } } } fillToMaxColumns ( headercells ) ; return headercells ; }
Load header row with configuration tab.

@param sheetConfig
the sheet config
@param rangeBuildRef
the range build ref
@param currentRow
the current row
@param cellRangeMap
the cell range map
@param skippedRegionCells
the skipped region cells
@return the list
Load header row with configuration tab .