Documentation of 'org.apache.poi.hssf.record.ExternSheetRecord' Java class
ExternSheetRecord
Skip navigation links
org.apache.poi.hssf.record

Class ExternSheetRecord


  • public class ExternSheetRecord
extends StandardRecord
    EXTERNSHEET (0x0017)
    A List of Indexes to EXTERNALBOOK (supplemental book) Records

    • Constructor Detail

      • ExternSheetRecord

        public ExternSheetRecord()

    • Method Detail

      • getNumOfRefs

        public int getNumOfRefs()
        Returns:
        number of REF structures

      • addREFRecord

        public void addREFRecord(org.apache.poi.hssf.record.ExternSheetRecord.RefSubRecord rec)
        adds REF struct (ExternSheetSubRecord)
        Parameters:
        rec - REF struct

      • getNumOfREFRecords

        public int getNumOfREFRecords()
        returns the number of REF Records, which is in model
        Returns:
        number of REF records

      • toString

        public java.lang.String toString()
        Description copied from class: Record
        get a string representation of the record (for biffview/debugging)
        Overrides:
        toString in class Record

      • serialize

        public void serialize(LittleEndianOutput out)
        Description copied from class: StandardRecord
        Write the data content of this BIFF record. The 'ushort sid' and 'ushort size' header fields have already been written by the superclass.
        The number of bytes written must equal the record size reported by RecordBase.getRecordSize()} minus four ( record header consiting of a 'ushort sid' and 'ushort reclength' has already been written by thye superclass).

      • adjustIndex

        @Deprecated
public void adjustIndex(int extRefIndex,
                                    int offset)
        Deprecated. Was prevously used for removing sheets, which we now do differently

      • removeSheet

        public void removeSheet(int sheetIdx)

      • getSid

        public short getSid()
        return the non static version of the id for this record.
        Specified by:
        getSid in class Record

      • getExtbookIndexFromRefIndex

        public int getExtbookIndexFromRefIndex(int refIndex)
        Returns the index of the SupBookRecord for this index

      • findRefIndexFromExtBookIndex

        public int findRefIndexFromExtBookIndex(int extBookIndex)
        Returns:
        -1 if not found

      • getFirstSheetIndexFromRefIndex

        public int getFirstSheetIndexFromRefIndex(int extRefIndex)
        Returns the first sheet that the reference applies to, or -1 if the referenced sheet can't be found, or -2 if the reference is workbook scoped.

      • getLastSheetIndexFromRefIndex

        public int getLastSheetIndexFromRefIndex(int extRefIndex)
        Returns the last sheet that the reference applies to, or -1 if the referenced sheet can't be found, or -2 if the reference is workbook scoped. For a single sheet reference, the first and last should be the same.

      • addRef

        public int addRef(int extBookIndex,
                  int firstSheetIndex,
                  int lastSheetIndex)
        Add a zero-based reference to a SupBookRecord.

        If the type of the SupBook record is same-sheet referencing, Add-In referencing, DDE data source referencing, or OLE data source referencing, then no scope is specified and this value MUST be -2. Otherwise, the scope must be set as follows:

        1. -2 Workbook-level reference that applies to the entire workbook.
        2. -1 Sheet-level reference.
        3. >=0 Sheet-level reference. This specifies the first sheet in the reference.

          If the SupBook type is unused or external workbook referencing, then this value specifies the zero-based index of an external sheet name, see SupBookRecord.getSheetNames(). This referenced string specifies the name of the first sheet within the external workbook that is in scope. This sheet MUST be a worksheet or macro sheet.

          If the supporting link type is self-referencing, then this value specifies the zero-based index of a BoundSheetRecord record in the workbook stream that specifies the first sheet within the scope of this reference. This sheet MUST be a worksheet or a macro sheet.

        Parameters:
        firstSheetIndex - the scope, must be -2 for add-in references
        lastSheetIndex - the scope, must be -2 for add-in references
        Returns:
        index of newly added ref

      • getRefIxForSheet

        public int getRefIxForSheet(int externalBookIndex,
                            int firstSheetIndex,
                            int lastSheetIndex)
Skip navigation links

DataMelt 3.0 © DataMelt by jWork.ORG

Ads help maintain this website.