org.apache.poi.xssf.usermodel.XSSFRichTextString.toString()方法的使用及代码示例

x33g5p2x  于2022-02-03 转载在 其他  
字(10.2k)|赞(0)|评价(0)|浏览(187)

本文整理了Java中org.apache.poi.xssf.usermodel.XSSFRichTextString.toString()方法的一些代码示例，展示了XSSFRichTextString.toString()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。XSSFRichTextString.toString()方法的具体详情如下：
包路径：org.apache.poi.xssf.usermodel.XSSFRichTextString
类名称：XSSFRichTextString
方法名：toString

XSSFRichTextString.toString介绍

[英]Returns the plain string representation.
[中]返回纯字符串表示形式。

代码示例

代码示例来源：origin: alibaba/easyexcel

private void endCellValue(String name) throws SAXException {
  // ensure size
  if (curCol >= curRowContent.length) {
    curRowContent = Arrays.copyOf(curRowContent, (int)(curCol * 1.5));
  }
  if (CELL_VALUE_TAG.equals(name)) {
    switch (currentCellType) {
      case STRING:
        int idx = Integer.parseInt(currentCellValue);
        currentCellValue = new XSSFRichTextString(sst.getEntryAt(idx)).toString();
        currentCellType = FieldType.EMPTY;
        break;
    }
    curRowContent[curCol] = currentCellValue;
  } else if (CELL_VALUE_TAG_1.equals(name)) {
    curRowContent[curCol] = currentCellValue;
  }
}

代码示例来源：origin: pentaho/pentaho-kettle

