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.
Description
WorksheetModel is a class in the Aspose.Cells FOSS library for Java that exposes 22 methods and 19 properties for programmatic use.
Core capabilities include: string; sheetvisibility; map<celladdress, cellrecord>. These operations enable developers to integrate worksheetmodel functionality directly into Java applications.
The class also provides the name property (returns the name), the visibility property (returns the visibility), the cells property (returns the cells).
Instances are created through a single constructor that initializes the object with default values.
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. |
