WorksheetModel

Overview

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

Represents the model of a worksheet in the Excel file.

This class provides 23 methods for working with WorksheetModel objects in Java programs. Available methods include: WorksheetModel, getAutoFilter, getCells, getCharts, getColumns, getComments, getConditionalFormattings, getHyperlinks, getListObjects, getMergeRegions, getName, getPageSetup, and 11 additional methods. All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package. Properties: autoFilter, cells, charts, columns, comments, conditionalFormattings, and 13 more.

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.
`comments`	`List<CommentModel>`	Read	Gets the comments.
`pictures`	`List<PictureModel>`	Read	Gets the pictures.
`shapes`	`List<ShapeModel>`	Read	Gets the shapes.
`charts`	`List<ChartModel>`	Read	Gets the charts.
`listObjects`	`List<ListObjectModel>`	Read	Gets the list objects.

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.
`getComments()` → `List<CommentModel>`	Returns the comments.
`getPictures()` → `List<PictureModel>`	Returns the pictures.
`getShapes()` → `List<ShapeModel>`	Returns the shapes.
`getCharts()` → `List<ChartModel>`	Returns the charts.
`getListObjects()` → `List<ListObjectModel>`	Returns the list objects.

WorksheetModel

Overview

Properties

Methods

See Also