StreamingSheet (excel-streaming-reader 3.5.0 API)

java.lang.Object
- com.github.pjfanning.xlsx.impl.StreamingSheet

All Implemented Interfaces:

java.lang.Iterable<org.apache.poi.ss.usermodel.Row>, org.apache.poi.ss.usermodel.Sheet
```
public class StreamingSheet
extends java.lang.Object
implements org.apache.poi.ss.usermodel.Sheet
```

Field Summary
- Fields inherited from interface org.apache.poi.ss.usermodel.Sheet
  BottomMargin, FooterMargin, HeaderMargin, LeftMargin, PANE_LOWER_LEFT, PANE_LOWER_RIGHT, PANE_UPPER_LEFT, PANE_UPPER_RIGHT, RightMargin, TopMargin

Constructor Summary

Constructors
Constructor and Description

StreamingSheet(java.lang.String name, StreamingSheetReader reader)

Constructors
Constructor and Description
`StreamingSheet(java.lang.String name, StreamingSheetReader reader)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int`	`addMergedRegion(org.apache.poi.ss.util.CellRangeAddress region)` Update operations are not supported
`int`	`addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)` Update operations are not supported
`void`	`addSharedFormula(java.lang.String siValue, SharedFormula sharedFormula)`
`void`	`addValidationData(org.apache.poi.ss.usermodel.DataValidation dataValidation)` Not supported
`void`	`autoSizeColumn(int column)` Update operations are not supported
`void`	`autoSizeColumn(int column, boolean useMergedCells)` Update operations are not supported
`org.apache.poi.ss.usermodel.Drawing`	`createDrawingPatriarch()` Not supported
`void`	`createFreezePane(int colSplit, int rowSplit)` Not supported
`void`	`createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)` Not supported
`org.apache.poi.ss.usermodel.Row`	`createRow(int rownum)` Update operations are not supported
`void`	`createSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, int activePane)` Not supported
`org.apache.poi.ss.util.CellAddress`	`getActiveCell()`
`boolean`	`getAutobreaks()` Not supported
`org.apache.poi.ss.usermodel.Comment`	`getCellComment(org.apache.poi.ss.util.CellAddress cellAddress)` Return cell comment at row, column, if one exists.
`java.util.Map<org.apache.poi.ss.util.CellAddress,? extends org.apache.poi.ss.usermodel.Comment>`	`getCellComments()` Returns all cell comments on this sheet.
`int[]`	`getColumnBreaks()` Not supported
`int`	`getColumnOutlineLevel(int columnIndex)` Not supported
`org.apache.poi.ss.usermodel.CellStyle`	`getColumnStyle(int column)` Not supported
`int`	`getColumnWidth(int columnIndex)` Not supported
`float`	`getColumnWidthInPixels(int columnIndex)` Not supported
`org.apache.poi.ss.usermodel.DataValidationHelper`	`getDataValidationHelper()` Not supported
`java.util.List<? extends org.apache.poi.ss.usermodel.DataValidation>`	`getDataValidations()` Not supported
`int`	`getDefaultColumnWidth()` Not supported
`short`	`getDefaultRowHeight()` Not supported
`float`	`getDefaultRowHeightInPoints()` Not supported
`boolean`	`getDisplayGuts()` Not supported
`org.apache.poi.ss.usermodel.Drawing`	`getDrawingPatriarch()` Return the sheet's existing drawing, or null if there isn't yet one.
`int`	`getFirstRowNum()` Gets the first row on the sheet.
`boolean`	`getFitToPage()` Not supported
`org.apache.poi.ss.usermodel.Footer`	`getFooter()` Not supported
`boolean`	`getForceFormulaRecalculation()` Not supported
`org.apache.poi.ss.usermodel.Header`	`getHeader()` Not supported
`boolean`	`getHorizontallyCenter()` Not supported
`org.apache.poi.ss.usermodel.Hyperlink`	`getHyperlink(org.apache.poi.ss.util.CellAddress cellAddress)` Get hyperlink associated with cell (only if feature is enabled on the Builder).
`org.apache.poi.ss.usermodel.Hyperlink`	`getHyperlink(int row, int column)` Get a Hyperlink in this sheet anchored at row, column (only if feature is enabled on the Builder).
`java.util.List<? extends org.apache.poi.ss.usermodel.Hyperlink>`	`getHyperlinkList()` Get hyperlinks associated with sheet (only if feature is enabled on the Builder).
`int`	`getLastRowNum()` Gets the last row on the sheet.
`short`	`getLeftCol()` Not supported
`double`	`getMargin(short margin)` Not supported
`org.apache.poi.ss.util.CellRangeAddress`	`getMergedRegion(int index)` Only works after sheet is fully read (because merged regions data is stored at the end of the sheet XML).
`java.util.List<org.apache.poi.ss.util.CellRangeAddress>`	`getMergedRegions()` Only works after sheet is fully read (because merged regions data is stored at the end of the sheet XML).
`int`	`getNumMergedRegions()` Only works after sheet is fully read (because merged regions data is stored at the end of the sheet XML).
`org.apache.poi.ss.util.PaneInformation`	`getPaneInformation()` Not supported
`int`	`getPhysicalNumberOfRows()` Not supported - use `iterator()` or `rowIterator()` to iterate over rows and count the rows
`org.apache.poi.ss.usermodel.PrintSetup`	`getPrintSetup()` Not supported
`boolean`	`getProtect()` Not supported
`org.apache.poi.ss.util.CellRangeAddress`	`getRepeatingColumns()` Not supported
`org.apache.poi.ss.util.CellRangeAddress`	`getRepeatingRows()` Not supported
`org.apache.poi.ss.usermodel.Row`	`getRow(int rownum)` Not supported - use `iterator()` or `rowIterator()` instead
`int[]`	`getRowBreaks()` Not supported
`boolean`	`getRowSumsBelow()` Not supported
`boolean`	`getRowSumsRight()` Not supported
`boolean`	`getScenarioProtect()` Not supported
`java.util.Map<java.lang.String,SharedFormula>`	`getSharedFormulaMap()`
`org.apache.poi.ss.usermodel.SheetConditionalFormatting`	`getSheetConditionalFormatting()` Not supported
`java.lang.String`	`getSheetName()`
`short`	`getTopRow()` Not supported
`boolean`	`getVerticallyCenter()` Not supported
`org.apache.poi.ss.usermodel.Workbook`	`getWorkbook()` Workbook is only set under certain usage flows.
`void`	`groupColumn(int fromColumn, int toColumn)` Update operations are not supported
`void`	`groupRow(int fromRow, int toRow)` Update operations are not supported
`boolean`	`isColumnBroken(int column)` Not supported
`boolean`	`isColumnHidden(int columnIndex)` Get the hidden state for a given column
`boolean`	`isDisplayFormulas()` Not supported
`boolean`	`isDisplayGridlines()` Not supported
`boolean`	`isDisplayRowColHeadings()` Not supported
`boolean`	`isDisplayZeros()` Not supported
`boolean`	`isPrintGridlines()` Not supported
`boolean`	`isPrintRowAndColumnHeadings()` Not supported
`boolean`	`isRightToLeft()` Not supported
`boolean`	`isRowBroken(int row)` Not supported
`boolean`	`isSelected()` Not supported
`java.util.Iterator<org.apache.poi.ss.usermodel.Row>`	`iterator()`
`void`	`protectSheet(java.lang.String password)` Not supported
`org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell>`	`removeArrayFormula(org.apache.poi.ss.usermodel.Cell cell)` Update operations are not supported
`void`	`removeColumnBreak(int column)` Update operations are not supported
`void`	`removeMergedRegion(int index)` Update operations are not supported
`void`	`removeMergedRegions(java.util.Collection<java.lang.Integer> collection)` Update operations are not supported
`void`	`removeRow(org.apache.poi.ss.usermodel.Row row)` Update operations are not supported
`void`	`removeRowBreak(int row)` Update operations are not supported
`SharedFormula`	`removeSharedFormula(java.lang.String siValue)`
`java.util.Iterator<org.apache.poi.ss.usermodel.Row>`	`rowIterator()`
`void`	`setActiveCell(org.apache.poi.ss.util.CellAddress cellAddress)` Not supported
`org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell>`	`setArrayFormula(java.lang.String formula, org.apache.poi.ss.util.CellRangeAddress range)` Update operations are not supported
`void`	`setAutobreaks(boolean value)` Update operations are not supported
`org.apache.poi.ss.usermodel.AutoFilter`	`setAutoFilter(org.apache.poi.ss.util.CellRangeAddress range)` Update operations are not supported
`void`	`setColumnBreak(int column)` Update operations are not supported
`void`	`setColumnGroupCollapsed(int columnNumber, boolean collapsed)` Update operations are not supported
`void`	`setColumnHidden(int columnIndex, boolean hidden)` Update operations are not supported
`void`	`setColumnWidth(int columnIndex, int width)` Update operations are not supported
`void`	`setDefaultColumnStyle(int column, org.apache.poi.ss.usermodel.CellStyle style)` Update operations are not supported
`void`	`setDefaultColumnWidth(int width)` Update operations are not supported
`void`	`setDefaultRowHeight(short height)` Update operations are not supported
`void`	`setDefaultRowHeightInPoints(float height)` Update operations are not supported
`void`	`setDisplayFormulas(boolean show)` Update operations are not supported
`void`	`setDisplayGridlines(boolean show)` Update operations are not supported
`void`	`setDisplayGuts(boolean value)` Update operations are not supported
`void`	`setDisplayRowColHeadings(boolean show)` Update operations are not supported
`void`	`setDisplayZeros(boolean value)` Update operations are not supported
`void`	`setFitToPage(boolean value)` Update operations are not supported
`void`	`setForceFormulaRecalculation(boolean value)` Update operations are not supported
`void`	`setHorizontallyCenter(boolean value)` Update operations are not supported
`void`	`setMargin(short margin, double size)` Update operations are not supported
`void`	`setPrintGridlines(boolean show)` Not supported
`void`	`setPrintRowAndColumnHeadings(boolean b)` Update operations are not supported
`void`	`setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress columnRangeRef)` Update operations are not supported
`void`	`setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress rowRangeRef)` Update operations are not supported
`void`	`setRightToLeft(boolean value)` Update operations are not supported
`void`	`setRowBreak(int row)` Update operations are not supported
`void`	`setRowGroupCollapsed(int row, boolean collapse)` Update operations are not supported
`void`	`setRowSumsBelow(boolean value)` Update operations are not supported
`void`	`setRowSumsRight(boolean value)` Update operations are not supported
`void`	`setSelected(boolean value)` Update operations are not supported
`void`	`setVerticallyCenter(boolean value)` Update operations are not supported
`void`	`setZoom(int i)` Update operations are not supported
`void`	`shiftColumns(int startColumn, int endColumn, int n)` Update operations are not supported
`void`	`shiftRows(int startRow, int endRow, int n)` Update operations are not supported
`void`	`shiftRows(int startRow, int endRow, int n, boolean copyRowHeight, boolean resetOriginalRowHeight)` Update operations are not supported
`void`	`showInPane(int toprow, int leftcol)` Not supported
`java.util.Spliterator<org.apache.poi.ss.usermodel.Row>`	`spliterator()`
`void`	`ungroupColumn(int fromColumn, int toColumn)` Update operations are not supported
`void`	`ungroupRow(int fromRow, int toRow)` Update operations are not supported
`void`	`validateMergedRegions()` Not supported

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.lang.Iterable
forEach

