Package com.storedobject.office.od.ods

Class Sheet

java.lang.Object

com.storedobject.office.od.ods.Sheet

All Implemented Interfaces:

Iterable<org.apache.poi.ss.usermodel.Row>, org.apache.poi.ss.usermodel.Sheet

public class Sheet
extends 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

Method Summary

Modifier and Type	Method	Description
int	addMergedRegion(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
int	addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
void	addValidationData(org.apache.poi.ss.usermodel.DataValidation dataValidation)
void	autoSizeColumn(int i)
void	autoSizeColumn(int i, boolean b)
org.apache.poi.ss.usermodel.Drawing<?>	createDrawingPatriarch()
void	createFreezePane(int i, int i1)
void	createFreezePane(int i, int i1, int i2, int i3)
Row	createRow(int index)
void	createSplitPane(int i, int i1, int i2, int i3, int i4)
void	createSplitPane(int i, int i1, int i2, int i3, org.apache.poi.ss.usermodel.PaneType paneType)
void	delete()
void	dispose()
org.apache.poi.ss.util.CellAddress	getActiveCell()
boolean	getAutobreaks()
Cell	getCell(int row, int column)
Cell	getCell(String address)
org.apache.poi.ss.usermodel.Comment	getCellComment(org.apache.poi.ss.util.CellAddress cellAddress)
Map<org.apache.poi.ss.util.CellAddress,? extends org.apache.poi.ss.usermodel.Comment>	getCellComments()
int[]	getColumnBreaks()
int	getColumnOutlineLevel(int i)
org.apache.poi.ss.usermodel.CellStyle	getColumnStyle(int i)
int	getColumnWidth(int index)
float	getColumnWidthInPixels(int index)
org.apache.poi.ss.usermodel.DataValidationHelper	getDataValidationHelper()
List<? extends org.apache.poi.ss.usermodel.DataValidation>	getDataValidations()
int	getDefaultColumnWidth()
short	getDefaultRowHeight()
float	getDefaultRowHeightInPoints()
boolean	getDisplayGuts()
org.apache.poi.ss.usermodel.Drawing<?>	getDrawingPatriarch()
int	getFirstRowNum()
boolean	getFitToPage()
org.apache.poi.ss.usermodel.Footer	getFooter()
boolean	getForceFormulaRecalculation()
org.apache.poi.ss.usermodel.Header	getHeader()
boolean	getHorizontallyCenter()
org.apache.poi.ss.usermodel.Hyperlink	getHyperlink(int i, int i1)
org.apache.poi.ss.usermodel.Hyperlink	getHyperlink(org.apache.poi.ss.util.CellAddress cellAddress)
List<? extends org.apache.poi.ss.usermodel.Hyperlink>	getHyperlinkList()
int	getLastRowNum()
short	getLeftCol()
double	getMargin(short i)
double	getMargin(org.apache.poi.ss.usermodel.PageMargin pageMargin)
org.apache.poi.ss.util.CellRangeAddress	getMergedRegion(int i)
List<org.apache.poi.ss.util.CellRangeAddress>	getMergedRegions()
int	getNumMergedRegions()
org.apache.poi.ss.util.PaneInformation	getPaneInformation()
int	getPhysicalNumberOfRows()
org.apache.poi.ss.usermodel.PrintSetup	getPrintSetup()
boolean	getProtect()
org.apache.poi.ss.util.CellRangeAddress	getRepeatingColumns()
org.apache.poi.ss.util.CellRangeAddress	getRepeatingRows()
org.apache.poi.ss.usermodel.Row	getRow(int index)
int[]	getRowBreaks()
boolean	getRowSumsBelow()
boolean	getRowSumsRight()
boolean	getScenarioProtect()
org.apache.poi.ss.usermodel.SheetConditionalFormatting	getSheetConditionalFormatting()
String	getSheetName()
short	getTopRow()
boolean	getVerticallyCenter()
Workbook	getWorkbook()
void	groupColumn(int i, int i1)
void	groupRow(int i, int i1)
boolean	isColumnBroken(int i)
boolean	isColumnHidden(int index)
boolean	isDisplayFormulas()
boolean	isDisplayGridlines()
boolean	isDisplayRowColHeadings()
boolean	isDisplayZeros()
boolean	isPrintGridlines()
boolean	isPrintRowAndColumnHeadings()
boolean	isRightToLeft()
boolean	isRowBroken(int i)
boolean	isSelected()
Iterator<org.apache.poi.ss.usermodel.Row>	iterator()
void	protectSheet(String s)
org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell>	removeArrayFormula(org.apache.poi.ss.usermodel.Cell cell)
void	removeColumnBreak(int i)
void	removeMergedRegion(int i)
void	removeMergedRegions(Collection<Integer> collection)
void	removeRow(org.apache.poi.ss.usermodel.Row row)
void	removeRowBreak(int i)
Iterator<org.apache.poi.ss.usermodel.Row>	rowIterator()
void	setActiveCell(org.apache.poi.ss.util.CellAddress cellAddress)
org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell>	setArrayFormula(String s, org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
void	setAutobreaks(boolean b)
org.apache.poi.ss.usermodel.AutoFilter	setAutoFilter(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
void	setColumnBreak(int i)
void	setColumnGroupCollapsed(int i, boolean b)
void	setColumnHidden(int index, boolean b)
void	setColumnWidth(int i, int i1)
void	setDefaultColumnStyle(int i, org.apache.poi.ss.usermodel.CellStyle cellStyle)
void	setDefaultColumnWidth(int i)
void	setDefaultRowHeight(short i)
void	setDefaultRowHeightInPoints(float v)
void	setDisplayFormulas(boolean b)
void	setDisplayGridlines(boolean b)
void	setDisplayGuts(boolean b)
void	setDisplayRowColHeadings(boolean b)
void	setDisplayZeros(boolean b)
void	setFitToPage(boolean b)
void	setForceFormulaRecalculation(boolean b)
void	setHorizontallyCenter(boolean b)
void	setMargin(short i, double v)
void	setMargin(org.apache.poi.ss.usermodel.PageMargin pageMargin, double v)
void	setPrintGridlines(boolean b)
void	setPrintRowAndColumnHeadings(boolean b)
void	setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
void	setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)
void	setRightToLeft(boolean b)
void	setRowBreak(int i)
void	setRowGroupCollapsed(int i, boolean b)
void	setRowSumsBelow(boolean b)
void	setRowSumsRight(boolean b)
void	setSelected(boolean b)
void	setVerticallyCenter(boolean b)
void	setZoom(int i)
void	shiftColumns(int i, int i1, int i2)
void	shiftRows(int i, int i1, int i2)
void	shiftRows(int i, int i1, int i2, boolean b, boolean b1)
void	showInPane(int i, int i1)
void	ungroupColumn(int i, int i1)
void	ungroupRow(int i, int i1)
void	validateMergedRegions()

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

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

spliterator

Method Details

getWorkbook

public Workbook getWorkbook()

Specified by:

getWorkbook in interface org.apache.poi.ss.usermodel.Sheet

getSheetName

public String getSheetName()

Specified by:

getSheetName in interface org.apache.poi.ss.usermodel.Sheet

isSelected

public boolean isSelected()

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(String s,
 org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)

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)

Specified by:

removeArrayFormula in interface org.apache.poi.ss.usermodel.Sheet

getDataValidationHelper

public org.apache.poi.ss.usermodel.DataValidationHelper getDataValidationHelper()

Specified by:

getDataValidationHelper in interface org.apache.poi.ss.usermodel.Sheet

getDataValidations

public List<? extends org.apache.poi.ss.usermodel.DataValidation> getDataValidations()

Specified by:

getDataValidations in interface org.apache.poi.ss.usermodel.Sheet

addValidationData

public void addValidationData(org.apache.poi.ss.usermodel.DataValidation dataValidation)

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 cellRangeAddress)