if ( event == XMLStreamConstants.START_ELEMENT && sheetReader.getLocalName().equals( "v" ) ) {
 int idx = Integer.parseInt( sheetReader.getElementText() );
 String content = new XSSFRichTextString( sst.getEntryAt( idx ) ).toString();
 headerRow.add( content );
 break;
  event = sheetReader.next();
  if ( event == XMLStreamConstants.CHARACTERS ) {
   String content = new XSSFRichTextString( sheetReader.getText() ).toString();
   headerRow.add( content );
   break;

代码示例来源：origin: pentaho/pentaho-kettle

content = new XSSFRichTextString( sst.getEntryAt( idx ) ).toString();
} else {
 content = sheetReader.getElementText();
 event = sheetReader.next();
 if ( event == XMLStreamConstants.CHARACTERS ) {
  content = new XSSFRichTextString( sheetReader.getText() ).toString();
  break;

代码示例来源：origin: org.apache.poi/poi-ooxml

thisStr = rtsi.toString();
break;

代码示例来源：origin: looly/hutool

break;
case INLINESTR:
  result = new XSSFRichTextString(value.toString()).toString();
  break;
case SSTINDEX:

代码示例来源：origin: looly/hutool

break;
case INLINESTR:
  result = new XSSFRichTextString(value.toString()).toString();
  break;
case SSTINDEX:

代码示例来源：origin: org.apache.poi/poi-ooxml

return getRichStringCellValue().toString();
case FORMULA:
  return getCellFormula();

代码示例来源：origin: programmeres/excel-boot

/**
 * 根据数据类型获取数据
 *
 * @param value
 * @return
 */
private String getCellValue(String value) {
  switch (cellFormatStr) {
    case INLINESTR:
      return new XSSFRichTextString(value).toString();
    default:
      return String.valueOf(value);
  }
}

代码示例来源：origin: wuwz/ExcelKit

private String getCellValue(String value) {
 switch (mNextCellType) {
  case BOOL:
   return value.charAt(0) == '0' ? "FALSE" : "TRUE";
  case ERROR:
   return "\"ERROR:" + value + '"';
  case FORMULA:
   return '"' + value + '"';
  case INLINESTR:
   return new XSSFRichTextString(value).toString();
  case STRING:
   return String.valueOf(value);
 }
 return value;
}

代码示例来源：origin: dremio/dremio-oss

/**
 * Resolve the given value with respect to whether it is a reference to element in shared strings table.
 * Also decode the final value.
 *
 * @param value Value read in element.
 * @param lookupNextValueInSST Whether the value is an index into the shared strings table.
 * @return
 */
private String resolveValue(String value, boolean lookupNextValueInSST) {
 if(lookupNextValueInSST) {
  int idx = (int)Double.parseDouble(value);
  return new XSSFRichTextString(sst.getEntryAt(idx)).toString();
 }
 return new XSSFRichTextString(value).toString();
}

代码示例来源：origin: monitorjbl/excel-streaming-reader

/**
 * Returns the contents of the cell, with no formatting applied
 *
 * @return
 */
String unformattedContents() {
 switch(currentCell.getType()) {
  case "s":           //string stored in shared table
   if (!lastContents.isEmpty()) {
     int idx = Integer.parseInt(lastContents);
     return new XSSFRichTextString(sst.getEntryAt(idx)).toString();
   }
   return lastContents;
  case "inlineStr":   //inline string (not in sst)
   return new XSSFRichTextString(lastContents).toString();
  default:
   return lastContents;
 }
}

代码示例来源：origin: Talend/components

/**
 * Returns the contents of the cell, with no formatting applied
 *
 * @return
 */
String unformattedContents() {
  switch (currentCell.getType()) {
  case "s": // string stored in shared table
    int idx = Integer.parseInt(lastContents);
    return new XSSFRichTextString(sst.getEntryAt(idx)).toString();
  case "inlineStr": // inline string (not in sst)
    return new XSSFRichTextString(lastContents).toString();
  default:
    return lastContents;
  }
}

代码示例来源：origin: org.talend.components/simplefileio-runtime

/**
 * Returns the contents of the cell, with no formatting applied
 *
 * @return
 */
String unformattedContents() {
  switch (currentCell.getType()) {
  case "s": // string stored in shared table
    int idx = Integer.parseInt(lastContents);
    return new XSSFRichTextString(sst.getEntryAt(idx)).toString();
  case "inlineStr": // inline string (not in sst)
    return new XSSFRichTextString(lastContents).toString();
  default:
    return lastContents;
  }
}

代码示例来源：origin: cn.afterturn/easypoi-base

/**
 * 07版本复杂数据
 * @param rich
 * @return
 */
private String getXSSFRichString(XSSFRichTextString rich) {
  int nums = rich.numFormattingRuns();
  StringBuilder sb = new StringBuilder();
  String text = rich.toString();
  int currentIndex = 0, lastIndex = 0;
  for (int i = 1; i <= nums; i++) {
    sb.append("<span ");
    try {
      sb.append("class='font_" + getFontIndex(rich.getFontOfFormattingRun(i - 1)));
      sb.append("_");
      sb.append(cssRandom);
      sb.append("'");
    } catch (Exception e) {
    }
    sb.append(">");
    currentIndex = rich.getIndexOfFormattingRun(i) == -1 ? text.length()
      : rich.getIndexOfFormattingRun(i);
    sb.append(
      XmlEscapers.xmlContentEscaper().escape(text.substring(lastIndex, currentIndex)));
    sb.append("</span>");
    lastIndex = currentIndex;
  }
  return sb.toString();
}

代码示例来源：origin: org.jeecg/easypoi-base

/**
 * 07版本复杂数据
 * @param rich
 * @return
 */
private String getXSSFRichString(XSSFRichTextString rich) {
  int nums = rich.numFormattingRuns();
  StringBuilder sb = new StringBuilder();
  String text = rich.toString();
  int currentIndex = 0, lastIndex = 0;
  for (int i = 1; i <= nums; i++) {
    sb.append("<span ");
    try {
      sb.append("class='font_" + getFontIndex(rich.getFontOfFormattingRun(i - 1)));
      sb.append("_");
      sb.append(cssRandom);
      sb.append("'");
    } catch (Exception e) {
    }
    sb.append(">");
    currentIndex = rich.getIndexOfFormattingRun(i) == -1 ? text.length()
      : rich.getIndexOfFormattingRun(i);
    sb.append(
      XmlEscapers.xmlContentEscaper().escape(text.substring(lastIndex, currentIndex)));
    sb.append("</span>");
    lastIndex = currentIndex;
  }
  return sb.toString();
}

代码示例来源：origin: zhangdaiscott/jeasypoi

/**
 * 07版本复杂数据
 * 
 * @param rich
 * @return
 */
private String getXSSFRichString(XSSFRichTextString rich) {
  int nums = rich.numFormattingRuns();
  StringBuilder sb = new StringBuilder();
  String text = rich.toString();
  int currentIndex = 0, lastIndex = 0;
  for (int i = 1; i <= nums; i++) {
    sb.append("<span ");
    try {
      sb.append("class='font_" + getFontIndex(rich.getFontOfFormattingRun(i - 1)));
      sb.append("_");
      sb.append(cssRandom);
      sb.append("'");
    } catch (Exception e) {
    }
    sb.append(">");
    currentIndex = rich.getIndexOfFormattingRun(i) == -1 ? text.length() : rich.getIndexOfFormattingRun(i);
    sb.append(XmlEscapers.xmlContentEscaper().escape(text.substring(lastIndex, currentIndex)));
    sb.append("</span>");
    lastIndex = currentIndex;
  }
  return sb.toString();
}

代码示例来源：origin: xiaolanglang/easypoi

/**
 * 07版本复杂数据
 * @param rich
 * @return
 */
private String getXSSFRichString(XSSFRichTextString rich) {
  int nums = rich.numFormattingRuns();
  StringBuilder sb = new StringBuilder();
  String text = rich.toString();
  int currentIndex = 0, lastIndex = 0;
  for (int i = 1; i <= nums; i++) {
    sb.append("<span ");
    try {
      sb.append("class='font_" + getFontIndex(rich.getFontOfFormattingRun(i - 1)));
      sb.append("_");
      sb.append(cssRandom);
      sb.append("'");
    } catch (Exception e) {
    }
    sb.append(">");
    currentIndex = rich.getIndexOfFormattingRun(i) == -1 ? text.length() : rich
      .getIndexOfFormattingRun(i);
    sb.append(XmlEscapers.xmlContentEscaper().escape(
      text.substring(lastIndex, currentIndex)));
    sb.append("</span>");
    lastIndex = currentIndex;
  }
  return sb.toString();
}

代码示例来源：origin: org.apache.poi/poi-examples

@Override
public void endElement(String uri, String localName, String name)
    throws SAXException {
  // Process the last contents as required.
  // Do now, as characters() may be called more than once
  if(nextIsString) {
    Integer idx = Integer.valueOf(lastContents);
    lastContents = lruCache.get(idx);
    if (lastContents == null && !lruCache.containsKey(idx)) {
      lastContents = new XSSFRichTextString(sst.getEntryAt(idx)).toString();
      lruCache.put(idx, lastContents);
    }
    nextIsString = false;
  }
  // v => contents of a cell
  // Output after we've seen the string contents
  if(name.equals("v") || (inlineStr && name.equals("c"))) {
    System.out.println(lastContents);
  }
}

代码示例来源：origin: org.talend.components/simplefileio-runtime

/**
 * Tries to format the contents of the last contents appropriately based on the type of cell and the discovered
 * numeric format.
 *
 * @return
 */
String formattedContents() {
  switch (currentCell.getType()) {
  case "s": // string stored in shared table
    int idx = Integer.parseInt(lastContents);
    return new XSSFRichTextString(sst.getEntryAt(idx)).toString();
  case "inlineStr": // inline string (not in sst)
    return new XSSFRichTextString(lastContents).toString();
  case "str": //
    return lastContents;
  case "e": // error type
    return StringUtils.EMPTY;// "ERROR:  " + lastContents;
  case "n": // numeric type
    if (currentCell.getNumericFormat() != null && lastContents.length() > 0) {
      return dataFormatter.formatRawCellContents(Double.parseDouble(lastContents), currentCell.getNumericFormatIndex(),
          currentCell.getNumericFormat());
    } else {
      return lastContents;
    }
  default:
    return lastContents;
  }
}

代码示例来源：origin: Talend/components

/**
 * Tries to format the contents of the last contents appropriately based on the type of cell and the discovered
 * numeric format.
 *
 * @return
 */
String formattedContents() {
  switch (currentCell.getType()) {
  case "s": // string stored in shared table
    int idx = Integer.parseInt(lastContents);
    return new XSSFRichTextString(sst.getEntryAt(idx)).toString();
  case "inlineStr": // inline string (not in sst)
    return new XSSFRichTextString(lastContents).toString();
  case "str": //
    return lastContents;
  case "e": // error type
    return StringUtils.EMPTY;// "ERROR:  " + lastContents;
  case "n": // numeric type
    if (currentCell.getNumericFormat() != null && lastContents.length() > 0) {
      return dataFormatter.formatRawCellContents(Double.parseDouble(lastContents), currentCell.getNumericFormatIndex(),
          currentCell.getNumericFormat());
    } else {
      return lastContents;
    }
  default:
    return lastContents;
  }
}

内容来源于网络，如有侵权，请联系作者删除！

XSSFRichTextString

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com