List of usage examples for org.apache.poi.ss.usermodel Font U_NONE
byte U_NONE
To view the source code for org.apache.poi.ss.usermodel Font U_NONE.
Click Source Link
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.customize.ExcelReportWriter.java
License:Apache License
private void setFormats() throws IOException { // Set title format Font titleFont = this.workbook.createFont(); titleFont.setUnderline(Font.U_NONE); titleFont.setFontName("Times"); titleFont.setFontHeightInPoints((short) 14); titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD); titleFont.setColor(IndexedColors.BLACK.getIndex()); this.titleStyle = this.workbook.createCellStyle(); titleStyle.setFont(titleFont);//w w w .j a v a 2s .c o m titleStyle.setWrapText(false); // Set header format Font headerFont = this.workbook.createFont(); headerFont.setUnderline(Font.U_NONE); headerFont.setFontName("Times"); headerFont.setFontHeightInPoints((short) 11); headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD); headerFont.setColor(IndexedColors.BLACK.getIndex()); this.headerStyle = this.workbook.createCellStyle(); headerStyle.setFont(headerFont); headerStyle.setWrapText(true); headerStyle.setFillPattern(CellStyle.SOLID_FOREGROUND); headerStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); headerStyle.setBorderBottom(CellStyle.BORDER_THIN); headerStyle.setBorderRight(CellStyle.BORDER_THIN); headerStyle.setBorderTop(CellStyle.BORDER_THIN); headerStyle.setBorderLeft(CellStyle.BORDER_THIN); // Set content format Font font = this.workbook.createFont(); font.setFontName("Arial"); font.setFontHeightInPoints((short) 10); this.stringStyle = this.workbook.createCellStyle(); stringStyle.setAlignment(CellStyle.ALIGN_LEFT); stringStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER); this.intStyle = this.workbook.createCellStyle(); intStyle.setAlignment(CellStyle.ALIGN_LEFT); intStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER); // Set money format String moneyFormatString = CurrencyThreadLocal.getMoneyFormatString(); DataFormat moneyFormat = this.workbook.createDataFormat(); this.moneyStyle = this.workbook.createCellStyle(); moneyStyle.setDataFormat(moneyFormat.getFormat(moneyFormatString)); moneyStyle.setWrapText(false); // Set total format Font totalFont = this.workbook.createFont(); totalFont.setUnderline(Font.U_NONE); totalFont.setFontName("Arial"); totalFont.setFontHeightInPoints((short) 10); totalFont.setBoldweight(Font.BOLDWEIGHT_BOLD); totalFont.setColor(IndexedColors.BLACK.getIndex()); this.totalStyle = this.workbook.createCellStyle(); totalStyle.setFont(totalFont); totalStyle.setWrapText(true); totalStyle.setBorderTop(CellStyle.BORDER_THIN); totalStyle.setBorderBottom(CellStyle.BORDER_THIN); totalStyle.setFillPattern(CellStyle.SOLID_FOREGROUND); totalStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); // Set total money format this.totalMoneyStyle = this.workbook.createCellStyle(); totalMoneyStyle.setDataFormat(moneyFormat.getFormat(moneyFormatString)); totalMoneyStyle.setWrapText(false); totalMoneyStyle.setBorderTop(CellStyle.BORDER_THIN); totalMoneyStyle.setBorderBottom(CellStyle.BORDER_THIN); totalMoneyStyle.setFillPattern(CellStyle.SOLID_FOREGROUND); totalMoneyStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.CharacterCountReportGenerator.java
License:Apache License
/** * Add title to the sheet//from ww w.j a va2 s . c om * * @param p_workBook * @param p_sheet * the sheet * @throws Exception */ private void addTitle(Workbook p_workBook, Sheet p_sheet) throws Exception { ResourceBundle bundle = m_bundle; // Title font is black bold on white Font titleFont = p_workBook.createFont(); titleFont.setUnderline(Font.U_NONE); titleFont.setFontName("Times"); titleFont.setFontHeightInPoints((short) 14); titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD); CellStyle cs = p_workBook.createCellStyle(); cs.setFont(titleFont); Row titleRow = getRow(p_sheet, 0); Cell titleCell = getCell(titleRow, 0); titleCell.setCellValue(bundle.getString("character_count_report")); titleCell.setCellStyle(cs); }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.CommentsAnalysisReportGenerator.java
License:Apache License
private CellStyle getHeaderStyle(Workbook p_workbook) { if (headerStyle == null) { Font font = p_workbook.createFont(); font.setBoldweight(Font.BOLDWEIGHT_BOLD); font.setColor(IndexedColors.BLACK.getIndex()); font.setUnderline(Font.U_NONE); font.setFontName("Times"); font.setFontHeightInPoints((short) 11); CellStyle cs = p_workbook.createCellStyle(); cs.setFont(font);// w w w . jav a 2s.c o m cs.setWrapText(true); cs.setFillPattern(CellStyle.SOLID_FOREGROUND); cs.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); cs.setBorderTop(CellStyle.BORDER_THIN); cs.setBorderRight(CellStyle.BORDER_THIN); cs.setBorderBottom(CellStyle.BORDER_THIN); cs.setBorderLeft(CellStyle.BORDER_THIN); headerStyle = cs; } return headerStyle; }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.CommentsAnalysisReportGenerator.java
License:Apache License
private CellStyle getTitleStyle(Workbook p_workBook) { if (titleStyle == null) { // Title font is black bold on white Font titleFont = p_workBook.createFont(); titleFont.setUnderline(Font.U_NONE); titleFont.setFontName("Times"); titleFont.setFontHeightInPoints((short) 14); titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD); CellStyle cs = p_workBook.createCellStyle(); cs.setFont(titleFont);// ww w . java 2 s . c o m titleStyle = cs; } return titleStyle; }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.ImplementedCommentsCheckReportGenerator.java
License:Apache License
private CellStyle getRedRightStyle(Workbook p_workbook) throws Exception { CellStyle style = p_workbook.createCellStyle(); Font font = p_workbook.createFont(); if (hightLightRightStyle == null) { font.setBoldweight(Font.BOLDWEIGHT_BOLD); font.setColor(IndexedColors.BLACK.getIndex()); font.setUnderline(Font.U_NONE); font.setFontName("Arial"); font.setFontHeightInPoints((short) 10); style.setWrapText(true);/* w w w.j a v a 2 s.c o m*/ style.setAlignment(CellStyle.ALIGN_RIGHT); style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); style.setFillPattern(CellStyle.SOLID_FOREGROUND); style.setFillForegroundColor(IndexedColors.ROSE.getIndex()); hightLightRightStyle = style; } return hightLightRightStyle; }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.ImplementedCommentsCheckReportGenerator.java
License:Apache License
private CellStyle getRedStyle(Workbook p_workbook) throws Exception { CellStyle style = p_workbook.createCellStyle(); Font font = p_workbook.createFont(); if (hightLightStyle == null) { font.setBoldweight(Font.BOLDWEIGHT_BOLD); font.setColor(IndexedColors.BLACK.getIndex()); font.setUnderline(Font.U_NONE); font.setFontName("Arial"); font.setFontHeightInPoints((short) 10); style.setWrapText(true);/* ww w .ja v a 2s . c o m*/ style.setAlignment(CellStyle.ALIGN_LEFT); style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); style.setFillPattern(CellStyle.SOLID_FOREGROUND); style.setFillForegroundColor(IndexedColors.ROSE.getIndex()); hightLightStyle = style; } return hightLightStyle; }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportForIPTranslatorGenerator.java
License:Apache License
private void addTitle(Workbook p_workbook, Sheet p_sheet) throws Exception { String EMEA = CompanyWrapper.getCurrentCompanyName(); Font titleFont = p_workbook.createFont(); titleFont.setUnderline(Font.U_NONE); titleFont.setFontName("Arial"); titleFont.setFontHeightInPoints((short) 14); titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD); CellStyle titleStyle = p_workbook.createCellStyle(); titleStyle.setWrapText(false);//from ww w . j ava 2 s . c o m titleStyle.setFont(titleFont); Row firRow = getRow(p_sheet, 0); Cell titleCell = getCell(firRow, 0); titleCell.setCellValue(EMEA + " " + m_bundle.getString("online_jobs_for_ip_translator")); titleCell.setCellStyle(titleStyle); p_sheet.setColumnWidth(0, 20 * 256); }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportForIPTranslatorGenerator.java
License:Apache License
private void addTotalsPerLang(Workbook p_workbook, Sheet p_sheet, final int p_sheetCategory, IntHolder p_row) throws Exception { Font subTotalFont = p_workbook.createFont(); subTotalFont.setBoldweight(Font.BOLDWEIGHT_BOLD); subTotalFont.setColor(IndexedColors.BLACK.getIndex()); subTotalFont.setUnderline(Font.U_NONE); subTotalFont.setFontName("Arial"); subTotalFont.setFontHeightInPoints((short) 10); CellStyle subTotalStyle = p_workbook.createCellStyle(); subTotalStyle.setFont(subTotalFont); String title = m_bundle.getString("lb_total_cost_per_lang"); int row = p_row.getValue() + 4; // skip a row ArrayList<String> locales = new ArrayList<String>(totalCost.keySet()); SortUtil.sort(locales);//from w w w . j a va2 s .c o m int col = m_data.getSumStartCol(); Row theRow = getRow(p_sheet, row); Cell cell_Title = getCell(theRow, col - 3); cell_Title.setCellValue(title); cell_Title.setCellStyle(subTotalStyle); File imgFile = File.createTempFile("GSJobChart", ".png"); JfreeCharUtil.drawPieChart2D("", totalCostDate, imgFile); Drawing patriarch = p_sheet.createDrawingPatriarch(); XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, 15, row - 1, 22, row + 24); ByteArrayOutputStream img_bytes = new ByteArrayOutputStream(); InputStream is = imgFile.toURI().toURL().openStream(); int b; while ((b = is.read()) != -1) { img_bytes.write(b); } is.close(); int i = p_workbook.addPicture(img_bytes.toByteArray(), SXSSFWorkbook.PICTURE_TYPE_PNG); patriarch.createPicture(anchor, i); for (String locale : locales) { List<Integer> indexs = totalCost.get(locale); StringBuffer values = new StringBuffer(); for (Integer index : indexs) { if (values.length() == 0) { values.append("SUM("); } else { values.append("+"); } values.append(totalCol).append(index); } values.append(")"); Row perRow = getRow(p_sheet, row); Cell cell_Locale = getCell(perRow, col - 1); cell_Locale.setCellValue(locale); cell_Locale.setCellStyle(getContentStyle(p_workbook)); Cell cell_Total = getCell(perRow, col); cell_Total.setCellFormula(values.toString()); cell_Total.setCellStyle(getMoneyStyle(p_workbook)); row++; } // Reset total column number for every sheet. totalCol = null; }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportForIPTranslatorGenerator.java
License:Apache License
private CellStyle getHeaderStyle(Workbook p_workbook) { if (headerStyle == null) { Font headerFont = p_workbook.createFont(); headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD); headerFont.setColor(IndexedColors.BLACK.getIndex()); headerFont.setUnderline(Font.U_NONE); headerFont.setFontName("Arial"); headerFont.setFontHeightInPoints((short) 9); CellStyle cs = p_workbook.createCellStyle(); cs.setFont(headerFont);//from w w w . ja v a2 s . co m cs.setWrapText(true); cs.setFillPattern(CellStyle.SOLID_FOREGROUND); cs.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); cs.setBorderTop(CellStyle.BORDER_THIN); cs.setBorderRight(CellStyle.BORDER_THIN); cs.setBorderBottom(CellStyle.BORDER_THIN); cs.setBorderLeft(CellStyle.BORDER_THIN); headerStyle = cs; } return headerStyle; }
From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportForIPTranslatorGenerator.java
License:Apache License
private CellStyle getRedCellStyle(Workbook p_workbook) throws Exception { if (redCellStyle == null) { Font redFont = p_workbook.createFont(); redFont.setFontName("Arial"); redFont.setUnderline(Font.U_NONE); redFont.setFontHeightInPoints((short) 10); CellStyle cs = p_workbook.createCellStyle(); cs.setFont(redFont);/*w w w.j a v a 2s . c om*/ cs.setWrapText(true); cs.setFillPattern(CellStyle.SOLID_FOREGROUND); cs.setFillForegroundColor(IndexedColors.RED.getIndex()); redCellStyle = cs; } return redCellStyle; }