Package org.apache.poi.hssf.usermodel

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

106
107
108
109
110
111
112
113
114
115
116
                            s.addMergedRegion(region);
                        }


                        cell.setCellValue(
                          new HSSFRichTextString(tmpField.getStringValue()));

                        /* Setup the correct cell formating */
                        HSSFFont tmpFont = wb.createFont();
                        String fontName = tmpField.getFormat().getFont().getFontName();
                        String useFontName = "Times New Roman";
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
            cell.setCellStyle(getTimeStyle());
          } else if (values[i] instanceof Calendar) {
            cell.setCellValue((Calendar) values[i]);
            cell.setCellStyle(getTimeStyle());
          } else {
            cell.setCellValue(new HSSFRichTextString((values[i] == null) ? "" : values[i]
                .toString()));
          }
        }
      } else {
        HSSFCell cell = row.createCell(0);
        // cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        if (datas instanceof Number) {
          cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
        }
        cell.setCellValue(new HSSFRichTextString(datas.toString()));
      }
    }
  }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    row = sheet.createRow(0); // 建立新行
    // 显示标题列名
    for (int i = 0; i < pShowKeys.length; i++) {
      cell = row.createCell(i); // 建立新cell
      // cell.setEncoding(HSSFCell.ENCODING_UTF_16);
      cell.setCellValue(new HSSFRichTextString(pShowKeys[i]));
    }
    // 逐行取数
    int rowId = 1;// 数据行号（从2行开始填充数�?)
    for (Iterator<Object[]> iter = datas.iterator(); iter.hasNext(); rowId++) {
      row = sheet.createRow(rowId); // 建立新行
      Object[] objs = iter.next();
      // 生成每一�?
      for (int j = 0; j < objs.length; j++) {
        cell = row.createCell(j); // 建立新cell
        // cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        cell.setCellValue(new HSSFRichTextString((objs[j] == null) ? "" : objs[j].toString()));
      }
    }
    return wb;
  }
View Full Code Here
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
    row = sheet.createRow(0); // 建立新行
    // 显示标题列名�?
    for (int i = 0; i < pShowKeys.length; i++) {
      cell = row.createCell(i); // 建立新cell
      // cell.setEncoding(HSSFCell.ENCODING_UTF_16);
      cell.setCellValue(new HSSFRichTextString(pShowKeys[i]));
    }
    // 逐行取数�?
    int rowId = 1;// 数据行号（从�?2行开始填充数�?)
    for (Iterator<T> iter = list.iterator(); iter.hasNext(); rowId++) {
      row = sheet.createRow(rowId); // 建立新行
      T obj = iter.next();
      // 生成每一
      for (int i = 0; i < pKeys.length; i++) {
        cell = row.createCell(i); // 建立新cell
        cellVal = exporter.getPropertyValue(obj, pKeys[i]);
        // cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        String cellValue = "";
        if (null != cellVal) {
          cellValue = cellVal.toString();
        }
        if (cellVal instanceof Float) {
          cellValue = numberformat.format(cellVal);
        }
        cell.setCellValue(new HSSFRichTextString(cellValue));
      }
    }
    return wb;
  }
View Full Code Here
742
743
744
745
746
747
748
 
  protected final void setStringCellValue(String textStr)
  {
    //cell.setCellValue(JRStringUtil.replaceDosEOL(textStr));
    //cell.setCellValue(textStr);
    cell.setCellValue(new HSSFRichTextString(textStr));
  }
View Full Code Here
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
  }

  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 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;
  }
View Full Code Here
60
61
62
63
64
65
66
67
  public void write(String value) {
    if (value == null || "null".equals(value)) {
      value = "";
    }
    excelRow.createCell(col).setCellValue(new HSSFRichTextString(value));
    col++;
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
        value = "formula";
      case HSSFCell.CELL_TYPE_NUMERIC:
        value = poiCell.getNumericCellValue();
        break;
      case HSSFCell.CELL_TYPE_STRING:
        HSSFRichTextString hssfValue = poiCell.getRichStringCellValue();
        if(hssfValue!=null){
          value = hssfValue.getString();
        }
        break;
      default:
        value = "default";// do nothing
      }
View Full Code Here
98
99
100
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
     
      //Ugly, but we can't switch on objects and
      //operator overloading breaks down as we have a handle to a generic 'object'
      if(value!=null &&value instanceof String){
        log.finest("UpdatingCell:"+fact.getCellName()+" value:"+value+" as String");
        HSSFRichTextString textValue=new HSSFRichTextString(value.toString());
        poiCell.setCellValue(textValue);
        poiCell.setCellType(HSSFCell.CELL_TYPE_STRING);
       
       
      } else if(value!=null &&value instanceof Boolean){
        log.finest("UpdatingCell:"+fact.getCellName()+" value:"+value+" as Boolean");
        poiCell.setCellValue((Boolean)fact.getValue());
        poiCell.setCellType(HSSFCell.CELL_TYPE_BOOLEAN);
       
       
      } else if(value!=null &&value instanceof Number){
        log.finest("UpdatingCell:"+fact.getCellName()+" value:"+value+" as Number");
        Double number = ((Number)value).doubleValue();
        poiCell.setCellValue(number);
        poiCell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
       
       
      } else if(value!=null &&value instanceof Date){
       
        //Excel dates are numbers with a special style
        log.finest("UpdatingCell:"+fact.getCellName()+" value:"+value+" as Date");
        Double number = ((Number)value).doubleValue();
        poiCell.setCellValue(number);
        poiCell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
       
        poiCell.getCellStyle().setDataFormat(HSSFDataFormat.getBuiltinFormat(EXCEL_DATE_STYLE));

       
      } else if(value!=null){
       
        //Treat as object, use toString() method
        log.finest("UpdatingCell:"+fact.getCellName()+" value:"+value+" as Generic Object");
        HSSFRichTextString textValue=new HSSFRichTextString(value.toString());
       
        poiCell.setCellValue(textValue);
        poiCell.setCellType(HSSFCell.CELL_TYPE_STRING);
       
      } else {
View Full Code Here
33
34
35
36
37
38
39
    public TextObjectRecord( RecordInputStream in )
    {
        super( in );
        if (str == null)
          str = new HSSFRichTextString("");
    }
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.