@Override public List<HSSFName> getNames(String name) { List<HSSFName> nameList = new ArrayList<>(); for(HSSFName nr : names) { if(nr.getNameName().equals(name)) { nameList.add(nr); } } return Collections.unmodifiableList(nameList); }
/** creates a new named range and add it to the model * @return named range high level */ @Override public HSSFName createName(){ NameRecord nameRecord = workbook.createName(); HSSFName newName = new HSSFName(this, nameRecord); names.add(newName); return newName; }
final int i = name.getSheetIndex(); name.setSheetIndex(newIndex); name.setSheetIndex(i+1); name.setSheetIndex(i-1);
HSSFName aNamedRange = templateWorkbook.getNameAt(i); String refersToFormula = aNamedRange.getRefersToFormula(); if (!AreaReference.isContiguous(refersToFormula)) { continue; String name = aNamedRange.getNameName(); SheetRange sheetRange = new SheetRange(mergedRegion, currentSheet.getSheetName()); if (mergeRegionsForRangeNames.get(name) == null) {
/** * Returns the formula that the name is defined to refer to. * * @deprecated (Nov 2008) Misleading name. Use {@link #getRefersToFormula()} instead. */ public String getReference() { return getRefersToFormula(); }
public void setRefersToFormula(String formulaText) { Ptg[] ptgs = HSSFFormulaParser.parse(formulaText, _book, FormulaType.NAMEDRANGE, getSheetIndex()); _definedNameRec.setNameDefinition(ptgs); }
validateName(nameName);
name.setNameDefinition(ptgs);
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); } }
/** * Sets the formula that the name is defined to refer to. * * @deprecated (Nov 2008) Misleading name. Use {@link #setRefersToFormula(String)} instead. */ public void setReference(String ref){ setRefersToFormula(ref); }
HSSFName aNamedRange = templateWorkbook.getNameAt(i); String refersToFormula = aNamedRange.getRefersToFormula(); if (!AreaReference.isContiguous(refersToFormula)) { continue; String name = aNamedRange.getNameName(); SheetRange sheetRange = new SheetRange(mergedRegion, currentSheet.getSheetName()); if (mergeRegionsForRangeNames.get(name) == null) {
/** * Returns the formula that the name is defined to refer to. * * @deprecated (Nov 2008) Misleading name. Use {@link #getRefersToFormula()} instead. */ public String getReference() { return getRefersToFormula(); }
public void setRefersToFormula(String formulaText) { Ptg[] ptgs = HSSFFormulaParser.parse(formulaText, _book, FormulaType.NAMEDRANGE, getSheetIndex()); _definedNameRec.setNameDefinition(ptgs); }
name.setNameDefinition(ptgs);
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); } }
/** * Sets the formula that the name is defined to refer to. * * @deprecated (Nov 2008) Misleading name. Use {@link #setRefersToFormula(String)} instead. */ public void setReference(String ref){ setRefersToFormula(ref); }
HSSFName createBuiltInName(byte builtinCode, int sheetIndex) { NameRecord nameRecord = workbook.createBuiltInName(builtinCode, sheetIndex + 1); HSSFName newName = new HSSFName(this, nameRecord, null); names.add(newName); return newName; }
/** 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(); }
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); }