Package org.apache.poi.xssf.usermodel

Class XSSFDialogsheet

java.lang.Object

org.apache.poi.ooxml.POIXMLDocumentPart

org.apache.poi.xssf.usermodel.XSSFSheet

org.apache.poi.xssf.usermodel.XSSFDialogsheet

All Implemented Interfaces:

Iterable<Row>, Sheet, OoxmlSheetExtensions

public class XSSFDialogsheet
extends XSSFSheet
implements Sheet

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.poi.ooxml.POIXMLDocumentPart

POIXMLDocumentPart.RelationPart

Field Summary

Fields

Modifier and Type	Field	Description
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet	dialogsheet

Fields inherited from class org.apache.poi.xssf.usermodel.XSSFSheet

sheet, worksheet

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

Modifier	Constructor	Description
protected	XSSFDialogsheet(XSSFSheet sheet)

Method Summary

Modifier and Type	Method	Description
XSSFRow	createRow(int rowNum)	Create a new row within the sheet and return the high level representation Note: If a row already exists at this position, it is removed/overwritten and any existing cell is removed!
boolean	getDialog()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageBreak	getDialogColumnBreaks()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter	getDialogHeaderFooter()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageMargins	getDialogPageMargins()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPrintOptions	getDialogPrintOptions()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection	getDialogProtection()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageBreak	getDialogRowBreaks()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetFormatPr	getDialogSheetFormatPr()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetPr	getDialogSheetPr()
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetViews	getDialogSheetViews()

Methods inherited from class org.apache.poi.xssf.usermodel.XSSFSheet

addHyperlink, addIgnoredErrors, addIgnoredErrors, addMergedRegion, addMergedRegionUnsafe, addValidationData, autoSizeColumn, autoSizeColumn, commit, copyRows, copyRows, copyRows, copyRows, createDrawingPatriarch, createFreezePane, createFreezePane, createPivotTable, createPivotTable, createPivotTable, createPivotTable, createPivotTable, createSplitPane, createSplitPane, createTable, disableLocking, enableLocking, findEndOfRowOutlineGroup, getActiveCell, getArbitraryExtraWidth, getAutobreaks, getCellComment, getCellComments, getColumnBreaks, getColumnHelper, getColumnOutlineLevel, getColumnStyle, getColumnWidth, getColumnWidthInPixels, getCommentsTable, getCTDrawing, getCTLegacyDrawing, getCTWorksheet, getDataValidationHelper, getDataValidations, getDefaultColumnWidth, getDefaultRowHeight, getDefaultRowHeightInPoints, getDimension, getDisplayGuts, getDrawingPatriarch, getEvenFooter, getEvenHeader, getFirstFooter, getFirstHeader, getFirstRowNum, getFitToPage, getFooter, getForceFormulaRecalculation, getHeader, getHeaderFooterProperties, getHorizontallyCenter, getHyperlink, getHyperlink, getHyperlinkList, getIgnoredErrors, getLastRowNum, getLeftCol, getMargin, getMargin, getMergedRegion, getMergedRegions, getNumberOfComments, getNumHyperlinks, getNumMergedRegions, getOddFooter, getOddHeader, getPaneInformation, getPhysicalNumberOfRows, getPivotTables, getPrintSetup, getProtect, getRepeatingColumns, getRepeatingRows, getRow, getRowBreaks, getRowSumsBelow, getRowSumsRight, getScenarioProtect, getSharedFormula, getSheetConditionalFormatting, getSheetFormatPrOutlineLevelCol, getSheetFormatPrOutlineLevelRow, getSheetName, getSheetTypeSheetViews, getTabColor, getTables, getTopRow, getVerticallyCenter, getVMLDrawing, getWorkbook, groupColumn, groupRow, hasComments, isAutoFilterLocked, isColumnBroken, isColumnHidden, isDeleteColumnsLocked, isDeleteRowsLocked, isDisplayFormulas, isDisplayGridlines, isDisplayRowColHeadings, isDisplayZeros, isFormatCellsLocked, isFormatColumnsLocked, isFormatRowsLocked, isInsertColumnsLocked, isInsertHyperlinksLocked, isInsertRowsLocked, isObjectsLocked, isPivotTablesLocked, isPrintGridlines, isPrintRowAndColumnHeadings, isRightToLeft, isRowBroken, isScenariosLocked, isSelected, isSelectLockedCellsLocked, isSelectUnlockedCellsLocked, isSheetLocked, isSortLocked, lockAutoFilter, lockDeleteColumns, lockDeleteRows, lockFormatCells, lockFormatColumns, lockFormatRows, lockInsertColumns, lockInsertHyperlinks, lockInsertRows, lockObjects, lockPivotTables, lockScenarios, lockSelectLockedCells, lockSelectUnlockedCells, lockSort, onDeleteFormula, onDocumentCreate, onDocumentRead, onSheetDelete, protectSheet, read, readOleObject, removeArrayFormula, removeColumnBreak, removeHyperlink, removeHyperlink, removeMergedRegion, removeMergedRegions, removeRow, removeRowBreak, removeTable, rowIterator, setActiveCell, setArbitraryExtraWidth, setArrayFormula, setAutobreaks, setAutoFilter, setColumnBreak, setColumnGroupCollapsed, setColumnHidden, setColumnWidth, setDefaultColumnStyle, setDefaultColumnWidth, setDefaultRowHeight, setDefaultRowHeightInPoints, setDimensionOverride, setDisplayFormulas, setDisplayGridlines, setDisplayGuts, setDisplayRowColHeadings, setDisplayZeros, setFitToPage, setForceFormulaRecalculation, setHorizontallyCenter, setMargin, setMargin, setPrintGridlines, setPrintRowAndColumnHeadings, setRepeatingColumns, setRepeatingRows, setRightToLeft, setRowBreak, setRowGroupCollapsed, setRowSumsBelow, setRowSumsRight, setSelected, setSheetPassword, setTabColor, setVerticallyCenter, setZoom, shiftColumns, shiftRows, shiftRows, showInPane, spliterator, ungroupColumn, ungroupRow, validateMergedRegions, validateSheetPassword, write