Specified by:

setAutoFilter in interface org.apache.poi.ss.usermodel.Sheet

getSheetConditionalFormatting

public org.apache.poi.ss.usermodel.SheetConditionalFormatting getSheetConditionalFormatting()

Specified by:

getSheetConditionalFormatting in interface org.apache.poi.ss.usermodel.Sheet

getRepeatingRows

public org.apache.poi.ss.util.CellRangeAddress getRepeatingRows()

Specified by:

getRepeatingRows in interface org.apache.poi.ss.usermodel.Sheet

getRepeatingColumns

public org.apache.poi.ss.util.CellRangeAddress getRepeatingColumns()

Specified by:

getRepeatingColumns in interface org.apache.poi.ss.usermodel.Sheet

setRepeatingRows

public void setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)

Specified by:

setRepeatingRows in interface org.apache.poi.ss.usermodel.Sheet

setRepeatingColumns

public void setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)

Specified by:

setRepeatingColumns in interface org.apache.poi.ss.usermodel.Sheet

getColumnOutlineLevel

public int getColumnOutlineLevel(int i)

Specified by:

getColumnOutlineLevel in interface org.apache.poi.ss.usermodel.Sheet

getHyperlink

public org.apache.poi.ss.usermodel.Hyperlink getHyperlink(int i,
 int i1)

