/** 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; }
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; }
if (filterDbNameIndex != -1) { NameRecord newNameRecord = workbook.cloneFilter(filterDbNameIndex, newSheetIndex); HSSFName newName = new HSSFName(this, newNameRecord); names.add(newName);
HSSFName name = new HSSFName(this, nameRecord, workbook.getNameCommentRecord(nameRecord)); names.add(name);
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; }
/** 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; }
/** creates a new named range and add it to the model * @return named range high level */ public HSSFName createName(){ NameRecord nameRecord = workbook.createName(); HSSFName newName = new HSSFName(this, nameRecord); names.add(newName); return newName; }
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; }
/** creates a new named range and add it to the model * @return named range high level */ public HSSFName createName(){ NameRecord nameRecord = workbook.createName(); HSSFName newName = new HSSFName(this, nameRecord); names.add(newName); return newName; }
if (filterDbNameIndex != -1) { NameRecord newNameRecord = workbook.cloneFilter(filterDbNameIndex, newSheetIndex); HSSFName newName = new HSSFName(this, newNameRecord); names.add(newName);
if (filterDbNameIndex != -1) { NameRecord newNameRecord = workbook.cloneFilter(filterDbNameIndex, newSheetIndex); HSSFName newName = new HSSFName(this, newNameRecord); names.add(newName);
HSSFName newName = new HSSFName(this, nameRecord, nameRecord.isBuiltInName() ? null : workbook.getNameCommentRecord(nameRecord)); names.add(newName);
/** * create an HSSFSheet from an existing sheet in the HSSFWorkbook. * * @return HSSFSheet representing the cloned sheet. */ public HSSFSheet cloneSheet(int sheetIndex) { validateSheetIndex(sheetIndex); HSSFSheet srcSheet = _sheets.get(sheetIndex); String srcName = workbook.getSheetName(sheetIndex); HSSFSheet clonedSheet = srcSheet.cloneSheet(this); clonedSheet.setSelected(false); clonedSheet.setActive(false); String name = getUniqueSheetName(srcName); int newSheetIndex = _sheets.size(); _sheets.add(clonedSheet); workbook.setSheetName(newSheetIndex, name); // Check this sheet has an autofilter, (which has a built-in NameRecord at workbook level) int filterDbNameIndex = findExistingBuiltinNameRecordIdx(sheetIndex, NameRecord.BUILTIN_FILTER_DB); if (filterDbNameIndex != -1) { NameRecord newNameRecord = workbook.cloneFilter(filterDbNameIndex, newSheetIndex); HSSFName newName = new HSSFName(this, newNameRecord); names.add(newName); } // TODO - maybe same logic required for other/all built-in name records workbook.cloneDrawings(clonedSheet.getSheet()); return clonedSheet; }
HSSFName name = new HSSFName(this, nameRecord, workbook.getNameCommentRecord(nameRecord)); names.add(name);
HSSFName name = new HSSFName(this, nameRecord, workbook.getNameCommentRecord(nameRecord)); names.add(name);
HSSFName name = new HSSFName(this, nameRecord, workbook.getNameCommentRecord(nameRecord)); names.add(name);