/** * Create a new Font and add it to the workbook's font table * * @return new font object */ @Override public Font createFont() { return _wb.createFont(); }
protected void createStyles() { headerStyle = createStyle(null); Font headerFont = workbook.createFont(); headerFont.setBold(true); headerStyle.setFont(headerFont); defaultStyle = createStyle(null); scoreStyle = createStyle(null); scoreStyle.setAlignment(HorizontalAlignment.RIGHT); disabledScoreStyle = createStyle(DISABLED_COLOR); disabledScoreStyle.setAlignment(HorizontalAlignment.RIGHT); unavailableStyle = createStyle(UNAVAILABLE_COLOR); pinnedStyle = createStyle(PINNED_COLOR); hardPenaltyStyle = createStyle(HARD_PENALTY_COLOR); mediumPenaltyStyle = createStyle(MEDIUM_PENALTY_COLOR); softPenaltyStyle = createStyle(SOFT_PENALTY_COLOR); wrappedStyle = createStyle(null); republishedStyle = createStyle(REPUBLISHED_COLOR); }
@Override public void reset(XSSFWorkbook workbook) { this.workbook = workbook; style = workbook.createCellStyle(); Font hlinkFont = workbook.createFont(); hlinkFont.setUnderline(Font.U_SINGLE); hlinkFont.setColor(IndexedColors.BLUE.getIndex()); style.setFont(hlinkFont); links = 0; }
/** * Create a new Font and add it to the workbook's font table * * @return new font object */ @Override public Font createFont() { return _wb.createFont(); }
/** * Create a new Font and add it to the workbook's font table * * @return new font object */ public Font createFont() { return _wb.createFont(); }
private static XSSFFont getBaseFont(XSSFWorkbook wb) {//用到 XSSFFont font = wb.createFont(); font.setFontHeightInPoints((short) 12); return font; }
public static XSSFFont getBaseFont(XSSFWorkbook wb) { XSSFFont font = wb.createFont(); font.setFontHeightInPoints((short) 12); return font; }
public Font createFont() { return sxssfWorkbook != null ? sxssfWorkbook.createFont() : xssfWorkbook.createFont(); }
XSSFWorkbook wb=new XSSFWorkbook(); XSSFFont font = wb.createFont(); font.setBold( true ); font.setItalic( true ); new XSSFRichTextString().applyFont( font );
private static Font createFontArialWithGivenBoldweight(XSSFWorkbook workbook, short boldweight) { Font font = workbook.createFont(); font.setFontName(HSSFFont.FONT_ARIAL); font.setFontHeightInPoints((short) 10); font.setBoldweight(boldweight); return font; }
private CellStyle createHyperLinkStyle(final XSSFWorkbook workbook) { final CellStyle hlink_style = workbook.createCellStyle(); final Font hlink_font = workbook.createFont(); hlink_font.setUnderline(Font.U_SINGLE); hlink_font.setColor(IndexedColors.BLUE.getIndex()); hlink_style.setFont(hlink_font); return hlink_style; } }
//creating the cell Row row = my_sheet.createRow(0); Cell cell = row.createCell(0); //creating helper class XSSFWorkbook workbook = new XSSFWorkbook(); XSSFCreationHelper helper= workbook.getCreationHelper(); //creating the hyperlink link = helper.createHyperlink(HSSFHyperlink.LINK_DOCUMENT); link.setAddress("'target_worksheet_name'!A1"); //optional hyperlink style XSSFCellStyle hlinkstyle = workbook.createCellStyle(); XSSFFont hlinkfont = workbook.createFont(); hlinkfont.setUnderline(XSSFFont.U_SINGLE); hlinkfont.setColor(HSSFColor.BLUE.index); hlinkstyle.setFont(hlinkfont); //applying the hyperlink to the cell cell.setHyperlink(link);
// initialize objects XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet spreadsheet = workbook.createSheet(sheetName); XSSFRow row = spreadsheet.createRow(0); XSSFCell cell; // font/style XSSFFont font = workbook.createFont(); font.setFontName("Arial"); XSSFCellStyle style = workbook.createCellStyle(); style.setFont(font); // create/set cell & style cell = row.createCell(0); cell.setCellValue("New Cell"); cell.setCellStyle(style); // auto size spreadsheet.autoSizeColumn(0); // create file File aFile = new File("Your Filename"); FileOutputStream out = new FileOutputStream(aFile); workbook.write(out);
private void fillHeaderRow(XSSFWorkbook xssfWorkbook, XSSFSheet sheet, Integer rowNum, Locale locale) { XSSFRow headerLine = sheet.createRow(rowNum); XSSFFont font = xssfWorkbook.createFont(); font.setFontHeightInPoints((short) 10); font.setFontName("ARIAL"); font.setItalic(false); font.setBold(true); font.setBoldweight(Font.BOLDWEIGHT_BOLD); font.setColor(HSSFColor.BLACK.index); XSSFCellStyle style = xssfWorkbook.createCellStyle(); style.setFont(font); Lists.newArrayList(MaintenanceEventsElementsReportEnum.values()).forEach( e -> createHeaderCell(e, headerLine, style, locale)); }
public static void hyperlinkScreenshot(XSSFCell cell, String FileAddress){ XSSFWorkbook wb=cell.getRow().getSheet().getWorkbook(); CreationHelper createHelper = wb.getCreationHelper(); CellStyle hlink_style = wb.createCellStyle(); Font hlink_font = wb.createFont(); hlink_font.setUnderline(Font.U_SINGLE); hlink_font.setColor(IndexedColors.BLUE.getIndex()); hlink_style.setFont(hlink_font); Hyperlink hp = createHelper.createHyperlink(Hyperlink.LINK_FILE); FileAddress=FileAddress.replace("\\", "/"); hp.setAddress(FileAddress); cell.setHyperlink(hp); cell.setCellStyle(hlink_style); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("m/d/yy h:mm")); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("m/d/yy")); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("text")); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("text")); }
protected void createStyles() { headerStyle = createStyle(null); Font headerFont = workbook.createFont(); headerFont.setBold(true); headerStyle.setFont(headerFont); defaultStyle = createStyle(null); scoreStyle = createStyle(null); scoreStyle.setAlignment(HorizontalAlignment.RIGHT); disabledScoreStyle = createStyle(DISABLED_COLOR); disabledScoreStyle.setAlignment(HorizontalAlignment.RIGHT); unavailableStyle = createStyle(UNAVAILABLE_COLOR); pinnedStyle = createStyle(PINNED_COLOR); hardPenaltyStyle = createStyle(HARD_PENALTY_COLOR); mediumPenaltyStyle = createStyle(MEDIUM_PENALTY_COLOR); softPenaltyStyle = createStyle(SOFT_PENALTY_COLOR); wrappedStyle = createStyle(null); republishedStyle = createStyle(REPUBLISHED_COLOR); }