Specified by:

getHyperlink in interface org.apache.poi.ss.usermodel.Sheet

getHyperlink

public org.apache.poi.ss.usermodel.Hyperlink getHyperlink(org.apache.poi.ss.util.CellAddress cellAddress)

Specified by:

getHyperlink in interface org.apache.poi.ss.usermodel.Sheet

getHyperlinkList

public List<? extends org.apache.poi.ss.usermodel.Hyperlink> getHyperlinkList()

Specified by:

getHyperlinkList in interface org.apache.poi.ss.usermodel.Sheet

getActiveCell

public org.apache.poi.ss.util.CellAddress getActiveCell()

Specified by:

getActiveCell in interface org.apache.poi.ss.usermodel.Sheet

setActiveCell

public void setActiveCell(org.apache.poi.ss.util.CellAddress cellAddress)

Specified by:

setActiveCell in interface org.apache.poi.ss.usermodel.Sheet

getCell

public Cell getCell(int row,
 int column)

getCell

public Cell getCell(String address)

delete

public void delete()

dispose

public void dispose()

createRow

public Row createRow(int index)

Specified by:

createRow in interface org.apache.poi.ss.usermodel.Sheet

removeRow

public void removeRow(org.apache.poi.ss.usermodel.Row row)

Specified by:

removeRow in interface org.apache.poi.ss.usermodel.Sheet

getRow

public org.apache.poi.ss.usermodel.Row getRow(int index)

Specified by:

getRow in interface org.apache.poi.ss.usermodel.Sheet

getPhysicalNumberOfRows

public int getPhysicalNumberOfRows()

Specified by:

getPhysicalNumberOfRows in interface org.apache.poi.ss.usermodel.Sheet

getFirstRowNum

public int getFirstRowNum()

Specified by:

getFirstRowNum in interface org.apache.poi.ss.usermodel.Sheet

getLastRowNum

public int getLastRowNum()

Specified by:

getLastRowNum in interface org.apache.poi.ss.usermodel.Sheet

setColumnHidden

public void setColumnHidden(int index,
 boolean b)

Specified by:

setColumnHidden in interface org.apache.poi.ss.usermodel.Sheet

isColumnHidden

public boolean isColumnHidden(int index)

Specified by:

isColumnHidden in interface org.apache.poi.ss.usermodel.Sheet

setRightToLeft

public void setRightToLeft(boolean b)

Specified by:

