Package org.apache.poi.hssf.record
Class BoundSheetRecord
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.BoundSheetRecord
Title: Bound Sheet Record (aka BundleSheet) (0x0085)
Description: Defines a sheet within a workbook. Basically stores the sheet name and tells where the Beginning of file record is within the HSSF file.
REFERENCE: PG 291 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
-
Field Summary
Fields -
Constructor Summary
ConstructorsConstructorDescriptionBoundSheetRecord(String sheetname) UTF8: sid + len + bof + flags + len(str) + unicode + str 2 + 2 + 4 + 2 + 1 + 1 + len(str) UNICODE: sid + len + bof + flags + len(str) + unicode + str 2 + 2 + 4 + 2 + 1 + 1 + 2 * len(str) -
Method Summary
Modifier and TypeMethodDescriptionprotected intintget the offset in bytes of the Beginning of File Marker within the HSSF Stream part of the POIFS fileget the sheetname for this sheet.shortgetSid()return the non static version of the id for this record.booleanisHidden()Is the sheet hidden? Different from very hiddenbooleanIs the sheet very hidden? Different from (normal) hiddenstatic BoundSheetRecord[]orderByBofPosition(List<BoundSheetRecord> boundSheetRecords) Converts a List ofBoundSheetRecords to an array and sorts by the position of their BOFs.voidWrite the data content of this BIFF record.voidsetHidden(boolean hidden) Is the sheet hidden? Different from very hiddenvoidsetPositionOfBof(int pos) set the offset in bytes of the Beginning of File Marker within the HSSF Stream part of the POIFS filevoidsetSheetname(String sheetName) Set the sheetname for this sheet.voidsetVeryHidden(boolean veryHidden) Is the sheet very hidden? Different from (normal) hiddentoString()get a string representation of the record (for biffview/debugging)Methods inherited from class org.apache.poi.hssf.record.StandardRecord
getRecordSize, serializeMethods inherited from class org.apache.poi.hssf.record.Record
clone, cloneViaReserialise, serialize
-
Field Details
-
sid
public static final short sid- See Also:
-
-
Constructor Details
-
BoundSheetRecord
-
BoundSheetRecord
UTF8: sid + len + bof + flags + len(str) + unicode + str 2 + 2 + 4 + 2 + 1 + 1 + len(str) UNICODE: sid + len + bof + flags + len(str) + unicode + str 2 + 2 + 4 + 2 + 1 + 1 + 2 * len(str)- Parameters:
in- the record stream to read from
-
-
Method Details
-
setPositionOfBof
public void setPositionOfBof(int pos) set the offset in bytes of the Beginning of File Marker within the HSSF Stream part of the POIFS file- Parameters:
pos- offset in bytes
-
setSheetname
Set the sheetname for this sheet. (this appears in the tabs at the bottom)- Parameters:
sheetName- the name of the sheet- Throws:
IllegalArgumentException- if sheet name will cause excel to crash.- See Also:
-
getPositionOfBof
public int getPositionOfBof()get the offset in bytes of the Beginning of File Marker within the HSSF Stream part of the POIFS file- Returns:
- offset in bytes
-
getSheetname
get the sheetname for this sheet. (this appears in the tabs at the bottom)- Returns:
- sheetname the name of the sheet
-
toString
Description copied from class:Recordget a string representation of the record (for biffview/debugging) -
getDataSize
protected int getDataSize()- Specified by:
getDataSizein classStandardRecord
-
serialize
Description copied from class:StandardRecordWrite 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 consisting of a 'ushort sid' and 'ushort reclength' has already been written by their superclass).- Specified by:
serializein classStandardRecord- Parameters:
out- the output object
-
getSid
public short getSid()Description copied from class:Recordreturn the non static version of the id for this record. -
isHidden
public boolean isHidden()Is the sheet hidden? Different from very hidden- Returns:
trueif hidden
-
setHidden
public void setHidden(boolean hidden) Is the sheet hidden? Different from very hidden- Parameters:
hidden-trueif hidden
-
isVeryHidden
public boolean isVeryHidden()Is the sheet very hidden? Different from (normal) hidden- Returns:
trueif very hidden
-
setVeryHidden
public void setVeryHidden(boolean veryHidden) Is the sheet very hidden? Different from (normal) hidden- Parameters:
veryHidden-trueif very hidden
-
orderByBofPosition
Converts a List ofBoundSheetRecords to an array and sorts by the position of their BOFs.- Parameters:
boundSheetRecords- the boundSheetRecord list to arrayify- Returns:
- the sorted boundSheetRecords
-