- Constructor Detail
  - StreamingSheet
```
public StreamingSheet(java.lang.String name,
                      StreamingSheetReader reader)
```
- Method Detail
  - getWorkbook
```
public org.apache.poi.ss.usermodel.Workbook getWorkbook()
```
    Workbook is only set under certain usage flows.
    
    Specified by:
    
    getWorkbook in interface org.apache.poi.ss.usermodel.Sheet
  - iterator
```
public java.util.Iterator<org.apache.poi.ss.usermodel.Row> iterator()
```
    Specified by:
    
    iterator in interface java.lang.Iterable<org.apache.poi.ss.usermodel.Row>
    
    Specified by:
    
    iterator in interface org.apache.poi.ss.usermodel.Sheet
  - rowIterator
```
public java.util.Iterator<org.apache.poi.ss.usermodel.Row> rowIterator()
```
    Specified by:
    
    rowIterator in interface org.apache.poi.ss.usermodel.Sheet
  - spliterator
```
public java.util.Spliterator<org.apache.poi.ss.usermodel.Row> spliterator()
```
    Specified by:
    
    spliterator in interface java.lang.Iterable<org.apache.poi.ss.usermodel.Row>
    
    Specified by:
    
    spliterator in interface org.apache.poi.ss.usermodel.Sheet
  - getSheetName
