private XSSFSheet getSheetFromZipEntryName(String sheetRef) { for(XSSFSheet sheet : _sxFromXHash.values()) { if(sheetRef.equals(sheet.getPackagePart().getPartName().getName().substring(1))) { return sheet; } } return null; }
@Override protected void commit() throws IOException { PackagePart part = getPackagePart(); OutputStream out = part.getOutputStream(); write(out); out.close(); }
/** * Get the document's embedded files. */ @Override public List<PackagePart> getAllEmbeddedParts() throws OpenXML4JException { List<PackagePart> embedds = new LinkedList<>(); for(XSSFSheet sheet : sheets){ // Get the embeddings for the workbook for(PackageRelationship rel : sheet.getPackagePart().getRelationshipsByType(XSSFRelation.OLEEMBEDDINGS.getRelation())) { embedds.add( sheet.getPackagePart().getRelatedPart(rel) ); } for(PackageRelationship rel : sheet.getPackagePart().getRelationshipsByType(XSSFRelation.PACKEMBEDDINGS.getRelation())) { embedds.add( sheet.getPackagePart().getRelatedPart(rel) ); } } return embedds; }
protected XSSFDialogsheet(XSSFSheet sheet) { super(sheet.getPackagePart()); this.dialogsheet = CTDialogsheet.Factory.newInstance(); this.worksheet = CTWorksheet.Factory.newInstance(); }
/** * Initialize worksheet data when reading in an exisiting file. */ @Override protected void onDocumentRead() { try { read(getPackagePart().getInputStream()); } catch (IOException e){ throw new POIXMLException(e); } }
/** * Read hyperlink relations, link them with CTHyperlink beans in this worksheet * and initialize the internal array of XSSFHyperlink objects */ private void initHyperlinks() { hyperlinks = new ArrayList<>(); if(!worksheet.isSetHyperlinks()) { return; } try { PackageRelationshipCollection hyperRels = getPackagePart().getRelationshipsByType(XSSFRelation.SHEET_HYPERLINKS.getRelation()); // Turn each one into a XSSFHyperlink for(CTHyperlink hyperlink : worksheet.getHyperlinks().getHyperlinkArray()) { PackageRelationship hyperRel = null; if(hyperlink.getId() != null) { hyperRel = hyperRels.getRelationshipByID(hyperlink.getId()); } hyperlinks.add( new XSSFHyperlink(hyperlink, hyperRel) ); } } catch (InvalidFormatException e){ throw new POIXMLException(e); } }
int tableNumber = getPackagePart().getPackage().getPartsByContentType(XSSFRelation.TABLE.getContentType()).size() + 1; while(loop) { loop = false; for (PackagePart packagePart : getPackagePart().getPackage().getPartsByContentType(XSSFRelation.TABLE.getContentType())) { String fileName = XSSFRelation.TABLE.getFileName(tableNumber); if(fileName.equals(packagePart.getPartName().getName())) {
/** * Create a new SpreadsheetML drawing. If this sheet already contains a drawing - return that. * * @return a SpreadsheetML drawing */ @Override public XSSFDrawing createDrawingPatriarch() { CTDrawing ctDrawing = getCTDrawing(); if (ctDrawing != null) { return getDrawingPatriarch(); } // Default drawingNumber = #drawings.size() + 1 int drawingNumber = getPackagePart().getPackage().getPartsByContentType(XSSFRelation.DRAWINGS.getContentType()).size() + 1; drawingNumber = getNextPartNumber(XSSFRelation.DRAWINGS, drawingNumber); RelationPart rp = createRelationship(XSSFRelation.DRAWINGS, XSSFFactory.getInstance(), drawingNumber, false); XSSFDrawing drawing = rp.getDocumentPart(); String relId = rp.getRelationship().getId(); //add CT_Drawing element which indicates that this sheet contains drawing components built on the drawingML platform. //The relationship Id references the part containing the drawingML definitions. ctDrawing = worksheet.addNewDrawing(); ctDrawing.setId(relId); // Return the newly created drawing return drawing; }
hyperlink.generateRelationIfNeeded(getPackagePart());
if(autoCreate) { int drawingNumber = getPackagePart().getPackage().getPartsByContentType(XSSFRelation.VML_DRAWINGS.getContentType()).size() + 1; RelationPart rp = createRelationship(XSSFRelation.VML_DRAWINGS, XSSFFactory.getInstance(), drawingNumber, false); drawing = rp.getDocumentPart();
for(PackageRelationship pr : srcSheet.getPackagePart().getRelationships()) { if (pr.getTargetMode() == TargetMode.EXTERNAL) { clonedSheet.getPackagePart().addExternalRelationship (pr.getTargetURI().toASCIIString(), pr.getRelationshipType(), pr.getId());
@Override public XSSFObjectData createObjectData(ClientAnchor anchor, int storageId, int pictureIndex) { XSSFSheet sh = getSheet(); PackagePart sheetPart = sh.getPackagePart();
private XSSFSheet getSheetFromZipEntryName(String sheetRef) { for(XSSFSheet sheet : _sxFromXHash.values()) { if(sheetRef.equals(sheet.getPackagePart().getPartName().getName().substring(1))) { return sheet; } } return null; }
private XSSFSheet getSheetFromZipEntryName(String sheetRef) { for(XSSFSheet sheet : _sxFromXHash.values()) { if(sheetRef.equals(sheet.getPackagePart().getPartName().getName().substring(1))) return sheet; } return null; } private void injectData(File zipfile, OutputStream out) throws IOException
@Override protected void commit() throws IOException { PackagePart part = getPackagePart(); OutputStream out = part.getOutputStream(); write(out); out.close(); }
@Override protected void commit() throws IOException { PackagePart part = getPackagePart(); OutputStream out = part.getOutputStream(); write(out); out.close(); }
protected XSSFDialogsheet(XSSFSheet sheet) { super(sheet.getPackagePart()); this.dialogsheet = CTDialogsheet.Factory.newInstance(); this.worksheet = CTWorksheet.Factory.newInstance(); }
/** * Initialize worksheet data when reading in an exisiting file. */ @Override protected void onDocumentRead() { try { read(getPackagePart().getInputStream()); } catch (IOException e){ throw new POIXMLException(e); } }
protected XSSFDialogsheet(XSSFSheet sheet) { super(sheet.getPackagePart(), sheet.getPackageRelationship()); this.dialogsheet = CTDialogsheet.Factory.newInstance(); this.worksheet = CTWorksheet.Factory.newInstance(); }
/** * Initialize worksheet data when reading in an exisiting file. */ @Override protected void onDocumentRead() { try { read(getPackagePart().getInputStream()); } catch (IOException e){ throw new POIXMLException(e); } }