org.apache.poi.hssf.usermodel.HSSFWorkbook.getNameAt()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(3.4k)|赞(0)|评价(0)|浏览(118)

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

HSSFWorkbook.getNameAt介绍

暂无

代码示例

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

/** gets the named range name
 * @param index the named range index (0 based)
 * @return named range name
 */
public String getNameName(int index){
  return getNameAt(index).getNameName();
}

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/** gets the named range name
 * @param index the named range index (0 based)
 * @return named range name
 */
public String getNameName(int index){
  return getNameAt(index).getNameName();
}

代码示例来源:origin: com.haulmont.thirdparty/poi

/** gets the named range name
 * @param index the named range index (0 based)
 * @return named range name
 */
public String getNameName(int index){
  String result = getNameAt(index).getNameName();
  return result;
}

代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev

/** gets the named range name
 * @param index the named range index (0 based)
 * @return named range name
 */
public String getNameName(int index){
  String result = getNameAt(index).getNameName();
  return result;
}

代码示例来源:origin: com.haulmont.yarg/yarg

public static AreaReference getAreaForRange(HSSFWorkbook workbook, String rangeName) {
  int rangeNameIdx = workbook.getNameIndex(rangeName);
  if (rangeNameIdx == -1) return null;
  HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
  return new AreaReference(aNamedRange.getRefersToFormula(), SpreadsheetVersion.EXCEL97);
}

代码示例来源:origin: com.haulmont.yarg/yarg

public static HSSFSheet getTemplateSheetForRangeName(HSSFWorkbook workbook, String rangeName) {
    int rangeNameIdx = workbook.getNameIndex(rangeName);
    if (rangeNameIdx == -1) return null;

    HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
    String sheetName = aNamedRange.getSheetName();
    return workbook.getSheet(sheetName);
  }
}

代码示例来源:origin: cuba-platform/yarg

public static AreaReference getAreaForRange(HSSFWorkbook workbook, String rangeName) {
  int rangeNameIdx = workbook.getNameIndex(rangeName);
  if (rangeNameIdx == -1) return null;
  HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
  return new AreaReference(aNamedRange.getRefersToFormula(), SpreadsheetVersion.EXCEL97);
}

代码示例来源:origin: cuba-platform/yarg

public static HSSFSheet getTemplateSheetForRangeName(HSSFWorkbook workbook, String rangeName) {
    int rangeNameIdx = workbook.getNameIndex(rangeName);
    if (rangeNameIdx == -1) return null;

    HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
    String sheetName = aNamedRange.getSheetName();
    return workbook.getSheet(sheetName);
  }
}

代码示例来源:origin: cuba-platform/yarg

int rangeNumber = templateWorkbook.getNumberOfNames();
for (int i = 0; i < rangeNumber; i++) {
  HSSFName aNamedRange = templateWorkbook.getNameAt(i);

代码示例来源:origin: com.haulmont.yarg/yarg

int rangeNumber = templateWorkbook.getNumberOfNames();
for (int i = 0; i < rangeNumber; i++) {
  HSSFName aNamedRange = templateWorkbook.getNameAt(i);

代码示例来源:origin: com.haulmont.yarg/yarg

if (rangeNameIdx == -1) return;
HSSFName aNamedRange = templateWorkbook.getNameAt(rangeNameIdx);
AreaReference aref = new AreaReference(aNamedRange.getRefersToFormula());
int column = aref.getFirstCell().getCol();

代码示例来源:origin: cuba-platform/yarg

if (rangeNameIdx == -1) return;
HSSFName aNamedRange = templateWorkbook.getNameAt(rangeNameIdx);
AreaReference aref = new AreaReference(aNamedRange.getRefersToFormula(), SpreadsheetVersion.EXCEL97);
int column = aref.getFirstCell().getCol();

相关文章

HSSFWorkbook类方法