Package org.apache.poi.hssf.usermodel

Examples of org.apache.poi.hssf.usermodel.HSSFRichTextString

132
133
134
135
136
137
138
139
140
141
142
    /**
     * Test cloning
     */
    public void testClone() {
        String text = "Hello, World";
        HSSFRichTextString str = new HSSFRichTextString(text);

        TextObjectRecord obj = new TextObjectRecord();
        obj.setStr( str );


View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
234
235
236
            break;
        case HSSFCell.CELL_TYPE_FORMULA:
            switch ( cell.getCachedFormulaResultType() )
            {
            case HSSFCell.CELL_TYPE_STRING:
                HSSFRichTextString str = cell.getRichStringCellValue();
                if ( str != null && str.length() > 0 )
                {
                    value = ( str.toString() );
                }
                else
                {
                    value = ExcelToHtmlUtils.EMPTY;
                }
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
314
315
316
            break;
        case HSSFCell.CELL_TYPE_FORMULA:
            switch ( cell.getCachedFormulaResultType() )
            {
            case HSSFCell.CELL_TYPE_STRING:
                HSSFRichTextString str = cell.getRichStringCellValue();
                if ( str != null && str.length() > 0 )
                {
                    value = ( str.toString() );
                }
                else
                {
                    value = ExcelToHtmlUtils.EMPTY;
                }
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
    if (path == null && titles != null) {
      sheet.createRow(rowIndex);
      HSSFRow row = sheet.createRow(rowIndex);
      for (String title : titles) {
        row.createCell((short) columnIndex).setCellValue(
            new HSSFRichTextString(title));
        columnIndex++;
      }
      rowIndex++;
      columnIndex = left;
    }

    for (int i = 0; i < size; i++) {
      // 填充每一行
      List<?> list = rows.get(i);
      int rowSize = list.size();
      for (int j = 0; j < rowSize; j++) {
        // 填充每一列
        Object value = list.get(j);
        if (value != null) {
          // 等于空时跳过这一次存储
          sheet.createRow(rowIndex).createCell((short) columnIndex)
              .setCellValue(new HSSFRichTextString(value.toString()));
        }
        // 如果定义了填充格式, 则需要计算新的单元格位置
        if (format != null) {
          rowIndex += format[j][0];
          columnIndex += format[j][1];
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
182
                    cellList.add(HSSFDateUtil.getJavaDate(d));
                  } else {
                    cellList.add(d);
                  }
                } else {
                  HSSFRichTextString o = cell.getRichStringCellValue();
                  cellList.add(o != null ? o.getString() : null);
                }
              }
            }
          }
          value = data;
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
123
124
125
            case HSSFCell.CELL_TYPE_FORMULA:
              if(formulasNotResults) {
                text.append(cell.getCellFormula());
              } else {
                // Try it as a string, if not as a number
                HSSFRichTextString str =
                  cell.getRichStringCellValue();
                if(str != null && str.length() > 0) {
                  text.append(str.toString());
                } else {
                  // Try and treat it as a number
                  double val = cell.getNumericCellValue();
                  text.append(val);
                }
View Full Code Here
34
35
36
37
38
39
40
    public TextObjectRecord( RecordInputStream in )
    {
        super( in );
        if (str == null)
          str = new HSSFRichTextString("");
    }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93

    public int serialize( int offset, byte[] data )
    {
        // Temporarily blank out str so that record size is calculated without the continue records.
        HSSFRichTextString temp = str;
        str = new HSSFRichTextString("");
        int bytesWritten1 = super.serialize( offset, data );
        str = temp;

        int pos = offset + bytesWritten1;
        if ( str.getString().equals( "" ) == false )
View Full Code Here
191
192
193
194
195
196
197
            }
            else
            {
            s = in.readUnicodeLEString(getTextLength());
        }
        str = new HSSFRichTextString( s );
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
    }

    public void testWrite()
    {
        HSSFRichTextString str = new HSSFRichTextString("Hello, World!");

        TextObjectRecord record = new TextObjectRecord();
        int frLength = ( str.numFormattingRuns() + 1 ) * 8;
        record.setFormattingRunLength( (short) frLength );
        record.setTextLength( (short) str.length() );
        record.setStr( str );
        record.setHorizontalTextAlignment( TextObjectRecord.HORIZONTAL_TEXT_ALIGNMENT_LEFT_ALIGNED );
        record.setVerticalTextAlignment( TextObjectRecord.VERTICAL_TEXT_ALIGNMENT_TOP );
        record.setTextLocked( true );
        record.setTextOrientation( TextObjectRecord.TEXT_ORIENTATION_NONE );
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFRichTextString

  • au.com.cahaya.asasx.poi.PoiUtil
  • bg.smoc.web.servlet.ResultsServlet
  • br.net.woodstock.rockframework.document.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsDataSetWriter
  • com.aaspring.translation.XlsDoor
  • com.aesthete.swingobjects.fw.common.util.ExcelHelper
  • com.commander4j.util.JExcel
  • com.dtrules.compiler.excel.util.ImportRuleSets
  • com.eatle.utils.ExcelUtil
    • 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.