setRightToLeft in interface org.apache.poi.ss.usermodel.Sheet

isRightToLeft

public boolean isRightToLeft()

Specified by:

isRightToLeft in interface org.apache.poi.ss.usermodel.Sheet

setColumnWidth

public void setColumnWidth(int i,
 int i1)

Specified by:

setColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

getColumnWidth

public int getColumnWidth(int index)

Specified by:

getColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

getColumnWidthInPixels

public float getColumnWidthInPixels(int index)

Specified by:

getColumnWidthInPixels in interface org.apache.poi.ss.usermodel.Sheet

setDefaultColumnWidth

public void setDefaultColumnWidth(int i)

Specified by:

setDefaultColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

getDefaultColumnWidth

public int getDefaultColumnWidth()

Specified by:

getDefaultColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

getDefaultRowHeight

public short getDefaultRowHeight()

Specified by:

getDefaultRowHeight in interface org.apache.poi.ss.usermodel.Sheet

getDefaultRowHeightInPoints

public float getDefaultRowHeightInPoints()

Specified by:

getDefaultRowHeightInPoints in interface org.apache.poi.ss.usermodel.Sheet

setDefaultRowHeight

public void setDefaultRowHeight(short i)

Specified by:

setDefaultRowHeight in interface org.apache.poi.ss.usermodel.Sheet

setDefaultRowHeightInPoints

public void setDefaultRowHeightInPoints(float v)

Specified by:

setDefaultRowHeightInPoints in interface org.apache.poi.ss.usermodel.Sheet

getColumnStyle

public org.apache.poi.ss.usermodel.CellStyle getColumnStyle(int i)

Specified by:

getColumnStyle in interface org.apache.poi.ss.usermodel.Sheet

addMergedRegion

public int addMergedRegion(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)

Specified by:

addMergedRegion in interface org.apache.poi.ss.usermodel.Sheet

addMergedRegionUnsafe

public int addMergedRegionUnsafe(org.apache.poi.ss.util.CellRangeAddress cellRangeAddress)

Specified by:

addMergedRegionUnsafe in interface org.apache.poi.ss.usermodel.Sheet

validateMergedRegions

public void validateMergedRegions()

Specified by:

validateMergedRegions in interface org.apache.poi.ss.usermodel.Sheet

setVerticallyCenter

public void setVerticallyCenter(boolean b)

Specified by:

setVerticallyCenter in interface org.apache.poi.ss.usermodel.Sheet

setHorizontallyCenter

public void setHorizontallyCenter(boolean b)

Specified by:

setHorizontallyCenter in interface org.apache.poi.ss.usermodel.Sheet

getHorizontallyCenter

public boolean getHorizontallyCenter()

Specified by:

getHorizontallyCenter in interface org.apache.poi.ss.usermodel.Sheet

getVerticallyCenter

public boolean getVerticallyCenter()

Specified by:

getVerticallyCenter in interface org.apache.poi.ss.usermodel.Sheet

removeMergedRegion

public void removeMergedRegion(int i)

Specified by:

removeMergedRegion in interface org.apache.poi.ss.usermodel.Sheet

removeMergedRegions

public void removeMergedRegions(Collection<Integer> collection)

Specified by:

removeMergedRegions in interface org.apache.poi.ss.usermodel.Sheet

getNumMergedRegions

public int getNumMergedRegions()

Specified by:

getNumMergedRegions in interface org.apache.poi.ss.usermodel.Sheet

getMergedRegion

public org.apache.poi.ss.util.CellRangeAddress getMergedRegion(int i)

Specified by:

getMergedRegion in interface org.apache.poi.ss.usermodel.Sheet

getMergedRegions

public List<org.apache.poi.ss.util.CellRangeAddress> getMergedRegions()

Specified by:

getMergedRegions in interface org.apache.poi.ss.usermodel.Sheet

rowIterator

public Iterator<org.apache.poi.ss.usermodel.Row> rowIterator()

