@Internal public final class InternalSheet extends java.lang.Object
The structures of the highlevel API use references to this to perform most of their operations. Its probably unwise to use these low level structures directly unless you really know what you're doing. I recommend you read the Microsoft Excel 97 Developer's Kit (Microsoft Press) and the documentation at http://sc.openoffice.org/excelfileformat.pdf before even attempting to use this.
(工作表的低级模型实现(一个工作簿包含许多工作表) 此文件包含从工作表 BOF 开始并以工作表 EOF 结束的低级二进制记录。使用 HSSFSheet 进行高级表示。高级 API 的结构使用对此的引用来执行大部分操作。除非您真的知道自己在做什么,否则直接使用这些低级结构可能是不明智的。我建议您在尝试使用之前阅读 Microsoft Excel 97 Developer's Kit (Microsoft Press) 和 http://sc.openoffice.org/excelfileformat.pdf 上的文档。)InternalWorkbook
,
HSSFSheet
Modifier and Type | Class and Description |
---|---|
static class |
InternalSheet.UnsupportedBOFType |
Modifier and Type | Field and Description |
---|---|
protected boolean |
_isUncalced
Add an UncalcedRecord if not true indicating formulas have not been calculated
(如果不为真,则添加 UncalcedRecord,表示尚未计算公式)
|
protected RowRecordsAggregate |
_rowsAggregate
always present
(永远存在)
|
protected SelectionRecord |
_selection |
static short |
BottomMargin |
protected DefaultColWidthRecord |
defaultcolwidth |
protected DefaultRowHeightRecord |
defaultrowheight |
protected GridsetRecord |
gridset |
static short |
LeftMargin |
static byte |
PANE_LOWER_LEFT |
static byte |
PANE_LOWER_RIGHT |
static byte |
PANE_UPPER_LEFT |
static byte |
PANE_UPPER_RIGHT |
protected PrintGridlinesRecord |
printGridlines |
protected PrintHeadersRecord |
printHeaders |
static short |
RightMargin |
static short |
TopMargin |
protected WindowTwoRecord |
windowTwo |
Modifier and Type | Method and Description |
---|---|
int |
addMergedRegion(int rowFrom, int colFrom, int rowTo, int colTo) |
void |
addRow(RowRecord row)
Adds a row record to the sheet
(向工作表添加行记录)
|
void |
addValueRecord(int row, CellValueRecordInterface col)
Adds a value record to the sheet's contained binary records (i.e.
(将值记录添加到工作表包含的二进制记录(即)
|
int |
aggregateDrawingRecords(DrawingManager2 drawingManager, boolean createIfMissing)
Finds the DrawingRecord for our sheet, and attaches it to the DrawingManager (which knows about the overall DrawingGroup for our workbook).
(为我们的工作表找到 DrawingRecord,并将其附加到 DrawingManager(它知道我们工作簿的整体 DrawingGroup)。)
|
InternalSheet |
cloneSheet()
Clones the low level records of this sheet and returns the new sheet instance.
(克隆此工作表的低级记录并返回新工作表实例。)
|
void |
createFreezePane(int colSplit, int rowSplit, int topRow, int leftmostColumn)
Creates a split (freezepane).
(创建一个拆分(冻结窗格)。)
|
static InternalSheet |
createSheet()
Creates a sheet with all the usual records minus values and the "index" record (not required).
(创建一个包含所有常规记录减去值和“索引”记录(非必需)的工作表。)
|
static InternalSheet |
createSheet(RecordStream rs)
read support (offset used as starting point for search) for low level API.
(低级 API 的读取支持(用作搜索起点的偏移量)。)
|
void |
createSplitPane(int xSplitPos, int ySplitPos, int topRow, int leftmostColumn, int activePane)
Creates a split pane.
(创建一个拆分窗格。)
|
Record |
findFirstRecordBySid(short sid)
Returns the first occurrence of a record matching a particular sid.
(返回匹配特定 sid 的记录的第一次出现。)
|
int |
findFirstRecordLocBySid(short sid)
Finds the first occurrence of a record matching a particular sid and returns it's position.
(查找与特定 sid 匹配的记录的第一次出现并返回它的位置。)
|
short |
getActiveCellCol() |
int |
getActiveCellRow()
Returns the active row
(返回活动行)
|
java.util.Iterator<CellValueRecordInterface> |
getCellValueIterator()
Get all the value records (from LOC).
(获取所有值记录(来自 LOC)。)
|
int |
getColumnOutlineLevel(int columnIndex) |
int |
getColumnWidth(int columnIndex)
get the width of a given column in units of 1/256th of a character width
(以字符宽度的 1/256 为单位获取给定列的宽度)
|
ConditionalFormattingTable |
getConditionalFormattingTable() |
int |
getDefaultColumnWidth()
get the default column width for the sheet (if the columns do not define their own width)
(获取工作表的默认列宽(如果列没有定义自己的宽度))
|
short |
getDefaultRowHeight()
get the default row height for the sheet (if the rows do not define their own height)
(获取工作表的默认行高(如果行没有定义自己的高度))
|
GridsetRecord |
getGridsetRecord()
Gets the gridset record for this sheet.
(获取此工作表的网格集记录。)
|
short |
getLeftCol() |
int |
getMaxColumnIndex() |
CellRangeAddress |
getMergedRegionAt(int index) |
int |
getMinColumnIndex() |
RowRecord |
getNextRow()
get the NEXT RowRecord (from LOC).
(获取 NEXT RowRecord(来自 LOC)。)
|
NoteRecord[] |
getNoteRecords()
Get the
NoteRecord s (related to cell comments) for this sheet
(获取此工作表的 NoteRecords(与单元格注释相关))
|
int |
getNumMergedRegions() |
DataValidityTable |
getOrCreateDataValidityTable() |
PageSettingsBlock |
getPageSettings() |
PaneInformation |
getPaneInformation()
Returns the information regarding the currently configured pane (split or freeze).
(返回有关当前配置的窗格(拆分或冻结)的信息。)
|
PrintGridlinesRecord |
getPrintGridlines()
Returns the PrintGridlinesRecord.
(返回 PrintGridlinesRecord。)
|
PrintHeadersRecord |
getPrintHeaders()
Returns the PrintHeadersRecord.
(返回 PrintHeadersRecord。)
|
WorksheetProtectionBlock |
getProtectionBlock() |
java.util.List<RecordBase> |
getRecords() |
RowRecord |
getRow(int rownum)
get the NEXT (from LOC) RowRecord where rownumber matches the given rownum.
(获取行号与给定行号匹配的下一个(来自 LOC)行记录。)
|
RowRecordsAggregate |
getRowsAggregate() |
SelectionRecord |
getSelection() |
short |
getTopRow() |
boolean |
getUncalced() |
WindowTwoRecord |
getWindowTwo() |
short |
getXFIndexForColAt(short columnIndex)
get the index to the ExtendedFormatRecord "associated" with the column at specified 0-based index.
(获取与指定的基于 0 的索引处的列“关联”的 ExtendedFormatRecord 的索引。)
|
void |
groupColumnRange(int fromColumn, int toColumn, boolean indent)
Creates an outline group for the specified columns.
(为指定的列创建大纲组。)
|
void |
groupRowRange(int fromRow, int toRow, boolean indent) |
boolean |
isColumnHidden(int columnIndex)
Get the hidden property for a given column.
(获取给定列的隐藏属性。)
|
boolean |
isDisplayFormulas()
Returns if formulas are displayed.
(如果显示公式则返回。)
|
boolean |
isDisplayGridlines() |
boolean |
isDisplayRowColHeadings()
Returns if RowColHeadings are displayed.
(如果显示 RowColHeadings,则返回。)
|
boolean |
isGridsPrinted() |
boolean |
isPrintRowColHeadings()
Returns if RowColHeadings are displayed.
(如果显示 RowColHeadings,则返回。)
|
void |
preSerialize()
Perform any work necessary before the sheet is about to be serialized.
(在将要序列化工作表之前执行任何必要的工作。)
|
void |
removeMergedRegion(int index) |
void |
removeRow(RowRecord row)
Removes a row record This method is not loc sensitive, it resets loc to = dimsloc so no worries.
(删除行记录 此方法对 loc 不敏感,它将 loc 重置为 = dimsloc 所以不用担心。)
|
void |
removeValueRecord(int row, CellValueRecordInterface col)
remove a value record from the records array.
(从记录数组中删除一个值记录。)
|
void |
replaceValueRecord(CellValueRecordInterface newval)
replace a value record from the records array.
(替换记录数组中的值记录。)
|
void |
setActiveCellCol(short col)
Sets the active column
(设置活动列)
|
void |
setActiveCellRow(int row)
Sets the active row
(设置活动行)
|
void |
setColumnGroupCollapsed(int columnNumber, boolean collapsed) |
void |
setColumnHidden(int column, boolean hidden)
Get the hidden property for a given column.
(获取给定列的隐藏属性。)
|
void |
setColumnWidth(int column, int width)
set the width for a given column in 1/256th of a character width units
(以字符宽度单位的 1/256 设置给定列的宽度)
|
void |
setDefaultColumnStyle(int column, int styleIndex) |
void |
setDefaultColumnWidth(int dcw)
set the default column width for the sheet (if the columns do not define their own width)
(设置工作表的默认列宽(如果列没有定义自己的宽度))
|
void |
setDefaultRowHeight(short dch)
set the default row height for the sheet (if the rows do not define their own height)
(设置工作表的默认行高(如果行没有定义自己的高度))
|
void |
setDimensions(int firstrow, short firstcol, int lastrow, short lastcol)
Per an earlier reported bug in working with Andy Khan's excel read library.
(根据之前报告的使用 Andy Khan 的 excel 读取库的错误。)
|
void |
setDisplayFormulas(boolean show)
Sets whether the formulas are shown in a viewer.
(设置公式是否显示在查看器中。)
|
void |
setDisplayGridlines(boolean show)
Sets whether the gridlines are shown in a viewer.
(设置是否在查看器中显示网格线。)
|
void |
setDisplayRowColHeadings(boolean show)
Sets whether the RowColHeadings are shown in a viewer.
(设置 RowColHeadings 是否显示在查看器中。)
|
void |
setGridsPrinted(boolean value)
set whether gridlines printed or not.
(设置是否打印网格线。)
|
void |
setLeftCol(short leftCol)
Sets the left column to show in desktop window pane.
(将左列设置为在桌面窗口窗格中显示。)
|
void |
setPrintGridlines(PrintGridlinesRecord newPrintGridlines)
Sets the PrintGridlinesRecord.
(设置 PrintGridlinesRecord。)
|
void |
setPrintHeaders(PrintHeadersRecord newPrintHeaders)
Sets the PrintHeadersRecord.
(设置 PrintHeadersRecord。)
|
void |
setPrintRowColHeadings(boolean show)
Sets whether the RowColHeadings are shown in a viewer.
(设置 RowColHeadings 是否显示在查看器中。)
|
void |
setSCLRecord(SCLRecord sclRecord)
Sets the SCL record or creates it in the correct place if it does not already exist.
(如果 SCL 记录不存在,则设置或在正确的位置创建它。)
|
void |
setSelected(boolean sel)
Sets whether the sheet is selected
(设置是否选中工作表)
|
void |
setSelection(SelectionRecord selection) |
void |
setTopRow(short topRow) |
void |
setUncalced(boolean uncalced) |
void |
updateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex)
Updates formulas in cells and conditional formats due to moving of cells
(由于单元格的移动,更新单元格和条件格式中的公式)
|
void |
visitContainedRecords(RecordAggregate.RecordVisitor rv, int offset) |
public static final short LeftMargin
public static final short RightMargin
public static final short TopMargin
public static final short BottomMargin
protected PrintGridlinesRecord printGridlines
protected PrintHeadersRecord printHeaders
protected GridsetRecord gridset
protected DefaultColWidthRecord defaultcolwidth
protected DefaultRowHeightRecord defaultrowheight
protected WindowTwoRecord windowTwo
protected SelectionRecord _selection
protected final RowRecordsAggregate _rowsAggregate
protected boolean _isUncalced
public static final byte PANE_LOWER_RIGHT
public static final byte PANE_UPPER_RIGHT
public static final byte PANE_LOWER_LEFT
public static final byte PANE_UPPER_LEFT
public static InternalSheet createSheet(RecordStream rs)
rs
- the stream to read records from
(rs - 从中读取记录的流)
InternalWorkbook
,
Record
public InternalSheet cloneSheet()
public static InternalSheet createSheet()
public RowRecordsAggregate getRowsAggregate()
public void updateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex)
shifter
- the formular shifter
(shifter - 公式移位器)
externSheetIndex
- the externSheet index of this sheet
(externSheetIndex - 此工作表的 externSheet 索引)
public int addMergedRegion(int rowFrom, int colFrom, int rowTo, int colTo)
public void removeMergedRegion(int index)
public CellRangeAddress getMergedRegionAt(int index)
public int getNumMergedRegions()
public ConditionalFormattingTable getConditionalFormattingTable()
public void setDimensions(int firstrow, short firstcol, int lastrow, short lastcol)
firstrow
- the first row index
(firstrow - 第一行索引)
firstcol
- the first column index
(firstcol - 第一列索引)
lastrow
- the last row index
(lastrow - 最后一行索引)
lastcol
- the last column index
(lastcol - 最后一列索引)
DimensionsRecord
public void visitContainedRecords(RecordAggregate.RecordVisitor rv, int offset)
public void addValueRecord(int row, CellValueRecordInterface col)
This method is "loc" sensitive. Meaning you need to set LOC to where you want it to start searching. If you don't know do this: setLoc(getDimsLoc). When adding several rows you can just start at the last one by leaving loc at what this sets it to.
(将值记录添加到工作表包含的二进制记录(即 LabelSSTRecord 或 NumberRecord)。这种方法是“loc”敏感的。这意味着您需要将 LOC 设置为您希望它开始搜索的位置。如果你不知道这样做:setLoc(getDimsLoc)。添加多行时,您可以从最后一行开始,将 loc 保留在它设置的位置。)row
- the row to add the cell value to
(row - 要将单元格值添加到的行)
col
- the cell value record itself.
(col - 单元格值记录本身。)
public void removeValueRecord(int row, CellValueRecordInterface col)
row
- - the row of the value record you wish to remove
(row - - 您要删除的值记录的行)
col
- - a record supporting the CellValueRecordInterface.
(col - 支持 CellValueRecordInterface 的记录。)
CellValueRecordInterface
public void replaceValueRecord(CellValueRecordInterface newval)
newval
- - a record supporting the CellValueRecordInterface. this will replace the cell value with the same row and column. If there isn't one, one will be added.
(newval - - 支持 CellValueRecordInterface 的记录。这将用相同的行和列替换单元格值。如果没有,将添加一个。)
public void addRow(RowRecord row)
This method is "loc" sensitive. Meaning you need to set LOC to where you want it to start searching. If you don't know do this: setLoc(getDimsLoc). When adding several rows you can just start at the last one by leaving loc at what this sets it to.
(向工作表添加行记录 此方法对“loc”敏感。这意味着您需要将 LOC 设置为您希望它开始搜索的位置。如果你不知道这样做:setLoc(getDimsLoc)。添加多行时,您可以从最后一行开始,将 loc 保留在它设置的位置。)row
- the row record to be added
(row - 要添加的行记录)
public void removeRow(RowRecord row)
row
- the row record to remove
(row - 要删除的行记录)
public java.util.Iterator<CellValueRecordInterface> getCellValueIterator()
This method is "loc" sensitive. Meaning you need to set LOC to where you want it to start searching. If you don't know do this: setLoc(getDimsLoc). When adding several rows you can just start at the last one by leaving loc at what this sets it to. For this method, set loc to dimsloc to start with, subsequent calls will return values in (physical) sequence or NULL when you get to the end.
(获取所有值记录(来自 LOC)。记录将从作为值记录的第一条记录(从 LOC 开始)返回。这种方法是“loc”敏感的。这意味着您需要将 LOC 设置为您希望它开始搜索的位置。如果你不知道这样做:setLoc(getDimsLoc)。添加多行时,您可以从最后一行开始,将 loc 保留在它设置的位置。对于此方法,将 loc 设置为 dimsloc 以开始,后续调用将在(物理)序列中返回值,或者当您到达末尾时返回 NULL。)public RowRecord getNextRow()
This method is "loc" sensitive. Meaning you need to set LOC to where you want it to start searching. If you don't know do this: setLoc(getDimsLoc). When adding several rows you can just start at the last one by leaving loc at what this sets it to. For this method, set loc to dimsloc to start with. subsequent calls will return rows in (physical) sequence or NULL when you get to the end.
(获取 NEXT RowRecord(来自 LOC)。将返回作为 Row 记录的第一条记录(从 LOC 开始)。这种方法是“loc”敏感的。这意味着您需要将 LOC 设置为您希望它开始搜索的位置。如果你不知道这样做:setLoc(getDimsLoc)。添加多行时,您可以从最后一行开始,将 loc 保留在它设置的位置。对于此方法,将 loc 设置为 dimsloc 以开始。后续调用将返回(物理)序列中的行,或者当您到达末尾时返回 NULL。)public RowRecord getRow(int rownum)
This method is "loc" sensitive. Meaning you need to set LOC to where you want it to start searching. If you don't know do this: setLoc(getDimsLoc). When adding several rows you can just start at the last one by leaving loc at what this sets it to. For this method, set loc to dimsloc to start with. subsequent calls will return rows in (physical) sequence or NULL when you get to the end.
(获取行号与给定行号匹配的下一个(来自 LOC)行记录。将返回与给定 rownum 具有相同 rownum 的 Row 记录(从 LOC 开始)的第一条记录。这种方法是“loc”敏感的。这意味着您需要将 LOC 设置为您希望它开始搜索的位置。如果你不知道这样做:setLoc(getDimsLoc)。添加多行时,您可以从最后一行开始,将 loc 保留在它设置的位置。对于此方法,将 loc 设置为 dimsloc 以开始。后续调用将返回(物理)序列中的行,或者当您到达末尾时返回 NULL。)rownum
- which row to return (careful with LOC)
(rownum - 返回哪一行(小心 LOC))
public int getDefaultColumnWidth()
public boolean isGridsPrinted()
true
if gridlines are printed
(如果打印了网格线,则为 true)
public void setGridsPrinted(boolean value)
value
- True if gridlines printed.
(value - 如果打印了网格线,则为真。)
public void setDefaultColumnWidth(int dcw)
dcw
- default column width
(dcw - 默认列宽)
public void setDefaultRowHeight(short dch)
dch
- the default row height
(dch - 默认行高)
public short getDefaultRowHeight()
public int getColumnWidth(int columnIndex)
columnIndex
- index
(columnIndex - 索引)
DefaultColWidthRecord
,
ColumnInfoRecord
,
setColumnWidth(int, int)
public short getXFIndexForColAt(short columnIndex)
Returns the index to the default ExtendedFormatRecord (0xF) if no ColumnInfoRecord exists that includes the column index specified.
(获取与指定的基于 0 的索引处的列“关联”的 ExtendedFormatRecord 的索引。 (在这种情况下,ExtendedFormatRecord 索引实际上与跨越 1 列或更多列的 ColumnInfoRecord 相关联)如果不存在包含指定列索引的 ColumnInfoRecord,则将索引返回到默认的 ExtendedFormatRecord (0xF)。)columnIndex
- the column index
(columnIndex - 列索引)
public void setColumnWidth(int column, int width)
column
- - the column number
(column - - 列号)
width
- (in units of 1/256th of a character width)
(宽度 - (以字符宽度的 1/256 为单位))
public boolean isColumnHidden(int columnIndex)
columnIndex
- column index
(columnIndex - 列索引)
DefaultColWidthRecord
,
ColumnInfoRecord
,
setColumnHidden(int, boolean)
public void setColumnHidden(int column, boolean hidden)
column
- - the column number
(column - - 列号)
hidden
- - whether the column is hidden or not
(hidden - - 列是否隐藏)
public void setDefaultColumnStyle(int column, int styleIndex)
public void groupColumnRange(int fromColumn, int toColumn, boolean indent)
fromColumn
- group from this column (inclusive)
(fromColumn - 此列中的组(包括))
toColumn
- group to this column (inclusive)
(toColumn - 分组到该列(包括))
indent
- if true the group will be indented by one level, if false indenting will be removed by one level.
(indent - 如果为 true,则该组将缩进一级,如果为 false,则将缩进一级。)
public short getTopRow()
public void setTopRow(short topRow)
public void setLeftCol(short leftCol)
leftCol
- the left column to show in desktop window pane
(leftCol - 要在桌面窗口窗格中显示的左列)
public short getLeftCol()
public int getActiveCellRow()
SelectionRecord
public void setActiveCellRow(int row)
row
- the row index
(row - 行索引)
SelectionRecord
public short getActiveCellCol()
SelectionRecord
public void setActiveCellCol(short col)
col
- the column index
(col - 列索引)
SelectionRecord
public java.util.List<RecordBase> getRecords()
public GridsetRecord getGridsetRecord()
public Record findFirstRecordBySid(short sid)
sid
- the sid to search for
(sid - 要搜索的 sid)
null
if it wasn't found
(匹配的记录,如果没有找到则为 null)
public void setSCLRecord(SCLRecord sclRecord)
sclRecord
- The record to set.
(sclRecord - 要设置的记录。)
public int findFirstRecordLocBySid(short sid)
sid
- the sid to search for
(sid - 要搜索的 sid)
public WindowTwoRecord getWindowTwo()
public PrintGridlinesRecord getPrintGridlines()
public void setPrintGridlines(PrintGridlinesRecord newPrintGridlines)
newPrintGridlines
- The new PrintGridlinesRecord for the sheet.
(newPrintGridlines - 工作表的新 PrintGridlinesRecord。)
public PrintHeadersRecord getPrintHeaders()
public void setPrintHeaders(PrintHeadersRecord newPrintHeaders)
newPrintHeaders
- The new PrintHeadersRecord for the sheet.
(newPrintHeaders - 工作表的新 PrintHeadersRecord。)
public void setSelected(boolean sel)
sel
- True to select the sheet, false otherwise.
(sel - 选择工作表为真,否则为假。)
public void createFreezePane(int colSplit, int rowSplit, int topRow, int leftmostColumn)
If both colSplit and rowSplit are zero then the existing freeze pane is removed
(创建一个拆分(冻结窗格)。任何现有的冻结窗格或拆分窗格都会被覆盖。如果 colSplit 和 rowSplit 都为零,则删除现有的冻结窗格)colSplit
- Horizonatal position of split.
(colSplit - 分割的水平位置。)
rowSplit
- Vertical position of split.
(rowSplit - 拆分的垂直位置。)
topRow
- Top row visible in bottom pane
(topRow - 在底部窗格中可见的顶行)
leftmostColumn
- Left column visible in right pane.
(leftmostColumn - 在右窗格中可见的左列。)
public void createSplitPane(int xSplitPos, int ySplitPos, int topRow, int leftmostColumn, int activePane)
xSplitPos
- Horizonatal position of split (in 1/20th of a point).
(xSplitPos - 分割的水平位置(点的 1/20)。)
ySplitPos
- Vertical position of split (in 1/20th of a point).
(ySplitPos - 分割的垂直位置(点的 1/20)。)
topRow
- Top row visible in bottom pane
(topRow - 在底部窗格中可见的顶行)
leftmostColumn
- Left column visible in right pane.
(leftmostColumn - 在右窗格中可见的左列。)
activePane
- Active pane. One of: PANE_LOWER_RIGHT, PANE_UPPER_RIGHT, PANE_LOWER_LEFT, PANE_UPPER_LEFT
(activePane - 活动窗格。以下之一:PANE_LOWER_RIGHT、PANE_UPPER_RIGHT、PANE_LOWER_LEFT、PANE_UPPER_LEFT)
PANE_LOWER_LEFT
,
PANE_LOWER_RIGHT
,
PANE_UPPER_LEFT
,
PANE_UPPER_RIGHT
public PaneInformation getPaneInformation()
null
if no pane configured, or the pane information.
(如果未配置窗格或窗格信息,则为 null。)
public SelectionRecord getSelection()
public void setSelection(SelectionRecord selection)
public WorksheetProtectionBlock getProtectionBlock()
WorksheetProtectionBlock
for this sheet
(此工作表的 WorksheetProtectionBlock)
public void setDisplayGridlines(boolean show)
show
- whether to show gridlines or not
(show - 是否显示网格线)
public boolean isDisplayGridlines()
true
if gridlines are displayed
(如果显示网格线,则为 true)
public void setDisplayFormulas(boolean show)
show
- whether to show formulas or not
(show - 是否显示公式)
public boolean isDisplayFormulas()
public void setDisplayRowColHeadings(boolean show)
show
- whether to show RowColHeadings or not
(show - 是否显示 RowColHeadings)
public boolean isDisplayRowColHeadings()
public void setPrintRowColHeadings(boolean show)
show
- whether to show RowColHeadings or not
(show - 是否显示 RowColHeadings)
public boolean isPrintRowColHeadings()
public boolean getUncalced()
public void setUncalced(boolean uncalced)
uncalced
- whether an uncalced record must be inserted or not at generation
(uncalced - 在生成时是否必须插入未计算的记录)
public int aggregateDrawingRecords(DrawingManager2 drawingManager, boolean createIfMissing)
drawingManager
- The DrawingManager2 for our workbook
(drawingManager - 我们工作簿的 DrawingManager2)
createIfMissing
- Should one be created if missing?
(createIfMissing - 如果丢失,是否应该创建一个?)
public void preSerialize()
public PageSettingsBlock getPageSettings()
public void setColumnGroupCollapsed(int columnNumber, boolean collapsed)
public void groupRowRange(int fromRow, int toRow, boolean indent)
public DataValidityTable getOrCreateDataValidityTable()
public NoteRecord[] getNoteRecords()
NoteRecord
s (related to cell comments) for this sheet
(获取此工作表的 NoteRecords(与单元格注释相关))
null
, typically empty array
(从不为空,通常为空数组)
public int getColumnOutlineLevel(int columnIndex)
public int getMinColumnIndex()
public int getMaxColumnIndex()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.