Example usage for org.apache.poi.hssf.usermodel HSSFName getSheetName

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFName getSheetName.

Prototype

public String getSheetName() 

Source Link

Document

Get the sheets name which this named range is referenced to

Usage

From source file:com.haulmont.yarg.formatters.impl.xls.HSSFRangeHelper.java

License:Apache License

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);
}

---

From source file:org.openelis.bean.QcChartReport1Bean.java

License:Open Source License

private HSSFName getName(HSSFWorkbook wb, HSSFSheet sheet, String nameString) {
    int i;/*from   w  w  w.ja va 2 s. c o  m*/
    HSSFName name;

    for (i = 0; i < wb.getNumberOfNames(); i++) {
        name = wb.getNameAt(i);
        if (name.getNameName().equals(nameString) && name.getSheetName().equals(sheet.getSheetName()))
            return name;
    }

    return null;
}

---