Java Code Examples for org.apache.poi.hssf.usermodel.HSSFRichTextString#applyFont()
The following examples show how to use
org.apache.poi.hssf.usermodel.HSSFRichTextString#applyFont() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: JRXlsExporter.java From jasperreports with GNU Lesser General Public License v3.0 | 6 votes |
protected HSSFRichTextString getRichTextString(JRStyledText styledText, short forecolor, JRFont defaultFont, Locale locale) { String text = styledText.getText(); HSSFRichTextString richTextStr = new HSSFRichTextString(text); int runLimit = 0; AttributedCharacterIterator iterator = styledText.getAttributedString().getIterator(); while(runLimit < styledText.length() && (runLimit = iterator.getRunLimit()) <= styledText.length()) { Map<Attribute,Object> attributes = iterator.getAttributes(); JRFont runFont = attributes.isEmpty()? defaultFont : new JRBaseFont(attributes); short runForecolor = attributes.get(TextAttribute.FOREGROUND) != null ? getWorkbookColor((Color)attributes.get(TextAttribute.FOREGROUND)).getIndex() : forecolor; HSSFFont font = getLoadedFont(runFont, runForecolor, attributes, locale); richTextStr.applyFont(iterator.getIndex(), runLimit, font); iterator.setIndex(runLimit); } return richTextStr; }
Example 2
Source File: JRXlsMetadataExporter.java From jasperreports with GNU Lesser General Public License v3.0 | 6 votes |
protected HSSFRichTextString getRichTextString(JRStyledText styledText, short forecolor, JRFont defaultFont, Locale locale) { String text = styledText.getText(); HSSFRichTextString richTextStr = new HSSFRichTextString(text); int runLimit = 0; AttributedCharacterIterator iterator = styledText.getAttributedString().getIterator(); while(runLimit < styledText.length() && (runLimit = iterator.getRunLimit()) <= styledText.length()) { Map<Attribute,Object> attributes = iterator.getAttributes(); JRFont runFont = attributes.isEmpty()? defaultFont : new JRBaseFont(attributes); short runForecolor = attributes.get(TextAttribute.FOREGROUND) != null ? getWorkbookColor((Color)attributes.get(TextAttribute.FOREGROUND)).getIndex() : forecolor; HSSFFont font = getLoadedFont(runFont, runForecolor, attributes, locale); richTextStr.applyFont(iterator.getIndex(), runLimit, font); iterator.setIndex(runLimit); } return richTextStr; }
Example 3
Source File: TestExportExcel.java From poi with Apache License 2.0 | 6 votes |
@Test public void exportExcelWithStyle() { try { String filePath = TestUtil.DOC_PATH + File.separator + Globals.EXPORT_PRODUCT; OutputStream os = new FileOutputStream(filePath); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(Globals.SHEETNAME); HSSFRichTextString richString = new HSSFRichTextString( TestUtil.RICH_TEXT_STRING); HSSFFont font = wb.createFont(); font.setColor(IndexedColors.BLUE.index); richString.applyFont(font); sheet.createRow(0).createCell(0).setCellValue(richString); wb.write(os); os.close(); } catch (Exception e) { e.printStackTrace(); } }
Example 4
Source File: TextObjectRecord.java From lams with GNU General Public License v2.0 | 5 votes |
private static void processFontRuns(RecordInputStream in, HSSFRichTextString str, int formattingRunDataLength) { if (formattingRunDataLength % FORMAT_RUN_ENCODED_SIZE != 0) { throw new RecordFormatException("Bad format run data length " + formattingRunDataLength + ")"); } int nRuns = formattingRunDataLength / FORMAT_RUN_ENCODED_SIZE; for (int i = 0; i < nRuns; i++) { short index = in.readShort(); short iFont = in.readShort(); in.readInt(); // skip reserved. str.applyFont(index, str.length(), iFont); } }
Example 5
Source File: SpreadsheetSetCellComment.java From openbd-core with GNU General Public License v3.0 | 4 votes |
public cfData execute( cfSession _session, List<cfData> parameters ) throws cfmRunTimeException { if ( parameters.get(2).getDataType() != cfData.CFSTRUCTDATA ) throwException(_session, "parameter must be of type structure"); cfSpreadSheetData spreadsheet = null; cfStructData commentS = null; int rowNo, columnNo; /* * Collect up the parameters */ spreadsheet = (cfSpreadSheetData)parameters.get(3); commentS = (cfStructData)parameters.get(2); rowNo = parameters.get(1).getInt() - 1; columnNo = parameters.get(0).getInt() - 1; if ( rowNo < 0 ) throwException(_session, "row must be 1 or greater (" + rowNo + ")"); if ( columnNo < 0 ) throwException(_session, "column must be 1 or greater (" + columnNo + ")"); /* * Perform the insertion */ Sheet sheet = spreadsheet.getActiveSheet(); Row row = sheet.getRow( rowNo ); if ( row == null ) row = sheet.createRow( rowNo ); Cell cell = row.getCell( columnNo ); if ( cell == null ) cell = row.createCell( columnNo ); // Create the anchor HSSFClientAnchor clientAnchor = new HSSFClientAnchor(); if ( commentS.containsKey("anchor") ){ String[] anchor = commentS.getData("anchor").getString().split(","); if ( anchor.length != 4 ) throwException(_session,"Invalid 'anchor' attribute, should be 4 numbers"); clientAnchor.setRow1( Integer.valueOf( anchor[0] ) - 1 ); clientAnchor.setCol1( Integer.valueOf( anchor[1] ) - 1 ); clientAnchor.setRow2( Integer.valueOf( anchor[2] ) - 1 ); clientAnchor.setCol2( Integer.valueOf( anchor[3] ) - 1 ); }else{ clientAnchor.setRow1( rowNo ); clientAnchor.setCol1( columnNo ); clientAnchor.setRow2( rowNo + 2 ); clientAnchor.setCol2( columnNo + 2 ); } // Create the comment Comment comment = spreadsheet.getActiveSheet().createDrawingPatriarch().createCellComment(clientAnchor); if ( commentS.containsKey("author") ){ comment.setAuthor( commentS.getData("author").getString() ); } if ( commentS.containsKey("visible") ){ comment.setVisible( commentS.getData("visible").getBoolean() ); } if ( commentS.containsKey("comment") ){ HSSFRichTextString richText = new HSSFRichTextString( commentS.getData("comment").getString() ); try { richText.applyFont( SpreadSheetFormatOptions.createCommentFont(spreadsheet.getWorkBook(), commentS) ); } catch (Exception e) { throwException( _session, e.getMessage() ); } comment.setString( richText ); } cell.setCellComment( comment ); return cfBooleanData.TRUE; }