Examples of HSSFCellStyle

      e.printStackTrace();
    }
  }
  
  private void createMitarbSumRows(Mitarbeiter mitarb){
    HSSFCellStyle sumCellStyle = myWorkBook.createCellStyle();
    sumCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    sumCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    sumCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
    sumCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
    
    HSSFCellStyle sumLeftCellStyle = myWorkBook.createCellStyle();
    sumLeftCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    sumLeftCellStyle.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM);
    sumLeftCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
    sumLeftCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
    
    HSSFCellStyle sumEuroCellStyle = myWorkBook.createCellStyle();
    sumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    sumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    sumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    sumEuroCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
    sumEuroCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
    
    HSSFCellStyle sumRightEuroCellStyle = myWorkBook.createCellStyle();
    sumRightEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    sumRightEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
    sumRightEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
    sumRightEuroCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM);
    sumRightEuroCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
    
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
    
    myCell = myRow.createCell(0);
    myCell.setCellValue(mitarb.getIdName());

      //prepare source format row
      final int srcRownum = n <= 0 ? -1 : copyOrigin == Range.FORMAT_RIGHTBELOW ? startRow : copyOrigin == Range.FORMAT_LEFTABOVE ? startRow - 1 : -1;
      final HSSFRow srcRow = srcRownum >= 0 ? getRow(srcRownum) : null;
      final Map<Integer, Cell> srcCells = srcRow != null ? BookHelper.copyRowCells(srcRow, srcRow.getFirstCellNum(), srcRow.getLastCellNum()) : null;
      final short srcHeight = srcRow != null ? srcRow.getHeight() : -1;
      final HSSFCellStyle srcStyle = srcRow != null ? srcRow.getRowStyle() : null;
      
        int s, inc;
        if (n < 0) {
            s = startRow;
            inc = 1;

Examples of HSSFCellStyle

Examples of org.apache.poi.hssf.usermodel.HSSFCellStyle

Examples of org.zkoss.poi.hssf.usermodel.HSSFCellStyle