public class ExternSheetRecord extends StandardRecord
A List of Indexes to EXTERNALBOOK (supplemental book) Records
(EXTERNSHEET (0x0017) EXTERNALBOOK(补充书)记录的索引列表)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 .
(添加对 SupBookRecord 的从零开始的引用。)
|
void |
addREFRecord(org.apache.poi.hssf.record.ExternSheetRecord.RefSubRecord rec)
adds REF struct (ExternSheetSubRecord)
(添加 REF 结构 (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.
(返回引用适用的第一个工作表,如果找不到引用的工作表,则返回 -1,如果引用是工作簿范围内的,则返回 -2。)
|
java.util.Map<java.lang.String,java.util.function.Supplier<?>> |
getGenericProperties() |
HSSFRecordTypes |
getGenericRecordType() |
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.
(返回引用适用的最后一个工作表,如果找不到引用的工作表,则返回 -1,如果引用是工作簿范围内的,则返回 -2。)
|
int |
getNumOfREFRecords()
returns the number of REF Records, which is in model
(返回模型中的 REF 记录数)
|
int |
getNumOfRefs() |
int |
getRefIxForSheet(int externalBookIndex, int firstSheetIndex, int lastSheetIndex) |
short |
getSid()
return the non static version of the id for this record.
(返回此记录的 id 的非静态版本。)
|
void |
removeSheet(int sheetIdx) |
void |
serialize(LittleEndianOutput out)
Write the data content of this BIFF record.
(写入此 BIFF 记录的数据内容。)
|
getRecordSize, serialize
cloneViaReserialise, serialize, toString
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
getGenericChildren
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 struct
(rec - 参考结构)
public int getNumOfREFRecords()
protected int getDataSize()
getDataSize
in class
StandardRecord
(类 StandardRecord 中的 getDataSize)
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
(在 StandardRecord 类中序列化)
out
- the output object
(out - 输出对象)
public void removeSheet(int sheetIdx)
public short getSid()
public int getExtbookIndexFromRefIndex(int refIndex)
refIndex
- specifies the n-th refIndex
(refIndex - 指定第 n 个 refIndex)
public int findRefIndexFromExtBookIndex(int extBookIndex)
extBookIndex
- external sheet reference index
(extBookIndex - 外部工作表参考索引)
public int getFirstSheetIndexFromRefIndex(int extRefIndex)
extRefIndex
- external sheet reference index
(extRefIndex - 外部图纸参考索引)
public int getLastSheetIndexFromRefIndex(int extRefIndex)
extRefIndex
- external sheet reference index
(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.
extBookIndex
- the external book block index
(extBookIndex - 外部书芯索引)
firstSheetIndex
- the scope, must be -2 for add-in references
(firstSheetIndex - 范围,对于加载项引用必须为 -2)
lastSheetIndex
- the scope, must be -2 for add-in references
(lastSheetIndex - 范围,对于加载项引用必须为 -2)
public int getRefIxForSheet(int externalBookIndex, int firstSheetIndex, int lastSheetIndex)
public static ExternSheetRecord combine(ExternSheetRecord[] esrs)
public ExternSheetRecord copy()
copy
in interface
Duplicatable
(复制到界面 Duplicatable)
copy
in class
StandardRecord
(在 StandardRecord 类中复制)
public HSSFRecordTypes getGenericRecordType()
getGenericRecordType
in interface
GenericRecord
(接口 GenericRecord 中的 getGenericRecordType)
getGenericRecordType
in class
Record
(类 Record 中的 getGenericRecordType)
public java.util.Map<java.lang.String,java.util.function.Supplier<?>> getGenericProperties()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.