WorksheetModel

Overview

WorksheetModel is a class in Aspose.Cells FOSS for C++.

Represents worksheet model.

This class provides 37 methods for working with WorksheetModel objects in C++ programs. Available methods include: AutoFilterModel, GetAutoFilter, GetCells, GetColumns, GetConditionalFormattings, GetHyperlinks, GetMergeRegions, GetName, GetPageSetup, GetProtection, GetRows, GetTabColor, and 10 additional methods. All public members are accessible to any C++ application after installing the Aspose.Cells FOSS for C++ package. Accessor methods: AutoFilterModel, PageSetupModel, SheetVisibility, WorksheetProtectionModel, WorksheetViewModel.

Accessor Methods

Name	Type	Access	Description
`SheetVisibility`	`SheetVisibility`	Read	Gets the sheet visibility.
`PageSetupModel`	`PageSetupModel`	Read	Gets the page setup model.
`WorksheetViewModel`	`WorksheetViewModel`	Read	Gets the worksheet view model.
`WorksheetProtectionModel`	`WorksheetProtectionModel`	Read	Gets the worksheet protection model.
`AutoFilterModel`	`AutoFilterModel`	Read	Gets the auto filter model.

Methods

Signature	Description
`SheetVisibility()` → `SheetVisibility`	Gets or sets the visibility.
`PageSetupModel()` → `PageSetupModel`	Gets the page setup.
`PageSetupModel()` → `PageSetupModel`	Calls PageSetupModel on this WorksheetModel instance.
`WorksheetViewModel()` → `WorksheetViewModel`	Gets the view.
`WorksheetViewModel()` → `WorksheetViewModel`	Calls WorksheetViewModel on this WorksheetModel instance.
`WorksheetProtectionModel()` → `WorksheetProtectionModel`	Gets the protection.
`WorksheetProtectionModel()` → `WorksheetProtectionModel`	Calls WorksheetProtectionModel on this WorksheetModel instance.
`AutoFilterModel()` → `AutoFilterModel`	Gets the auto filter.
`AutoFilterModel()` → `AutoFilterModel`	Calls AutoFilterModel on this WorksheetModel instance.
`GetName()` → `std::string`	Gets or sets the name.
`SetName(value: std::string)`	Sets the name value.
`GetVisibility()` → `SheetVisibility`	Gets or sets the visibility.
`SetVisibility(value: SheetVisibility)`	Sets the visibility value.
`GetCells()` → `std::unordered_map<CellAddress, CellRecord>`	Gets the cells.
`GetCells()` → `std::unordered_map<CellAddress, CellRecord>`	Returns the cells.
`GetRows()` → `std::unordered_map<int, RowModel>`	Gets the rows.
`GetRows()` → `std::unordered_map<int, RowModel>`	Returns the rows.
`GetColumns()` → `std::vector<ColumnRangeModel>`	Gets the columns.
`GetColumns()` → `std::vector<ColumnRangeModel>`	Returns the columns.
`GetMergeRegions()` → `std::vector<MergeRegion>`	Gets the merge regions.
`GetMergeRegions()` → `std::vector<MergeRegion>`	Returns the merge regions.
`GetHyperlinks()` → `std::vector<HyperlinkModel>`	Gets the hyperlinks.
`GetHyperlinks()` → `std::vector<HyperlinkModel>`	Returns the hyperlinks.
`GetValidations()` → `std::vector<ValidationModel>`	Gets the validations.
`GetValidations()` → `std::vector<ValidationModel>`	Returns the validations.
`GetConditionalFormattings()` → `std::vector<ConditionalFormattingModel>`	Gets the conditional formattings.
`GetConditionalFormattings()` → `std::vector<ConditionalFormattingModel>`	Returns the conditional formattings.
`GetPageSetup()` → `PageSetupModel`	Gets the page setup.
`GetPageSetup()` → `PageSetupModel`	Returns the page setup.
`GetView()` → `WorksheetViewModel`	Gets the view.
`GetView()` → `WorksheetViewModel`	Returns the view.
`GetProtection()` → `WorksheetProtectionModel`	Gets the protection.
`GetProtection()` → `WorksheetProtectionModel`	Returns the protection.
`GetAutoFilter()` → `AutoFilterModel`	Gets the auto filter.
`GetAutoFilter()` → `AutoFilterModel`	Returns the auto filter.
`GetTabColor()` → `std::optional<ColorValue>`	Gets or sets the tab color.
`SetTabColor(value: std::optional<ColorValue>)`	Sets the tab color value.

WorksheetModel

Overview

Accessor Methods

Methods

See Also