Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## org.apache.poi.hssf.record
Class ExternSheetRecord

    java.lang.Object
      org.apache.poi.hssf.record.RecordBase
          org.apache.poi.hssf.record.Record
              org.apache.poi.hssf.record.StandardRecord
                  org.apache.poi.hssf.record.ExternSheetRecord

    public class ExternSheetRecord

extends StandardRecord

EXTERNSHEET (0x0017)
A List of Indexes to EXTERNALBOOK (supplemental book) Records

Author:
  Libin Roman (Vista Portal LDT. Developer)

Field Summary
`static short` | `sid`

Constructor Summary
`ExternSheetRecord()`
`ExternSheetRecord(RecordInputStream in)`

Method Summary
`int` | `addRef(int extBookIndex, int firstSheetIndex, int lastSheetIndex)`
`void` | `addREFRecord(org.apache.poi.hssf.record.ExternSheetRecord.RefSubRecord rec)` adds REF struct (ExternSheetSubRecord)
`static ExternSheetRecord` | `combine(ExternSheetRecord[] esrs)`
`int` | `findRefIndexFromExtBookIndex(int extBookIndex)`
`int` | `getExtbookIndexFromRefIndex(int refIndex)`
`int` | `getFirstSheetIndexFromRefIndex(int extRefIndex)`
`int` | `getNumOfREFRecords()` returns the number of REF Records, which is in model
`int` | `getNumOfRefs()`
`int` | `getRefIxForSheet(int externalBookIndex, int sheetIndex)`
`short` | `getSid()` return the non static version of the id for this record.
`void` | `serialize(LittleEndianOutput out)` Write the data content of this BIFF record.
`java.lang.String` | `toString()` get a string representation of the record (for biffview/debugging)

Methods inherited from class org.apache.poi.hssf.record.StandardRecord
`getRecordSize, serialize`

Methods inherited from class org.apache.poi.hssf.record.Record
`clone, cloneViaReserialise, serialize`

Methods inherited from class java.lang.Object
`equals, getClass, hashCode, notify, notifyAll, wait, wait, wait`

Field Detail

### sid

    public static final short sid

See Also:
  Constant Field Values

Constructor Detail

### ExternSheetRecord

    public ExternSheetRecord()

### ExternSheetRecord

    public ExternSheetRecord(RecordInputStream in)

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 subclass must write the exact number of bytes as reported by `RecordBase.getRecordSize()`}

### 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)

### findRefIndexFromExtBookIndex

    public int findRefIndexFromExtBookIndex(int extBookIndex)

  Returns:
    -1 if not found

### getFirstSheetIndexFromRefIndex

    public int getFirstSheetIndexFromRefIndex(int extRefIndex)

### addRef

    public int addRef(int extBookIndex,
                      int firstSheetIndex,
                      int lastSheetIndex)

  Returns:
    index of newly added ref

### getRefIxForSheet

    public int getRefIxForSheet(int externalBookIndex,
                                int sheetIndex)

### combine

    public static ExternSheetRecord combine(ExternSheetRecord[] esrs)

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD