@Override public HSSFName getName(String name) { int nameIndex = getNameIndex(name); if (nameIndex < 0) { return null; } return names.get(nameIndex); }
@Override public void removeName(String name) { int index = getNameIndex(name); removeName(index); }
/** * As {@link #removeName(String)} is not necessarily unique * (name + sheet index is unique), this method is more accurate. * * @param name the name to remove. */ @Override public void removeName(Name name) { int index = getNameIndex((HSSFName) name); removeName(index); }
@Override public HSSFName getName(String name) { int nameIndex = getNameIndex(name); if (nameIndex < 0) { return null; } return names.get(nameIndex); }
public HSSFName getName(String name) { int nameIndex = getNameIndex(name); if (nameIndex < 0) { return null; } return (HSSFName) names.get(nameIndex); }
public HSSFName getName(String name) { int nameIndex = getNameIndex(name); if (nameIndex < 0) { return null; } return (HSSFName) names.get(nameIndex); }
/** * As {@link #removeName(String)} is not necessarily unique * (name + sheet index is unique), this method is more accurate. * * @param name the name to remove. */ void removeName(HSSFName name) { int index = getNameIndex(name); removeName(index); }
@Override public void removeName(String name) { int index = getNameIndex(name); removeName(index); }
/** * As {@link #removeName(String)} is not necessarily unique * (name + sheet index is unique), this method is more accurate. * * @param name the name to remove. */ @Override public void removeName(Name name) { int index = getNameIndex((HSSFName) name); removeName(index); }
public void removeName(String name) { int index = getNameIndex(name); removeName(index); }
public void removeName(String name) { int index = getNameIndex(name); removeName(index); }
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); }
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); } }
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); } }
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); }
int rangeNameIdx = templateWorkbook.getNameIndex(rangeName); if (rangeNameIdx == -1) return;
int rangeNameIdx = templateWorkbook.getNameIndex(rangeName); if (rangeNameIdx == -1) return;