```
public java.lang.String getSheetName()
```
    Specified by:
    
    getSheetName in interface org.apache.poi.ss.usermodel.Sheet
  - isColumnHidden
```
public boolean isColumnHidden(int columnIndex)
```
    Get the hidden state for a given column
    
    Specified by:
    
    isColumnHidden in interface org.apache.poi.ss.usermodel.Sheet
    
    Parameters:
    
    columnIndex - - the column to set (0-based)
    
    Returns:
    
    hidden - false if the column is visible
  - getFirstRowNum
```
public int getFirstRowNum()
```
    Gets the first row on the sheet. This value is only available on some sheets where the sheet XML has the dimension data set. At present, this method will return 0 if this dimension data is missing (this may change in a future release).
    
    Specified by:
    
    getFirstRowNum in interface org.apache.poi.ss.usermodel.Sheet
    
    Returns:
    
    first row contained in this sheet (0-based)
  - getLastRowNum
```
public int getLastRowNum()
```
    Gets the last row on the sheet. This value is only available on some sheets where the sheet XML has the dimension data set. At present, this method will return 0 if this dimension data is missing (this may change in a future release).
    
    Specified by:
    
    getLastRowNum in interface org.apache.poi.ss.usermodel.Sheet
    
    Returns:
    
    last row contained in this sheet (0-based)
  - getCellComment
```
public org.apache.poi.ss.usermodel.Comment getCellComment(org.apache.poi.ss.util.CellAddress cellAddress)
```
    Return cell comment at row, column, if one exists. Otherwise, return null.
    
    Specified by:
    
    getCellComment in interface org.apache.poi.ss.usermodel.Sheet
    
    Parameters:
    
    cellAddress - the location of the cell comment
    
    Returns:
    
    the cell comment, if one exists. Otherwise, return null.
    
    Throws:
    
    java.lang.IllegalStateException - if StreamingReader.Builder.setReadComments(boolean) is not set to true
  - getCellComments
```
public java.util.Map<org.apache.poi.ss.util.CellAddress,? extends org.apache.poi.ss.usermodel.Comment> getCellComments()
```
    Returns all cell comments on this sheet.
    
    Specified by:
    
    getCellComments in interface org.apache.poi.ss.usermodel.Sheet
    
    Returns:
    
    A map of each Comment in the sheet, keyed on the cell address where the comment is located.
    
    Throws:
    
    java.lang.IllegalStateException - if StreamingReader.Builder.setReadComments(boolean) is not set to true
  - getMergedRegion
```
public org.apache.poi.ss.util.CellRangeAddress getMergedRegion(int index)
```
    Only works after sheet is fully read (because merged regions data is stored at the end of the sheet XML).
    
    Specified by:
    
    getMergedRegion in interface org.apache.poi.ss.usermodel.Sheet
  - getMergedRegions
```
public java.util.List<org.apache.poi.ss.util.CellRangeAddress> getMergedRegions()
```
    Only works after sheet is fully read (because merged regions data is stored at the end of the sheet XML).
    
    Specified by:
    
    getMergedRegions in interface org.apache.poi.ss.usermodel.Sheet
  - getNumMergedRegions
```
public int getNumMergedRegions()
```
    Only works after sheet is fully read (because merged regions data is stored at the end of the sheet XML).
    
    Specified by:
    
    getNumMergedRegions in interface org.apache.poi.ss.usermodel.Sheet
  - getDrawingPatriarch
