public class ExternSheetRecord extends StandardRecord
A List of Indexes to EXTERNALBOOK (supplemental book) Records
Modifier and Type | Field and Description |
---|---|
static short |
sid |
Constructor and Description |
---|
ExternSheetRecord() |
ExternSheetRecord(ExternSheetRecord other) |
ExternSheetRecord(RecordInputStream in) |
Modifier and Type | Method and Description |
---|---|
int |
addRef(int extBookIndex,
int firstSheetIndex,
int lastSheetIndex)
Add a zero-based reference to a
SupBookRecord . |
void |
addREFRecord(org.apache.poi.hssf.record.ExternSheetRecord.RefSubRecord rec)
adds REF struct (ExternSheetSubRecord)
|
static ExternSheetRecord |
combine(ExternSheetRecord[] esrs) |
ExternSheetRecord |
copy() |
int |
findRefIndexFromExtBookIndex(int extBookIndex) |
protected int |
getDataSize() |
int |
getExtbookIndexFromRefIndex(int refIndex) |
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.
|
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.
|
int |
getNumOfREFRecords()
returns the number of REF Records, which is in model
|
int |
getNumOfRefs() |
int |
getRefIxForSheet(int externalBookIndex,
int firstSheetIndex,
int lastSheetIndex) |
short |
getSid()
return the non static version of the id for this record.
|
void |
removeSheet(int sheetIdx) |
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)
|
getRecordSize, serialize
cloneViaReserialise, serialize
public static final short sid
public ExternSheetRecord()
public ExternSheetRecord(ExternSheetRecord other)
public ExternSheetRecord(RecordInputStream in)
public int getNumOfRefs()
public void addREFRecord(org.apache.poi.hssf.record.ExternSheetRecord.RefSubRecord rec)
rec
- REF structpublic int getNumOfREFRecords()
public java.lang.String toString()
Record
protected int getDataSize()
getDataSize
in class StandardRecord
public void serialize(LittleEndianOutput out)
StandardRecord
The number of bytes written must equal the record size reported by
RecordBase.getRecordSize()
} minus four (
record header consisting of a 'ushort sid' and 'ushort reclength' has
already been written by their superclass).
serialize
in class StandardRecord
out
- the output objectpublic void removeSheet(int sheetIdx)
public short getSid()
public int getExtbookIndexFromRefIndex(int refIndex)
refIndex
- specifies the n-th refIndexpublic int findRefIndexFromExtBookIndex(int extBookIndex)
extBookIndex
- external sheet reference indexpublic int getFirstSheetIndexFromRefIndex(int extRefIndex)
extRefIndex
- external sheet reference indexpublic int getLastSheetIndexFromRefIndex(int extRefIndex)
extRefIndex
- external sheet reference indexpublic int addRef(int extBookIndex, int firstSheetIndex, int lastSheetIndex)
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:
-2
Workbook-level reference that applies to the entire workbook.-1
Sheet-level reference. >=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.
extBookIndex
- the external book block indexfirstSheetIndex
- the scope, must be -2 for add-in referenceslastSheetIndex
- the scope, must be -2 for add-in referencespublic int getRefIxForSheet(int externalBookIndex, int firstSheetIndex, int lastSheetIndex)
public static ExternSheetRecord combine(ExternSheetRecord[] esrs)
public ExternSheetRecord copy()
copy
in interface Duplicatable
copy
in class StandardRecord
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.