Specified by:

rowIterator in interface org.apache.poi.ss.usermodel.Sheet

setForceFormulaRecalculation

public void setForceFormulaRecalculation(boolean b)

Specified by:

setForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Sheet

getForceFormulaRecalculation

public boolean getForceFormulaRecalculation()

Specified by:

getForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Sheet

setAutobreaks

public void setAutobreaks(boolean b)

Specified by:

setAutobreaks in interface org.apache.poi.ss.usermodel.Sheet

setDisplayGuts

public void setDisplayGuts(boolean b)

Specified by:

setDisplayGuts in interface org.apache.poi.ss.usermodel.Sheet

setDisplayZeros

public void setDisplayZeros(boolean b)

Specified by:

setDisplayZeros in interface org.apache.poi.ss.usermodel.Sheet

isDisplayZeros

public boolean isDisplayZeros()

Specified by:

isDisplayZeros in interface org.apache.poi.ss.usermodel.Sheet

setFitToPage

public void setFitToPage(boolean b)

Specified by:

setFitToPage in interface org.apache.poi.ss.usermodel.Sheet

setRowSumsBelow

public void setRowSumsBelow(boolean b)

Specified by:

setRowSumsBelow in interface org.apache.poi.ss.usermodel.Sheet

setRowSumsRight

public void setRowSumsRight(boolean b)

Specified by:

setRowSumsRight in interface org.apache.poi.ss.usermodel.Sheet

getAutobreaks

public boolean getAutobreaks()

Specified by:

getAutobreaks in interface org.apache.poi.ss.usermodel.Sheet

getDisplayGuts

public boolean getDisplayGuts()

Specified by:

getDisplayGuts in interface org.apache.poi.ss.usermodel.Sheet

getFitToPage

public boolean getFitToPage()

Specified by:

getFitToPage in interface org.apache.poi.ss.usermodel.Sheet

getRowSumsBelow

public boolean getRowSumsBelow()

Specified by:

getRowSumsBelow in interface org.apache.poi.ss.usermodel.Sheet

getRowSumsRight

public boolean getRowSumsRight()

Specified by:

getRowSumsRight in interface org.apache.poi.ss.usermodel.Sheet

isPrintGridlines

public boolean isPrintGridlines()

Specified by:

isPrintGridlines in interface org.apache.poi.ss.usermodel.Sheet

setPrintGridlines

public void setPrintGridlines(boolean b)

Specified by:

setPrintGridlines in interface org.apache.poi.ss.usermodel.Sheet

isPrintRowAndColumnHeadings

public boolean isPrintRowAndColumnHeadings()

Specified by:

isPrintRowAndColumnHeadings in interface org.apache.poi.ss.usermodel.Sheet

setPrintRowAndColumnHeadings

public void setPrintRowAndColumnHeadings(boolean b)

Specified by:

setPrintRowAndColumnHeadings in interface org.apache.poi.ss.usermodel.Sheet

getPrintSetup

public org.apache.poi.ss.usermodel.PrintSetup getPrintSetup()

Specified by:

getPrintSetup in interface org.apache.poi.ss.usermodel.Sheet

getHeader

public org.apache.poi.ss.usermodel.Header getHeader()

Specified by:

getHeader in interface org.apache.poi.ss.usermodel.Sheet

getFooter

public org.apache.poi.ss.usermodel.Footer getFooter()

Specified by:

getFooter in interface org.apache.poi.ss.usermodel.Sheet

setSelected

public void setSelected(boolean b)

Specified by:

setSelected in interface org.apache.poi.ss.usermodel.Sheet

getMargin

public double getMargin(short i)

Specified by:

getMargin in interface org.apache.poi.ss.usermodel.Sheet

getMargin

public double getMargin(org.apache.poi.ss.usermodel.PageMargin pageMargin)

Specified by:

getMargin in interface org.apache.poi.ss.usermodel.Sheet

