Examples of org.apache.poi.xssf.usermodel.XSSFRichTextString

org.apache.poi.xssf.usermodel.XSSFRichTextString
Rich text unicode string. These strings can have fonts applied to arbitary parts of the string.
Most strings in a workbook have formatting applied at the cell level, that is, the entire string in the cell has the same formatting applied. In these cases, the formatting for the cell is stored in the styles part, and the string for the cell can be shared across the workbook. The following code illustrates the example.
```
 cell1.setCellValue(new XSSFRichTextString("Apache POI")); cell2.setCellValue(new XSSFRichTextString("Apache POI")); cell3.setCellValue(new XSSFRichTextString("Apache POI")); 
```
In the above example all three cells will use the same string cached on workbook level.
Some strings in the workbook may have formatting applied at a level that is more granular than the cell level. For instance, specific characters within the string may be bolded, have coloring, italicizing, etc. In these cases, the formatting is stored along with the text in the string table, and is treated as a unique entry in the workbook. The following xml and code snippet illustrate this.
```
 XSSFRichTextString s1 = new XSSFRichTextString("Apache POI"); s1.applyFont(boldArial); cell1.setCellValue(s1); XSSFRichTextString s2 = new XSSFRichTextString("Apache POI"); s2.applyFont(italicCourier); cell2.setCellValue(s2); 
```
@author Yegor Kozlov

      Package pkg = Package.open(f.toString());
      
      XSSFReader r = new XSSFReader(pkg);
      
      assertEquals(11, r.getSharedStringsTable().getItems().size());
      assertEquals("Test spreadsheet", new XSSFRichTextString(r.getSharedStringsTable().getEntryAt(0)).toString());
    }

View Full Code Here

            // Aqua background
            CellStyle style = wb.createCellStyle();
            style.setFillBackgroundColor(HSSFColor.AQUA.index);
            style.setFillPattern(CellStyle.BIG_SPOTS);
            Cell cell = row.createCell((short) 1);
            cell.setCellValue(new XSSFRichTextString("X"));
            cell.setCellStyle(style);


            // Orange "foreground", foreground being the fill foreground not the font color.
            style = wb.createCellStyle();
            style.setFillForegroundColor(HSSFColor.ORANGE.index);
            style.setFillPattern(CellStyle.SOLID_FOREGROUND);
            cell = row.createCell((short) 2);
            cell.setCellValue(new XSSFRichTextString("X"));
            cell.setCellStyle(style);


            // Write the output to a file
            FileOutputStream fileOut = new FileOutputStream("fill_colors.xlsx");
            wb.write(fileOut);

View Full Code Here

        throws SAXException {
      // Process the last contents as required.
      // Do now, as characters() may be called more than once
      if(nextIsString) {
        int idx = Integer.parseInt(lastContents);
        lastContents = new XSSFRichTextString(sst.getEntryAt(idx)).toString();
      }


      // v => contents of a cell
      // Output after we've seen the string contents
      if(name.equals("v")) {

View Full Code Here

        Workbook wb = new XSSFWorkbook();
        Sheet sheet = wb.createSheet("new sheet");


        Row row = sheet.createRow((short) 1);
        Cell cell = row.createCell((short) 1);
        cell.setCellValue(new XSSFRichTextString("This is a test of merging"));


        sheet.addMergedRegion(new Region(1,(short)1,1,(short)2));


        // Write the output to a file
        FileOutputStream fileOut = new FileOutputStream("merging_cells.xlsx");

View Full Code Here

            final int event = sheetStreamReader.next();
            if (event == XMLStreamConstants.START_ELEMENT && "v".equals(sheetStreamReader.getLocalName())) {
                result = sheetStreamReader.getElementText();
                if ("s".equals(cellType)) {
                    final int idx = Integer.parseInt(result);
                    result = new XSSFRichTextString(sharedStringsTable.getEntryAt(idx)).toString();
                }
            } else if (event == XMLStreamConstants.START_ELEMENT && "t".equals(sheetStreamReader.getLocalName())) {
                result = sheetStreamReader.getElementText();
            } else if (event == XMLStreamConstants.END_ELEMENT && "c".equals(sheetStreamReader.getLocalName())) {
                break;

View Full Code Here

      String[] rowvalue = datas.get(i);
      XSSFRow nextrow = sheet.createRow(sheet.getLastRowNum() + 1);// 创建一行
      for (int j = 0; j < rowvalue.length; j++) {
        XSSFCell cell = nextrow
            .createCell(j, XSSFCell.CELL_TYPE_STRING);
        cell.setCellValue(new XSSFRichTextString(rowvalue[j]));
        if (rowvalue[j].equals("Fail")) {
          cell.setCellStyle(styleRed);
        } else if (rowvalue[j].equals("Pass")) {
          cell.setCellStyle(styleGreen);
        } else {

View Full Code Here

          c.setCellValue("");
        }
        break;
      case TEXT:
        if (cell.getValue() != null) {
          XSSFRichTextString value = new XSSFRichTextString(cell.getValue().toString());
          c.setCellValue(value);
        } else {
          c.setCellType(org.apache.poi.ss.usermodel.Cell.CELL_TYPE_STRING);
          c.setCellValue("");
        }

View Full Code Here

            final int event = sheetStreamReader.next();
            if (event == XMLStreamConstants.START_ELEMENT && "v".equals(sheetStreamReader.getLocalName())) {
                result = sheetStreamReader.getElementText();
                if ("s".equals(cellType)) {
                    final int idx = Integer.parseInt(result);
                    result = new XSSFRichTextString(sharedStringsTable.getEntryAt(idx)).toString();
                }
            } else if (event == XMLStreamConstants.START_ELEMENT && "t".equals(sheetStreamReader.getLocalName())) {
                result = sheetStreamReader.getElementText();
            } else if (event == XMLStreamConstants.END_ELEMENT && "c".equals(sheetStreamReader.getLocalName())) {
                break;

View Full Code Here

        throws SAXException {
      // Process the last contents as required.
      // Do now, as characters() may be called more than once
      if(nextIsString) {
        int idx = Integer.parseInt(lastContents);
        lastContents = new XSSFRichTextString(sst.getEntryAt(idx)).toString();
      }


      // v => contents of a cell
      // Output after we've seen the string contents
      if(name.equals("v")) {

View Full Code Here

      Package pkg = Package.open(f.toString());
      
      XSSFReader r = new XSSFReader(pkg);
      
      assertEquals(11, r.getSharedStringsTable().getItems().size());
      assertEquals("Test spreadsheet", new XSSFRichTextString(r.getSharedStringsTable().getEntryAt(0)).toString());
    }

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of org.apache.poi.xssf.usermodel.XSSFRichTextString

br.net.woodstock.rockframework.document.spreadsheet.poi.XSSFSpreadsheetDocumentWriter

br.net.woodstock.rockframework.office.spreadsheet.poi.XSSFSpreadsheetDocumentWriter

cn.baiweigang.qtaf.ift.util.ExportReportExcel

com.common.platform.excel.parser.XSSFParser

com.gentics.cr.lucene.indexer.transformer.xlsx.XLSXContentTransformer$SheetHandler

com.thinkgem.jeesite.common.utils.excel.ExportExcel

org.apache.metamodel.excel.XlsxSheetToRowsHandler

org.apache.poi.xssf.eventusermodel.examples.FromHowTo$SheetHandler

org.apache.poi.xssf.eventusermodel.TestXSSFReader

org.apache.poi.xssf.eventusermodel.XLSX2CSV$MyXSSFSheetHandler

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.