Class ExternalLinksTable

java.lang.Object
org.apache.poi.ooxml.POIXMLDocumentPart
org.apache.poi.xssf.model.ExternalLinksTable

public class ExternalLinksTable extends POIXMLDocumentPart
Holds details of links to parts of other workbooks (eg named ranges), along with the most recently seen values for what they point to.
  • Constructor Details

    • ExternalLinksTable

      public ExternalLinksTable()
    • ExternalLinksTable

      public ExternalLinksTable(PackagePart part) throws IOException
      Throws:
      IOException
      Since:
      3.14-Beta1
  • Method Details

    • readFrom

      public void readFrom(InputStream is) throws IOException
      Throws:
      IOException
    • writeTo

      public void writeTo(OutputStream out) throws IOException
      Throws:
      IOException
    • commit

      protected void commit() throws IOException
      Description copied from class: POIXMLDocumentPart
      Save the content in the underlying package part. Default implementation is empty meaning that the package part is left unmodified.

      Sub-classes should override and add logic to marshal the "model" into Ooxml4J.

      For example, the code saving a generic XML entry may look as follows:

       protected void commit() throws IOException {
         PackagePart part = getPackagePart();
         try (OutputStream out = part.getOutputStream()) {
           XmlObject bean = getXmlBean(); //the "model" which holds changes in memory
           bean.save(out, DEFAULT_XML_OPTIONS);
         }
       }
       
      Overrides:
      commit in class POIXMLDocumentPart
      Throws:
      IOException - a subclass may throw an IOException if the changes can't be committed
    • getCTExternalLink

      @Internal @Removal(version="6.0.0") @Deprecated(forRemoval=true) public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTExternalLink getCTExternalLink()
      Deprecated, for removal: This API element is subject to removal in a future version.
      will be removed because we don't want to expose this (future implementations may not be XMLBeans based)
      Returns the underlying xmlbeans object for the external link table. Internal use only. Not currently used internally.
    • getLinkedFileName

      public String getLinkedFileName()
      Returns the last recorded name of the file that this is linked to
    • setLinkedFileName

      public void setLinkedFileName(String target)
      Updates the last recorded name for the file that this links to
    • getSheetNames

      public List<String> getSheetNames()
    • getDefinedNames

      public List<Name> getDefinedNames()
    • cacheData

      public void cacheData(String sheetName, long rowR, String cellR, String v)