Examples of org.apache.poi.ss.usermodel.RichTextString

org.apache.poi.ss.usermodel.RichTextString
This is a JDK 1.4 compatible interface for HSSFRichTextString. If you are using JDK 1.5 or later, use the other set of interfaces, which work properly for both HSSFRichTextString and XSSFRichTextString

  private static void createStringCell(Row row, int index, String text,
      ExcelExportEntity entity, Workbook workbook) {
    Cell cell = row.createCell(index);
    switch (entity.getType()) {
    case 1:
      RichTextString Rtext = workbook instanceof HSSFWorkbook ? new HSSFRichTextString(
          text) : new XSSFRichTextString(text);
      cell.setCellValue(Rtext);
      break;
    case 2:
      cell.setCellType(Cell.CELL_TYPE_FORMULA);

View Full Code Here

   * @param entity 
   */
  private static void createStringCell(Row row, int index, String text,
      CellStyle style, ExcelExportEntity entity) {
    Cell cell = row.createCell(index);
    RichTextString Rtext = new HSSFRichTextString(text);
    cell.setCellValue(Rtext);
    cell.setCellStyle(style);
  }

View Full Code Here

      while (it.hasNext()) {
        CgFormFieldEntity type = (CgFormFieldEntity) it.next();
        // 输入需要显示的字段信息
        if (type.getIsShow().equals("Y")) {
          Cell cell = row.createCell(index);
          RichTextString text = new HSSFRichTextString(type
              .getContent());
          cell.setCellValue(text);
          // 设置列宽
          int columnWidth = type.getLength()==0?minColumnWidth:type.getLength()>maxColumnWidth?maxColumnWidth:type.getLength();
          sheet.setColumnWidth(index,256 * columnWidth);

View Full Code Here

       font1.setColor((short) 20);


       Row row = sheet.createRow(2);
       Cell cell = row.createCell(2);


       RichTextString richTextString =
          wb.getCreationHelper().createRichTextString(text);
       
       // Check the text has the newline
       assertEquals(text, richTextString.getString());
       
       // Apply the font
       richTextString.applyFont(0, 3, font1);
       cell.setCellValue(richTextString);


       // To enable newlines you need set a cell styles with wrap=true
       CellStyle cs = wb.createCellStyle();
       cs.setWrapText(true);

View Full Code Here


    Sheet sheet1 = workbook.createSheet("sheet1");
    Sheet sheet2 = workbook.createSheet("sheet2");
    workbook.createSheet("sheet3");


    RichTextString rts = workbook.getCreationHelper().createRichTextString("hello world");


    sheet1.createRow(0).createCell((short)0).setCellValue(1.2);
    sheet1.createRow(1).createCell((short)0).setCellValue(rts);
    sheet2.createRow(0);

View Full Code Here


        XSSFRow row = sheet.createRow(0);
        XSSFCell cell = row.createCell(0);


        XSSFFont font = wb.createFont();
        RichTextString rts = factory.createRichTextString("");
        rts.applyFont(font);
        cell.setCellValue(rts);


        sheet.autoSizeColumn(0);
    }

View Full Code Here

        AttributedString str;
        TextLayout layout;


        double width = -1;
        if (cellType == Cell.CELL_TYPE_STRING) {
            RichTextString rt = cell.getRichStringCellValue();
            String[] lines = rt.getString().split("\\n");
            for (int i = 0; i < lines.length; i++) {
                String txt = lines[i] + defaultChar;


                str = new AttributedString(txt);
                copyAttributes(font, str, 0, txt.length());


                if (rt.numFormattingRuns() > 0) {
                    // TODO: support rich text fragments
                }


                layout = new TextLayout(str.getIterator(), fontRenderContext);
                if(style.getRotation() != 0){

View Full Code Here

                    cell = row.createCell(0);


                    if (r == (rowLimit - 1) && i.hasNext()) {
                        // there are more features than rows available in this
                        // Excel format. write out a warning line and break
                        RichTextString rowWarning = helper.createRichTextString(TRUNCATE_WARNING
                                + ": ROWS " + r + " - " + fc.size() + " NOT SHOWN");
                        cell.setCellValue(rowWarning);
                        cell.setCellStyle(styles.getWarningStyle());
                        break;
                    }

View Full Code Here


        XSSFRow row = sheet.createRow(0);
        XSSFCell cell = row.createCell(0);


        XSSFFont font = wb.createFont();
        RichTextString rts = factory.createRichTextString("");
        rts.applyFont(font);
        cell.setCellValue(rts);


        sheet.autoSizeColumn(0);
    }

View Full Code Here

        XSSFWorkbook workbook = new XSSFWorkbook();
        Sheet sheet1 = workbook.createSheet("sheet1");
        Sheet sheet2 = workbook.createSheet("sheet2");
        Sheet sheet3 = workbook.createSheet("sheet3");
        
        RichTextString rts = workbook.getCreationHelper().createRichTextString("hello world");
        
        sheet1.createRow(0).createCell((short)0).setCellValue(1.2);
        sheet1.createRow(1).createCell((short)0).setCellValue(rts);
        sheet2.createRow(0);

View Full Code Here

0 1 2 3

TOP

Related Classes of org.apache.poi.ss.usermodel.RichTextString

com.danhaywood.isis.domainservice.excel.impl.CellMarshaller

org.apache.poi.ss.util.SheetUtil

org.apache.poi.xssf.usermodel.TestXSSFBugs

org.apache.poi.xssf.usermodel.TestXSSFComment

org.apache.poi.xssf.usermodel.TestXSSFSheet

org.apache.poi.xssf.usermodel.TestXSSFWorkbook

org.apache.poi.xssf.usermodel.XSSFComment

org.geoserver.wfs.response.ExcelOutputFormat

org.jeecgframework.poi.excel.ExcelExportOfTemplateUtil

org.jeecgframework.poi.excel.ExcelExportUtil

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.