Aspose.Cells FOSS

WorksheetModel

WorksheetModel

Overview

WorksheetModel is a class in Aspose.Cells FOSS for Java.

Represents the model of a worksheet in the Excel file.

Properties

Name	Type	Access	Description
`name`	`String`	Read	Returns the name.
`visibility`	`SheetVisibility`	Read	Returns the visibility.
`cells`	`Map<CellAddress, CellRecord>`	Read	Returns the cells.
`rows`	`Map<Integer, RowModel>`	Read	Returns the rows.
`columns`	`List<ColumnRangeModel>`	Read	Returns the columns.
`mergeRegions`	`List<MergeRegion>`	Read	Returns the merge regions.
`hyperlinks`	`List<HyperlinkModel>`	Read	Returns the hyperlinks.
`validations`	`List<ValidationModel>`	Read	Returns the validations.
`conditionalFormattings`	`List<ConditionalFormattingModel>`	Read	Returns the conditional formattings.
`pageSetup`	`PageSetupModel`	Read	Returns the page setup.
`view`	`WorksheetViewModel`	Read	Returns the view.
`protection`	`WorksheetProtectionModel`	Read	Returns the protection.
`autoFilter`	`AutoFilterModel`	Read	Returns the auto filter.
`tabColor`	`ColorValue`	Read	Returns the tab color.

Methods

Signature	Description
`WorksheetModel(name: String)`	Initializes a new WorksheetModel instance.
`getName()` → `String`	Returns the name.
`setName(name: String)`	Sets the name.
`getVisibility()` → `SheetVisibility`	Returns the visibility.
`setVisibility(visibility: SheetVisibility)`	Sets the visibility.
`getCells()` → `Map<CellAddress, CellRecord>`	Returns the cells.
`getRows()` → `Map<Integer, RowModel>`	Returns the rows.
`getColumns()` → `List<ColumnRangeModel>`	Returns the columns.
`getMergeRegions()` → `List<MergeRegion>`	Returns the merge regions.
`getHyperlinks()` → `List<HyperlinkModel>`	Returns the hyperlinks.
`getValidations()` → `List<ValidationModel>`	Returns the validations.
`getConditionalFormattings()` → `List<ConditionalFormattingModel>`	Returns the conditional formattings.
`getPageSetup()` → `PageSetupModel`	Returns the page setup.
`getView()` → `WorksheetViewModel`	Returns the view.
`getProtection()` → `WorksheetProtectionModel`	Returns the protection.
`getAutoFilter()` → `AutoFilterModel`	Returns the auto filter.
`getTabColor()` → `ColorValue`	Returns the tab color.
`setTabColor(tabColor: ColorValue)`	Sets the tab color.