Annotation Type ExcelSheetLayout
The Interface ExcelSheetLayout.
ExcelSheetLayout is used to configure the sheet layout through:
ExcelSheetLayout is used to configure the sheet layout through:
- Landscape - to enable/disable landscape
- NotMerge - to enable/disable merged cells
- SortAndFilter - to enable/disable sort and filter
- StartColumn - to set the column start
- StartRow - to set the row start
- Order - to set index on sheets list
- AreaBorder - to define the border areas
- showHeader - to enable/disable the writing of the header
SheetData and SheetSummary classes.-
Optional Element Summary
Optional ElementsModifier and TypeOptional ElementDescriptionArea border.booleanGroup column.booleanGroup row.booleanHide.booleanLandscape.Locked.booleanNot merge.intOrder.shortPaper size.booleanShow header.booleanSort and filter.intStart column.intStart row.
-
Element Details
-
landscape
boolean landscapeLandscape.- Returns:
- true, if successful
- Default:
true
-
notMerge
boolean notMergeNot merge.- Returns:
- true, if successful
- Default:
true
-
sortAndFilter
boolean sortAndFilterSort and filter.- Returns:
- true, if successful
- Default:
true
-
startColumn
int startColumnStart column.- Returns:
- the int
- Default:
0
-
startRow
int startRowStart row.- Returns:
- the int
- Default:
0
-
order
int orderOrder.- Returns:
- the int
- Default:
-1
-
areaBorder
ExcelAreaBorder[] areaBorderArea border.- Returns:
- the excel area border[]
- Default:
{}
-
showHeader
boolean showHeaderShow header.- Returns:
- true, if successful
- Default:
true
-
groupRow
boolean groupRowGroup row.- Returns:
- true, if successful
- Default:
false
-
groupColumn
boolean groupColumnGroup column.- Returns:
- true, if successful
- Default:
false
-
scale
short scalePaper size.- Returns:
- the paper size
- Default:
100
-
locked
ExcelLocked lockedLocked.- Returns:
- true, if successful
- Default:
@bld.generator.report.excel.annotation.ExcelLocked(locked=false)
-