```
public org.apache.poi.ss.usermodel.Drawing getDrawingPatriarch()
```
    Return the sheet's existing drawing, or null if there isn't yet one.
    
    Specified by:
    
    getDrawingPatriarch in interface org.apache.poi.ss.usermodel.Sheet
    
    Returns:
    
    a SpreadsheetML drawing
    
    Throws:
    
    java.lang.IllegalStateException - if StreamingReader.Builder.setReadShapes(boolean) is not set to true
  - getHyperlink
```
public org.apache.poi.ss.usermodel.Hyperlink getHyperlink(int row,
                                                          int column)
```
    Get a Hyperlink in this sheet anchored at row, column (only if feature is enabled on the Builder).
    
    Specified by:
    
    getHyperlink in interface org.apache.poi.ss.usermodel.Sheet
    
    Parameters:
    
    row - The row where the hyperlink is anchored
    
    column - The column where the hyperlink is anchored
    
    Returns:
    
    hyperlink if there is a hyperlink anchored at row, column; otherwise returns null
    
    Throws:
    
    java.lang.IllegalStateException - if StreamingReader.Builder.setReadHyperlinks(boolean) is not set to true
  - getHyperlink
```
public org.apache.poi.ss.usermodel.Hyperlink getHyperlink(org.apache.poi.ss.util.CellAddress cellAddress)
```
    Get hyperlink associated with cell (only if feature is enabled on the Builder). This should only be called after all the rows are read because the hyperlink data is at the end of the sheet.
    
    Specified by:
    
    getHyperlink in interface org.apache.poi.ss.usermodel.Sheet
    
    Parameters:
    
    cellAddress -
    
    Returns:
    
    the hyperlink associated with this cell (only if feature is enabled on the Builder) - null if not found
    
    Throws:
    
    java.lang.IllegalStateException - if StreamingReader.Builder.setReadHyperlinks(boolean) is not set to true
  - getHyperlinkList
```
public java.util.List<? extends org.apache.poi.ss.usermodel.Hyperlink> getHyperlinkList()
```
    Get hyperlinks associated with sheet (only if feature is enabled on the Builder). This should only be called after all the rows are read because the hyperlink data is at the end of the sheet.
    
    Specified by:
    
    getHyperlinkList in interface org.apache.poi.ss.usermodel.Sheet
    
    Returns:
    
    the hyperlinks associated with this sheet (only if feature is enabled on the Builder) - cast to XlsxHyperlink to access cell reference
    
    Throws:
    
    java.lang.IllegalStateException - if StreamingReader.Builder.setReadHyperlinks(boolean) is not set to true
  - getActiveCell
```
public org.apache.poi.ss.util.CellAddress getActiveCell()
```
    Specified by:
    
    getActiveCell in interface org.apache.poi.ss.usermodel.Sheet
  - getSharedFormulaMap
```
public java.util.Map<java.lang.String,SharedFormula> getSharedFormulaMap()
```
    Returns:
    
    immutable copy of the shared formula map for this sheet
  - addSharedFormula
