public class ExternSheetRecord extends StandardRecord
Modifier and Type | Field and Description |
---|---|
static short |
sid |
Constructor and Description |
---|
ExternSheetRecord() |
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.zkoss.poi.hssf.record.ExternSheetRecord.RefSubRecord rec)
adds REF struct (ExternSheetSubRecord)
|
static ExternSheetRecord |
combine(ExternSheetRecord[] esrs) |
int |
findRefIndexFromExtBookIndex(int extBookIndex) |
protected int |
getDataSize() |
int |
getExtbookIndexFromRefIndex(int refIndex) |
int |
getFirstSheetIndexFromRefIndex(int extRefIndex) |
int |
getLastSheetIndexFromRefIndex(int extRefIndex) |
int |
getNumOfREFRecords()
returns the number of REF Records, which is in model
|
int |
getNumOfRefs() |
int |
getRefIxForSheet(int externalBookIndex,
int sheetIndex,
int sheetIndex2) |
short |
getSid()
return the non static version of the id for this record.
|
void |
removeSheet(int sheetIndex,
int internalBookIndex) |
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)
|
void |
updateSheetIndex(int oldIndex,
int newIndex,
int internalBookIndex) |
getRecordSize, serialize
clone, cloneViaReserialise, serialize
public static final short sid
public ExternSheetRecord()
public ExternSheetRecord(RecordInputStream in)
public int getNumOfRefs()
public void addREFRecord(org.zkoss.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
RecordBase.getRecordSize()
} minus four
( record header consiting of a 'ushort sid' and 'ushort reclength' has already been written
by thye superclass).serialize
in class StandardRecord
public short getSid()
public int getExtbookIndexFromRefIndex(int refIndex)
public int findRefIndexFromExtBookIndex(int extBookIndex)
public int getFirstSheetIndexFromRefIndex(int extRefIndex)
public int getLastSheetIndexFromRefIndex(int extRefIndex)
public 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.
firstSheetIndex
- the scope, must be -2 for add-in referenceslastSheetIndex
- the scope, must be -2 for add-in referencespublic int getRefIxForSheet(int externalBookIndex, int sheetIndex, int sheetIndex2)
public static ExternSheetRecord combine(ExternSheetRecord[] esrs)
public void removeSheet(int sheetIndex, int internalBookIndex)
public void updateSheetIndex(int oldIndex, int newIndex, int internalBookIndex)
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.