setMargin

public void setMargin(short i,
 double v)

Specified by:

setMargin in interface org.apache.poi.ss.usermodel.Sheet

setMargin

public void setMargin(org.apache.poi.ss.usermodel.PageMargin pageMargin,
 double v)

Specified by:

setMargin in interface org.apache.poi.ss.usermodel.Sheet

getProtect

public boolean getProtect()

Specified by:

getProtect in interface org.apache.poi.ss.usermodel.Sheet

protectSheet

public void protectSheet(String s)

Specified by:

protectSheet in interface org.apache.poi.ss.usermodel.Sheet

getScenarioProtect

public boolean getScenarioProtect()

Specified by:

getScenarioProtect in interface org.apache.poi.ss.usermodel.Sheet

setZoom

public void setZoom(int i)

Specified by:

setZoom in interface org.apache.poi.ss.usermodel.Sheet

getTopRow

public short getTopRow()

Specified by:

getTopRow in interface org.apache.poi.ss.usermodel.Sheet

getLeftCol

public short getLeftCol()

Specified by:

getLeftCol in interface org.apache.poi.ss.usermodel.Sheet

showInPane

public void showInPane(int i,
 int i1)

Specified by:

showInPane in interface org.apache.poi.ss.usermodel.Sheet

shiftRows

public void shiftRows(int i,
 int i1,
 int i2)

Specified by:

shiftRows in interface org.apache.poi.ss.usermodel.Sheet

shiftRows

public void shiftRows(int i,
 int i1,
 int i2,
 boolean b,
 boolean b1)

Specified by:

shiftRows in interface org.apache.poi.ss.usermodel.Sheet

shiftColumns

public void shiftColumns(int i,
 int i1,
 int i2)

Specified by:

shiftColumns in interface org.apache.poi.ss.usermodel.Sheet

createFreezePane

public void createFreezePane(int i,
 int i1,
 int i2,
 int i3)

Specified by:

createFreezePane in interface org.apache.poi.ss.usermodel.Sheet

createFreezePane

public void createFreezePane(int i,
 int i1)

Specified by:

createFreezePane in interface org.apache.poi.ss.usermodel.Sheet

createSplitPane

public void createSplitPane(int i,
 int i1,
 int i2,
 int i3,
 int i4)

Specified by:

createSplitPane in interface org.apache.poi.ss.usermodel.Sheet

createSplitPane

public void createSplitPane(int i,
 int i1,
 int i2,
 int i3,
 org.apache.poi.ss.usermodel.PaneType paneType)

Specified by:

createSplitPane in interface org.apache.poi.ss.usermodel.Sheet

getPaneInformation

public org.apache.poi.ss.util.PaneInformation getPaneInformation()

Specified by:

getPaneInformation in interface org.apache.poi.ss.usermodel.Sheet

setDisplayGridlines

public void setDisplayGridlines(boolean b)

Specified by:

setDisplayGridlines in interface org.apache.poi.ss.usermodel.Sheet

isDisplayGridlines

public boolean isDisplayGridlines()

Specified by:

isDisplayGridlines in interface org.apache.poi.ss.usermodel.Sheet

setDisplayFormulas

public void setDisplayFormulas(boolean b)

Specified by:

setDisplayFormulas in interface org.apache.poi.ss.usermodel.Sheet

isDisplayFormulas

public boolean isDisplayFormulas()

Specified by:

isDisplayFormulas in interface org.apache.poi.ss.usermodel.Sheet

setDisplayRowColHeadings

public void setDisplayRowColHeadings(boolean b)

Specified by:

setDisplayRowColHeadings in interface org.apache.poi.ss.usermodel.Sheet

isDisplayRowColHeadings

public boolean isDisplayRowColHeadings()

Specified by:

isDisplayRowColHeadings in interface org.apache.poi.ss.usermodel.Sheet

setRowBreak

public void setRowBreak(int i)

