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

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

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

XSSFRichTextString.getIndexOfFormattingRun介绍

[英]The index within the string to which the specified formatting run applies.
[中]指定格式运行应用到的字符串中的索引。

代码示例

代码示例来源: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: 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: 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: 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: stackoverflow.com

public static final void main(String... args) throws Exception
{
  InputStream is = ExcelFormatTest.class.getResourceAsStream("Test.xlsx");
  Workbook wb = new XSSFWorkbook(is);
  Sheet sheet = wb.getSheetAt(0);
  Cell cell = sheet.getRow(0).getCell(0);
  XSSFRichTextString richText = (XSSFRichTextString)cell.getRichStringCellValue();
  int formattingRuns = cell.getRichStringCellValue().numFormattingRuns();

  for(int i = 0; i < formattingRuns; i++)
  {
    int startIdx = richText.getIndexOfFormattingRun(i);
    int length = richText.getLengthOfFormattingRun(i);
    System.out.println("Text: " + richText.getString().substring(startIdx, startIdx + length));
    if(i == 0)
    {
      short fontIndex = cell.getCellStyle().getFontIndex();
      Font f = wb.getFontAt(fontIndex);
      System.out.println("Bold: " + (f.getBoldweight() == Font.BOLDWEIGHT_BOLD));
      System.out.println("Italics: " + f.getItalic() + "\n");
    }
    else
    {
      Font f = richText.getFontOfFormattingRun(i);
      System.out.println("Bold: " + (f.getBoldweight() == Font.BOLDWEIGHT_BOLD));
      System.out.println("Italics: " + f.getItalic() + "\n");
    }
  }
}

代码示例来源:origin: stackoverflow.com

cellText.getIndexOfFormattingRun(i),
cellText.getIndexOfFormattingRun(i)
    + cellText.getLengthOfFormattingRun(i));

代码示例来源:origin: stackoverflow.com

int indexStart = cellText.getIndexOfFormattingRun(i);
int indexEnd = indexStart + cellText.getLengthOfFormattingRun(i);

相关文章