Methods inherited from class org.apache.poi.ooxml.POIXMLDocumentPart

_invokeOnDocumentRead, addRelation, createHyperlink, createRelationship, createRelationship, createRelationship, getNextPartNumber, getPackagePart, getParent, getReferenceRelationship, getReferenceRelationships, getRelationById, getRelationId, getRelationPartById, getRelationParts, getRelations, getTargetPart, isCommitted, onDocumentRemove, onSave, prepareForCommit, read, rebase, removeReferenceRelationship, removeRelation, removeRelation, removeRelation, setCommitted, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach

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

addMergedRegion, addMergedRegionUnsafe, addValidationData, autoSizeColumn, autoSizeColumn, createDrawingPatriarch, createFreezePane, createFreezePane, createSplitPane, createSplitPane, getActiveCell, getAutobreaks, getCellComment, getCellComments, getColumnBreaks, getColumnOutlineLevel, getColumnStyle, getColumnWidth, getColumnWidthInPixels, getDataValidationHelper, getDataValidations, getDefaultColumnWidth, getDefaultRowHeight, getDefaultRowHeightInPoints, getDisplayGuts, getDrawingPatriarch, getFirstRowNum, getFitToPage, getFooter, getForceFormulaRecalculation, getHeader, getHorizontallyCenter, getHyperlink, getHyperlink, getHyperlinkList, getLastRowNum, getLeftCol, getMargin, getMargin, getMergedRegion, getMergedRegions, getNumMergedRegions, getPaneInformation, getPhysicalNumberOfRows, getPrintSetup, getProtect, getRepeatingColumns, getRepeatingRows, getRow, getRowBreaks, getRowSumsBelow, getRowSumsRight, getScenarioProtect, getSheetConditionalFormatting, getSheetName, getTopRow, getVerticallyCenter, getWorkbook, groupColumn, groupRow, isColumnBroken, isColumnHidden, isDisplayFormulas, isDisplayGridlines, isDisplayRowColHeadings, isDisplayZeros, isPrintGridlines, isPrintRowAndColumnHeadings, isRightToLeft, isRowBroken, isSelected, iterator, protectSheet, removeArrayFormula, removeColumnBreak, removeMergedRegion, removeMergedRegions, removeRow, removeRowBreak, rowIterator, setActiveCell, setArrayFormula, setAutobreaks, setAutoFilter, setColumnBreak, setColumnGroupCollapsed, setColumnHidden, setColumnWidth, setDefaultColumnStyle, setDefaultColumnWidth, setDefaultRowHeight, setDefaultRowHeightInPoints, setDisplayFormulas, setDisplayGridlines, setDisplayGuts, setDisplayRowColHeadings, setDisplayZeros, setFitToPage, setForceFormulaRecalculation, setHorizontallyCenter, setMargin, setMargin, setPrintGridlines, setPrintRowAndColumnHeadings, setRepeatingColumns, setRepeatingRows, setRightToLeft, setRowBreak, setRowGroupCollapsed, setRowSumsBelow, setRowSumsRight, setSelected, setVerticallyCenter, setZoom, shiftColumns, shiftRows, shiftRows, showInPane, spliterator, ungroupColumn, ungroupRow, validateMergedRegions

Field Details

dialogsheet

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet dialogsheet

Constructor Details

XSSFDialogsheet

protected XSSFDialogsheet(XSSFSheet sheet)

Method Details

createRow

public XSSFRow createRow(int rowNum)

Description copied from class: XSSFSheet

Create a new row within the sheet and return the high level representation Note: If a row already exists at this position, it is removed/overwritten and any existing cell is removed!

Specified by:

createRow in interface Sheet

Overrides:

createRow in class XSSFSheet

Parameters:

rowNum - row number

Returns:

High level XSSFRow object representing a row in the sheet

See Also:

• XSSFSheet.removeRow(Row)

getDialogHeaderFooter

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter getDialogHeaderFooter()

getDialogSheetPr

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetPr getDialogSheetPr()

getDialogColumnBreaks

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageBreak getDialogColumnBreaks()

getDialogSheetFormatPr

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetFormatPr getDialogSheetFormatPr()

getDialogPageMargins

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageMargins getDialogPageMargins()

getDialogRowBreaks

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageBreak getDialogRowBreaks()

getDialogSheetViews

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetViews getDialogSheetViews()

getDialogPrintOptions

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPrintOptions getDialogPrintOptions()

getDialogProtection

protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection getDialogProtection()

getDialog

public boolean getDialog()