```
public void addSharedFormula(java.lang.String siValue,
                             SharedFormula sharedFormula)
```
    Parameters:
    
    siValue - the ID for the shared formula (appears in Excel sheet XML as an si attribute
    
    sharedFormula - maps the base cell and formula for the shared formula
  - removeSharedFormula
```
public SharedFormula removeSharedFormula(java.lang.String siValue)
```
    Parameters:
    
    siValue - the ID for the shared formula (appears in Excel sheet XML as an si attribute
    
    Returns:
    
    the shared formula that was removed (can be null if no existing shared formula is found)
  - createRow
```
public org.apache.poi.ss.usermodel.Row createRow(int rownum)
```
    Update operations are not supported
    
    Specified by:
    
    createRow in interface org.apache.poi.ss.usermodel.Sheet
  - removeRow
```
public void removeRow(org.apache.poi.ss.usermodel.Row row)
```
    Update operations are not supported
    
    Specified by:
    
    removeRow in interface org.apache.poi.ss.usermodel.Sheet
  - getRow
```
public org.apache.poi.ss.usermodel.Row getRow(int rownum)
```
    Not supported - use iterator() or rowIterator() instead
    
    Specified by:
    
    getRow in interface org.apache.poi.ss.usermodel.Sheet
  - getPhysicalNumberOfRows
```
public int getPhysicalNumberOfRows()
```
    Not supported - use iterator() or rowIterator() to iterate over rows and count the rows
    
    Specified by:
    
    getPhysicalNumberOfRows in interface org.apache.poi.ss.usermodel.Sheet
  - setColumnHidden
```
public void setColumnHidden(int columnIndex,
                            boolean hidden)
```
    Update operations are not supported
    
    Specified by:
    
    setColumnHidden in interface org.apache.poi.ss.usermodel.Sheet
  - setRightToLeft
```
public void setRightToLeft(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setRightToLeft in interface org.apache.poi.ss.usermodel.Sheet
  - isRightToLeft
```
public boolean isRightToLeft()
```
    Not supported
    
    Specified by:
    
    isRightToLeft in interface org.apache.poi.ss.usermodel.Sheet
  - setColumnWidth
```
public void setColumnWidth(int columnIndex,
                           int width)
```
    Update operations are not supported
    
    Specified by:
    
    setColumnWidth in interface org.apache.poi.ss.usermodel.Sheet
  - getColumnWidth
```
public int getColumnWidth(int columnIndex)
```
    Not supported
    
    Specified by:
    
    getColumnWidth in interface org.apache.poi.ss.usermodel.Sheet
  - getColumnWidthInPixels
```
public float getColumnWidthInPixels(int columnIndex)
```
    Not supported
    
    Specified by:
    
    getColumnWidthInPixels in interface org.apache.poi.ss.usermodel.Sheet
  - setDefaultColumnWidth
```
public void setDefaultColumnWidth(int width)
```
    Update operations are not supported
    
    Specified by:
    
    setDefaultColumnWidth in interface org.apache.poi.ss.usermodel.Sheet
  - getDefaultColumnWidth
```
public int getDefaultColumnWidth()
```
    Not supported
    
    Specified by:
    
    getDefaultColumnWidth in interface org.apache.poi.ss.usermodel.Sheet
  - getDefaultRowHeight
```
public short getDefaultRowHeight()
```
    Not supported
    
    Specified by:
    
    getDefaultRowHeight in interface org.apache.poi.ss.usermodel.Sheet
  - getDefaultRowHeightInPoints
```
public float getDefaultRowHeightInPoints()
```
    Not supported
    
    Specified by:
    
    getDefaultRowHeightInPoints in interface org.apache.poi.ss.usermodel.Sheet
  - setDefaultRowHeight
```
public void setDefaultRowHeight(short height)
```
    Update operations are not supported
    
    Specified by:
    
    setDefaultRowHeight in interface org.apache.poi.ss.usermodel.Sheet
  - setDefaultRowHeightInPoints
```
public void setDefaultRowHeightInPoints(float height)
```
    Update operations are not supported
    
    Specified by:
    
    setDefaultRowHeightInPoints in interface org.apache.poi.ss.usermodel.Sheet
  - getColumnStyle
```
public org.apache.poi.ss.usermodel.CellStyle getColumnStyle(int column)
```
    Not supported
    
    Specified by:
    
    getColumnStyle in interface org.apache.poi.ss.usermodel.Sheet
  - addMergedRegion
```
public int addMergedRegion(org.apache.poi.ss.util.CellRangeAddress region)
```
    Update operations are not supported
    
    Specified by:
    
    addMergedRegion in interface org.apache.poi.ss.usermodel.Sheet
  - addMergedRegionUnsafe
```
public int addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
```
    Update operations are not supported
    
    Specified by:
    
    addMergedRegionUnsafe in interface org.apache.poi.ss.usermodel.Sheet
  - validateMergedRegions
```
public void validateMergedRegions()
```
    Not supported
    
    Specified by:
    
    validateMergedRegions in interface org.apache.poi.ss.usermodel.Sheet
  - setVerticallyCenter
```
public void setVerticallyCenter(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setVerticallyCenter in interface org.apache.poi.ss.usermodel.Sheet
  - setHorizontallyCenter
```
public void setHorizontallyCenter(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setHorizontallyCenter in interface org.apache.poi.ss.usermodel.Sheet
  - getHorizontallyCenter
```
public boolean getHorizontallyCenter()
```
    Not supported
    
    Specified by:
    
    getHorizontallyCenter in interface org.apache.poi.ss.usermodel.Sheet
  - getVerticallyCenter
```
public boolean getVerticallyCenter()
```
    Not supported
    
    Specified by:
    
    getVerticallyCenter in interface org.apache.poi.ss.usermodel.Sheet
  - removeMergedRegion
```
public void removeMergedRegion(int index)
```
    Update operations are not supported
    
    Specified by:
    
    removeMergedRegion in interface org.apache.poi.ss.usermodel.Sheet
  - removeMergedRegions
```
public void removeMergedRegions(java.util.Collection<java.lang.Integer> collection)
```
    Update operations are not supported
    
    Specified by:
    
    removeMergedRegions in interface org.apache.poi.ss.usermodel.Sheet
  - setForceFormulaRecalculation
```
public void setForceFormulaRecalculation(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Sheet
  - getForceFormulaRecalculation
```
public boolean getForceFormulaRecalculation()
```
    Not supported
    
    Specified by:
    
    getForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Sheet
  - setAutobreaks
```
public void setAutobreaks(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setAutobreaks in interface org.apache.poi.ss.usermodel.Sheet
  - setDisplayGuts
```
public void setDisplayGuts(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setDisplayGuts in interface org.apache.poi.ss.usermodel.Sheet
  - setDisplayZeros
```
public void setDisplayZeros(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setDisplayZeros in interface org.apache.poi.ss.usermodel.Sheet
  - isDisplayZeros
```
public boolean isDisplayZeros()
```
    Not supported
    
    Specified by:
    
    isDisplayZeros in interface org.apache.poi.ss.usermodel.Sheet
  - setFitToPage
```
public void setFitToPage(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setFitToPage in interface org.apache.poi.ss.usermodel.Sheet
  - setRowSumsBelow
```
public void setRowSumsBelow(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setRowSumsBelow in interface org.apache.poi.ss.usermodel.Sheet
  - setRowSumsRight
```
public void setRowSumsRight(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setRowSumsRight in interface org.apache.poi.ss.usermodel.Sheet
  - getAutobreaks
```
public boolean getAutobreaks()
```
    Not supported
    
    Specified by:
    
    getAutobreaks in interface org.apache.poi.ss.usermodel.Sheet
  - getDisplayGuts
```
public boolean getDisplayGuts()
```
    Not supported
    
    Specified by:
    
    getDisplayGuts in interface org.apache.poi.ss.usermodel.Sheet
  - getFitToPage
```
public boolean getFitToPage()
```
    Not supported
    
    Specified by:
    
    getFitToPage in interface org.apache.poi.ss.usermodel.Sheet
  - getRowSumsBelow
```
public boolean getRowSumsBelow()
```
    Not supported
    
    Specified by:
    
    getRowSumsBelow in interface org.apache.poi.ss.usermodel.Sheet
  - getRowSumsRight
```
public boolean getRowSumsRight()
```
    Not supported
    
    Specified by:
    
    getRowSumsRight in interface org.apache.poi.ss.usermodel.Sheet
  - isPrintGridlines
```
public boolean isPrintGridlines()
```
    Not supported
    
    Specified by:
    
    isPrintGridlines in interface org.apache.poi.ss.usermodel.Sheet
  - setPrintGridlines
```
public void setPrintGridlines(boolean show)
```
    Not supported
    
    Specified by:
    
    setPrintGridlines in interface org.apache.poi.ss.usermodel.Sheet
  - isPrintRowAndColumnHeadings
```
public boolean isPrintRowAndColumnHeadings()
```
    Not supported
    
    Specified by:
    
    isPrintRowAndColumnHeadings in interface org.apache.poi.ss.usermodel.Sheet
  - setPrintRowAndColumnHeadings
```
public void setPrintRowAndColumnHeadings(boolean b)
```
    Update operations are not supported
    
    Specified by:
    
    setPrintRowAndColumnHeadings in interface org.apache.poi.ss.usermodel.Sheet
  - getPrintSetup
```
public org.apache.poi.ss.usermodel.PrintSetup getPrintSetup()
```
    Not supported
    
    Specified by:
    
    getPrintSetup in interface org.apache.poi.ss.usermodel.Sheet
  - getHeader
```
public org.apache.poi.ss.usermodel.Header getHeader()
```
    Not supported
    
    Specified by:
    
    getHeader in interface org.apache.poi.ss.usermodel.Sheet
  - getFooter
```
public org.apache.poi.ss.usermodel.Footer getFooter()
```
    Not supported
    
    Specified by:
    
    getFooter in interface org.apache.poi.ss.usermodel.Sheet
  - setSelected
```
public void setSelected(boolean value)
```
    Update operations are not supported
    
    Specified by:
    
    setSelected in interface org.apache.poi.ss.usermodel.Sheet
  - getMargin
```
public double getMargin(short margin)
```
    Not supported
    
    Specified by:
    
    getMargin in interface org.apache.poi.ss.usermodel.Sheet
  - setMargin
```
public void setMargin(short margin,
                      double size)
```
    Update operations are not supported
    
    Specified by:
    
    setMargin in interface org.apache.poi.ss.usermodel.Sheet
  - getProtect
```
public boolean getProtect()
```
    Not supported
    
    Specified by:
    
    getProtect in interface org.apache.poi.ss.usermodel.Sheet
  - protectSheet
```
public void protectSheet(java.lang.String password)
```
    Not supported
    
    Specified by:
    
    protectSheet in interface org.apache.poi.ss.usermodel.Sheet
  - getScenarioProtect
```
public boolean getScenarioProtect()
```
    Not supported
    
    Specified by:
    
    getScenarioProtect in interface org.apache.poi.ss.usermodel.Sheet
  - setZoom
```
public void setZoom(int i)
```
    Update operations are not supported
    
    Specified by:
    
    setZoom in interface org.apache.poi.ss.usermodel.Sheet
  - getTopRow
```
public short getTopRow()
```
    Not supported
    
    Specified by:
    
    getTopRow in interface org.apache.poi.ss.usermodel.Sheet
  - getLeftCol
```
public short getLeftCol()
```
    Not supported
    
    Specified by:
    
    getLeftCol in interface org.apache.poi.ss.usermodel.Sheet
  - showInPane
```
public void showInPane(int toprow,
                       int leftcol)
```
    Not supported
    
    Specified by:
    
    showInPane in interface org.apache.poi.ss.usermodel.Sheet
  - shiftRows
```
public void shiftRows(int startRow,
                      int endRow,
                      int n)
```
    Update operations are not supported
    
    Specified by:
    
    shiftRows in interface org.apache.poi.ss.usermodel.Sheet
  - shiftRows
```
public void shiftRows(int startRow,
                      int endRow,
                      int n,
                      boolean copyRowHeight,
                      boolean resetOriginalRowHeight)
```
    Update operations are not supported
    
    Specified by:
    
    shiftRows in interface org.apache.poi.ss.usermodel.Sheet
  - shiftColumns
```
public void shiftColumns(int startColumn,
                         int endColumn,
                         int n)
```
    Update operations are not supported
    
    Specified by:
    
    shiftColumns in interface org.apache.poi.ss.usermodel.Sheet
  - createFreezePane
```
public void createFreezePane(int colSplit,
                             int rowSplit,
                             int leftmostColumn,
                             int topRow)
```
    Not supported
    
    Specified by:
    
    createFreezePane in interface org.apache.poi.ss.usermodel.Sheet
  - createFreezePane
```
public void createFreezePane(int colSplit,
                             int rowSplit)
```
    Not supported
    
    Specified by:
    
    createFreezePane in interface org.apache.poi.ss.usermodel.Sheet
  - createSplitPane
```
public void createSplitPane(int xSplitPos,
                            int ySplitPos,
                            int leftmostColumn,
                            int topRow,
                            int activePane)
```
    Not supported
    
    Specified by:
    
    createSplitPane in interface org.apache.poi.ss.usermodel.Sheet
  - getPaneInformation
```
public org.apache.poi.ss.util.PaneInformation getPaneInformation()
```
    Not supported
    
    Specified by:
    
    getPaneInformation in interface org.apache.poi.ss.usermodel.Sheet
  - setDisplayGridlines
```
public void setDisplayGridlines(boolean show)
```
    Update operations are not supported
    
    Specified by:
    
    setDisplayGridlines in interface org.apache.poi.ss.usermodel.Sheet
  - isDisplayGridlines
```
public boolean isDisplayGridlines()
```
    Not supported
    
    Specified by:
    
    isDisplayGridlines in interface org.apache.poi.ss.usermodel.Sheet
  - setDisplayFormulas
```
public void setDisplayFormulas(boolean show)
```
    Update operations are not supported
    
    Specified by:
    
    setDisplayFormulas in interface org.apache.poi.ss.usermodel.Sheet
  - isDisplayFormulas
```
public boolean isDisplayFormulas()
```
    Not supported
    
    Specified by:
    
    isDisplayFormulas in interface org.apache.poi.ss.usermodel.Sheet
  - setDisplayRowColHeadings
```
public void setDisplayRowColHeadings(boolean show)
```
    Update operations are not supported
    
    Specified by:
    
    setDisplayRowColHeadings in interface org.apache.poi.ss.usermodel.Sheet
  - isDisplayRowColHeadings
```
public boolean isDisplayRowColHeadings()
```
    Not supported
    
    Specified by:
    
    isDisplayRowColHeadings in interface org.apache.poi.ss.usermodel.Sheet
  - setRowBreak
```
public void setRowBreak(int row)
```
    Update operations are not supported
    
    Specified by:
    
    setRowBreak in interface org.apache.poi.ss.usermodel.Sheet
  - isRowBroken
```
public boolean isRowBroken(int row)
```
    Not supported
    
    Specified by:
    
    isRowBroken in interface org.apache.poi.ss.usermodel.Sheet
  - removeRowBreak
```
public void removeRowBreak(int row)
```
    Update operations are not supported
    
    Specified by:
    
    removeRowBreak in interface org.apache.poi.ss.usermodel.Sheet
  - getRowBreaks
```
public int[] getRowBreaks()
```
    Not supported
    
    Specified by:
    
    getRowBreaks in interface org.apache.poi.ss.usermodel.Sheet
  - getColumnBreaks
```
public int[] getColumnBreaks()
```
    Not supported
    
    Specified by:
    
    getColumnBreaks in interface org.apache.poi.ss.usermodel.Sheet
  - setColumnBreak
```
public void setColumnBreak(int column)
```
    Update operations are not supported
    
    Specified by:
    
    setColumnBreak in interface org.apache.poi.ss.usermodel.Sheet
  - isColumnBroken
```
public boolean isColumnBroken(int column)
```
    Not supported
    
    Specified by:
    
    isColumnBroken in interface org.apache.poi.ss.usermodel.Sheet
  - removeColumnBreak
```
public void removeColumnBreak(int column)
```
    Update operations are not supported
    
    Specified by:
    
    removeColumnBreak in interface org.apache.poi.ss.usermodel.Sheet
  - setColumnGroupCollapsed
```
public void setColumnGroupCollapsed(int columnNumber,
                                    boolean collapsed)
```
    Update operations are not supported
    
    Specified by:
    
    setColumnGroupCollapsed in interface org.apache.poi.ss.usermodel.Sheet
  - groupColumn
```
public void groupColumn(int fromColumn,
                        int toColumn)
```
    Update operations are not supported
    
    Specified by:
    
    groupColumn in interface org.apache.poi.ss.usermodel.Sheet
  - ungroupColumn
```
public void ungroupColumn(int fromColumn,
                          int toColumn)
```
    Update operations are not supported
    
    Specified by:
    
    ungroupColumn in interface org.apache.poi.ss.usermodel.Sheet
  - groupRow
```
public void groupRow(int fromRow,
                     int toRow)
```
    Update operations are not supported
    
    Specified by:
    
    groupRow in interface org.apache.poi.ss.usermodel.Sheet
  - ungroupRow
```
public void ungroupRow(int fromRow,
                       int toRow)
```
    Update operations are not supported
    
    Specified by:
    
    ungroupRow in interface org.apache.poi.ss.usermodel.Sheet
  - setRowGroupCollapsed
```
public void setRowGroupCollapsed(int row,
                                 boolean collapse)
```
    Update operations are not supported
    
    Specified by:
    
    setRowGroupCollapsed in interface org.apache.poi.ss.usermodel.Sheet
  - setDefaultColumnStyle
```
public void setDefaultColumnStyle(int column,
                                  org.apache.poi.ss.usermodel.CellStyle style)
```
    Update operations are not supported
    
    Specified by:
    
    setDefaultColumnStyle in interface org.apache.poi.ss.usermodel.Sheet
  - autoSizeColumn
```
public void autoSizeColumn(int column)
```
    Update operations are not supported
    
    Specified by:
    
    autoSizeColumn in interface org.apache.poi.ss.usermodel.Sheet
  - autoSizeColumn
```
public void autoSizeColumn(int column,
                           boolean useMergedCells)
```
    Update operations are not supported
    
    Specified by:
    
    autoSizeColumn in interface org.apache.poi.ss.usermodel.Sheet
  - createDrawingPatriarch
```
public org.apache.poi.ss.usermodel.Drawing createDrawingPatriarch()
```
    Not supported
    
    Specified by:
    
    createDrawingPatriarch in interface org.apache.poi.ss.usermodel.Sheet
  - isSelected
```
public boolean isSelected()
```
    Not supported
    
    Specified by:
    
    isSelected in interface org.apache.poi.ss.usermodel.Sheet
  - setArrayFormula
```
public org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell> setArrayFormula(java.lang.String formula,
                                                                                                         org.apache.poi.ss.util.CellRangeAddress range)
```
    Update operations are not supported
    
    Specified by:
    
    setArrayFormula in interface org.apache.poi.ss.usermodel.Sheet
  - removeArrayFormula
```
public org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell> removeArrayFormula(org.apache.poi.ss.usermodel.Cell cell)
```
    Update operations are not supported
    
    Specified by:
    
    removeArrayFormula in interface org.apache.poi.ss.usermodel.Sheet
  - getDataValidationHelper
```
public org.apache.poi.ss.usermodel.DataValidationHelper getDataValidationHelper()
```
    Not supported
    
    Specified by:
    
    getDataValidationHelper in interface org.apache.poi.ss.usermodel.Sheet
  - getDataValidations
```
public java.util.List<? extends org.apache.poi.ss.usermodel.DataValidation> getDataValidations()
```
    Not supported
    
    Specified by:
    
    getDataValidations in interface org.apache.poi.ss.usermodel.Sheet
  - addValidationData
```
public void addValidationData(org.apache.poi.ss.usermodel.DataValidation dataValidation)
```
    Not supported
    
    Specified by:
    
    addValidationData in interface org.apache.poi.ss.usermodel.Sheet
  - setAutoFilter
```
public org.apache.poi.ss.usermodel.AutoFilter setAutoFilter(org.apache.poi.ss.util.CellRangeAddress range)
```
    Update operations are not supported
    
    Specified by:
    
    setAutoFilter in interface org.apache.poi.ss.usermodel.Sheet
  - getSheetConditionalFormatting
```
public org.apache.poi.ss.usermodel.SheetConditionalFormatting getSheetConditionalFormatting()
```
    Not supported
    
    Specified by:
    
    getSheetConditionalFormatting in interface org.apache.poi.ss.usermodel.Sheet
  - getRepeatingRows
```
public org.apache.poi.ss.util.CellRangeAddress getRepeatingRows()
```
    Not supported
    
    Specified by:
    
    getRepeatingRows in interface org.apache.poi.ss.usermodel.Sheet
  - getRepeatingColumns
```
public org.apache.poi.ss.util.CellRangeAddress getRepeatingColumns()
```
    Not supported
    
    Specified by:
    
    getRepeatingColumns in interface org.apache.poi.ss.usermodel.Sheet
  - setRepeatingRows
```
public void setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress rowRangeRef)
```
    Update operations are not supported
    
    Specified by:
    
    setRepeatingRows in interface org.apache.poi.ss.usermodel.Sheet
  - setRepeatingColumns
```
public void setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress columnRangeRef)
```
    Update operations are not supported
    
    Specified by:
    
    setRepeatingColumns in interface org.apache.poi.ss.usermodel.Sheet
  - getColumnOutlineLevel
```
public int getColumnOutlineLevel(int columnIndex)
```
    Not supported
    
    Specified by:
    
    getColumnOutlineLevel in interface org.apache.poi.ss.usermodel.Sheet
  - setActiveCell
```
public void setActiveCell(org.apache.poi.ss.util.CellAddress cellAddress)
```
    Not supported
    
    Specified by:
    
    setActiveCell in interface org.apache.poi.ss.usermodel.Sheet

Class StreamingSheet

Field Summary

Fields inherited from interface org.apache.poi.ss.usermodel.Sheet

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface java.lang.Iterable

Constructor Detail

StreamingSheet

Method Detail

getWorkbook

iterator

rowIterator

spliterator

getSheetName

isColumnHidden

getFirstRowNum

getLastRowNum

getCellComment

getCellComments

getMergedRegion

getMergedRegions

getNumMergedRegions

getDrawingPatriarch

getHyperlink

getHyperlink

getHyperlinkList

getActiveCell

getSharedFormulaMap

addSharedFormula

removeSharedFormula

createRow

removeRow

getRow

getPhysicalNumberOfRows

setColumnHidden

setRightToLeft

isRightToLeft

setColumnWidth

getColumnWidth

getColumnWidthInPixels

setDefaultColumnWidth

getDefaultColumnWidth

getDefaultRowHeight

getDefaultRowHeightInPoints

setDefaultRowHeight

setDefaultRowHeightInPoints

getColumnStyle

addMergedRegion

addMergedRegionUnsafe

validateMergedRegions

setVerticallyCenter

setHorizontallyCenter

getHorizontallyCenter

getVerticallyCenter

removeMergedRegion

removeMergedRegions

setForceFormulaRecalculation

getForceFormulaRecalculation

setAutobreaks

setDisplayGuts

setDisplayZeros

isDisplayZeros

setFitToPage

setRowSumsBelow

setRowSumsRight

getAutobreaks

getDisplayGuts

getFitToPage

getRowSumsBelow

getRowSumsRight

isPrintGridlines

setPrintGridlines

isPrintRowAndColumnHeadings

setPrintRowAndColumnHeadings

getPrintSetup

getHeader

getFooter

setSelected

getMargin