Specified by:

setRowBreak in interface org.apache.poi.ss.usermodel.Sheet

isRowBroken

public boolean isRowBroken(int i)

Specified by:

isRowBroken in interface org.apache.poi.ss.usermodel.Sheet

removeRowBreak

public void removeRowBreak(int i)

Specified by:

removeRowBreak in interface org.apache.poi.ss.usermodel.Sheet

getRowBreaks

public int[] getRowBreaks()

Specified by:

getRowBreaks in interface org.apache.poi.ss.usermodel.Sheet

getColumnBreaks

public int[] getColumnBreaks()

Specified by:

getColumnBreaks in interface org.apache.poi.ss.usermodel.Sheet

setColumnBreak

public void setColumnBreak(int i)

Specified by:

setColumnBreak in interface org.apache.poi.ss.usermodel.Sheet

isColumnBroken

public boolean isColumnBroken(int i)

Specified by:

isColumnBroken in interface org.apache.poi.ss.usermodel.Sheet

removeColumnBreak

public void removeColumnBreak(int i)

Specified by:

removeColumnBreak in interface org.apache.poi.ss.usermodel.Sheet

setColumnGroupCollapsed

public void setColumnGroupCollapsed(int i,
 boolean b)

Specified by:

setColumnGroupCollapsed in interface org.apache.poi.ss.usermodel.Sheet

groupColumn

public void groupColumn(int i,
 int i1)

Specified by:

groupColumn in interface org.apache.poi.ss.usermodel.Sheet

ungroupColumn

public void ungroupColumn(int i,
 int i1)

Specified by:

ungroupColumn in interface org.apache.poi.ss.usermodel.Sheet

groupRow

public void groupRow(int i,
 int i1)

Specified by:

groupRow in interface org.apache.poi.ss.usermodel.Sheet

ungroupRow

public void ungroupRow(int i,
 int i1)

Specified by:

ungroupRow in interface org.apache.poi.ss.usermodel.Sheet

setRowGroupCollapsed

public void setRowGroupCollapsed(int i,
 boolean b)

Specified by:

setRowGroupCollapsed in interface org.apache.poi.ss.usermodel.Sheet

setDefaultColumnStyle

public void setDefaultColumnStyle(int i,
 org.apache.poi.ss.usermodel.CellStyle cellStyle)

Specified by:

setDefaultColumnStyle in interface org.apache.poi.ss.usermodel.Sheet

autoSizeColumn

public void autoSizeColumn(int i)

Specified by:

autoSizeColumn in interface org.apache.poi.ss.usermodel.Sheet

autoSizeColumn

public void autoSizeColumn(int i,
 boolean b)

Specified by:

autoSizeColumn in interface org.apache.poi.ss.usermodel.Sheet

getCellComment

public org.apache.poi.ss.usermodel.Comment getCellComment(org.apache.poi.ss.util.CellAddress cellAddress)

Specified by:

getCellComment in interface org.apache.poi.ss.usermodel.Sheet

getCellComments

public Map<org.apache.poi.ss.util.CellAddress,? extends org.apache.poi.ss.usermodel.Comment> getCellComments()

Specified by:

getCellComments in interface org.apache.poi.ss.usermodel.Sheet

getDrawingPatriarch

public org.apache.poi.ss.usermodel.Drawing<?> getDrawingPatriarch()

Specified by:

getDrawingPatriarch in interface org.apache.poi.ss.usermodel.Sheet

createDrawingPatriarch

public org.apache.poi.ss.usermodel.Drawing<?> createDrawingPatriarch()

Specified by:

createDrawingPatriarch in interface org.apache.poi.ss.usermodel.Sheet

iterator

public Iterator<org.apache.poi.ss.usermodel.Row> iterator()

Specified by:

iterator in interface Iterable<org.apache.poi.ss.usermodel.Row>

Specified by:

iterator in interface org.apache.poi.ss.usermodel.Sheet