Package org.apache.poi.ss.usermodel

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

116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
    else if (text.length() > 0)
    {
      if (text.length() < 32768)
      {
        // There's rich text.
        final RichTextString rtStr = creationHelper.createRichTextString(text);
        for (int i = 0; i < buffer.size(); i++)
        {
          final RichTextFormat o = (RichTextFormat) buffer.get(i);
          final int position = o.getPosition();
          final HSSFFontWrapper font = o.getFont();
          if (i == (buffer.size() - 1))
          {
            // Last element ..
            rtStr.applyFont(position, text.length(), fontFactory.getExcelFont(font));
          }
          else
          {
            final RichTextFormat next = (RichTextFormat) buffer.get(i + 1);
            rtStr.applyFont(position, next.getPosition(), fontFactory.getExcelFont(font));
          }
        }
        return rtStr;
      }
      else
      {
        ExcelTextExtractor.logger.warn(
            "Excel-Cells cannot contain text larger than 32.737 characters. Text will be clipped.");

        final String realText = text.substring(0, 32767);
        final RichTextString rtStr = creationHelper.createRichTextString(realText);
        for (int i = 0; i < buffer.size(); i++)
        {
          final RichTextFormat o = (RichTextFormat) buffer.get(i);
          final int position = o.getPosition();
          if (position >= 32767)
          {
            break;
          }
          final HSSFFontWrapper font = o.getFont();
          if (i == (buffer.size() - 1))
          {
            // Last element ..
            final int endPosition = Math.min(32767, text.length());
            rtStr.applyFont(position, endPosition, fontFactory.getExcelFont(font));
          }
          else
          {
            final RichTextFormat next = (RichTextFormat) buffer.get(i + 1);
            final int endPosition = Math.min(32767, next.getPosition());
            rtStr.applyFont(position, endPosition, fontFactory.getExcelFont(font));
          }
        }
        return rtStr;
      }
    }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
    if (text.length() > 0)
    {
      if (text.length() < 32768)
      {
        // There's rich text.
        final RichTextString rtStr = creationHelper.createRichTextString(text);
        for (int i = 0; i < buffer.size(); i++)
        {
          final RichTextFormat o = buffer.get(i);
          final int position = o.getPosition();
          final HSSFFontWrapper font = o.getFont();
          if (i == (buffer.size() - 1))
          {
            // Last element ..
            rtStr.applyFont(position, text.length(), fontFactory.getExcelFont(font));
          }
          else
          {
            final RichTextFormat next = buffer.get(i + 1);
            rtStr.applyFont(position, next.getPosition(), fontFactory.getExcelFont(font));
          }
        }
        return rtStr;
      }
      else
      {
        ExcelTextExtractor.logger.warn(
            "Excel-Cells cannot contain text larger than 32.737 characters. Text will be clipped.");

        final String realText = text.substring(0, 32767);
        final RichTextString rtStr = creationHelper.createRichTextString(realText);
        for (int i = 0; i < buffer.size(); i++)
        {
          final RichTextFormat o = buffer.get(i);
          final int position = o.getPosition();
          if (position >= 32767)
          {
            break;
          }
          final HSSFFontWrapper font = o.getFont();
          if (i == (buffer.size() - 1))
          {
            // Last element ..
            final int endPosition = Math.min(32767, text.length());
            rtStr.applyFont(position, endPosition, fontFactory.getExcelFont(font));
          }
          else
          {
            final RichTextFormat next = buffer.get(i + 1);
            final int endPosition = Math.min(32767, next.getPosition());
            rtStr.applyFont(position, endPosition, fontFactory.getExcelFont(font));
          }
        }
        return rtStr;
      }
    }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
              {
                tableModel.addColumn(Messages.getString("TableDataSourceEditor.Column",
                    String.valueOf(tableModel.getColumnCount())), Object.class);
              }

              final RichTextString string = cell.getRichStringCellValue();
              if (string != null)
              {
                tableModel.addColumn(string.getString(), Object.class);
              }
              else
              {
                tableModel.addColumn(Messages.getString("TableDataSourceEditor.Column", String.valueOf(colIdx)), Object.class);
              }
            }
          }
        }
      }

      Object[] rowData = null;
      while (rowIterator.hasNext())
      {
        final Row row = (Row) rowIterator.next();
        final short cellCount = row.getLastCellNum();
        if (cellCount == -1)
        {
          continue;
        }
        if (rowData == null || rowData.length != cellCount)
        {
          rowData = new Object[cellCount];
        }

        for (short colIdx = 0; colIdx < cellCount; colIdx++)
        {
          final Cell cell = row.getCell(colIdx);

          final Object value;
          if (cell != null)
          {
            if (cell.getCellType() == Cell.CELL_TYPE_STRING)
            {
              final RichTextString string = cell.getRichStringCellValue();
              if (string != null)
              {
                value = string.getString();
              }
              else
              {
                value = null;
              }
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
        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
72
73
74
75
76
77
78
79
80
81
82
    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
203
204
205
206
207
208
209
210
211
212
213
        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
206
207
208
209
210
211
212
213
214
215
216
        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
88
89
90
91
92
93
94
95
96
97
98
    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
120
121
122
123
124
125
126
127
128
129
130
        for (String str : texts) {
            sb.append(separator);
            sb.append(str);
            separator="\n";
        }
        RichTextString str = factory.createRichTextString(sb.toString());
        comment.setString(str);
        comment.setVisible(Boolean.FALSE);
        comment.setAuthor("AlgebraToSpreadsheet");

        // Assign the comment to the cell
View Full Code Here
128
129
130
131
132
133
134
135
136
    public void testSetString() {
        CommentsTable sheetComments = new CommentsTable();
        CTComment ctComment = CTComment.Factory.newInstance();
        XSSFComment comment = new XSSFComment(sheetComments, ctComment);
        RichTextString richTextString = new HSSFRichTextString(TEST_RICHTEXTSTRING);
        comment.setString(richTextString);
        assertEquals(TEST_RICHTEXTSTRING, ctComment.getText().getT());
    }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.