Worksheet

Overview

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

Encapsulates a single worksheet and its supported v0.1 worksheet features.

This class provides 38 methods for working with Worksheet objects in C++ programs. Available methods include: GetAutoFilter, GetCells, GetConditionalFormattings, GetHyperlinks, GetModel, GetName, GetPageSetup, GetProtection, GetRightToLeft, GetShowGridlines, GetShowRowColumnHeaders, GetShowZeros, and 16 additional methods. All public members are accessible to any C++ application after installing the Aspose.Cells FOSS for C++ package. Accessor methods: Worksheet.

Accessor Methods

Name	Type	Access	Description
`Worksheet`	`Worksheet`	Read	Gets the worksheet.

Methods

Signature	Description
`Worksheet()` → `Worksheet`	Calls Worksheet on this Worksheet instance.
`Worksheet()`
`GetModel()` → `Core::WorksheetModel`	Gets the underlying worksheet model.
`GetModel()` → `Core::WorksheetModel`	Returns the model.
`GetWorkbook()` → `Workbook`	Gets the parent workbook.
`GetWorkbook()` → `Workbook`	Returns the workbook.
`GetName()` → `std::string`	Gets or sets the worksheet name.
`SetName(value: std::string_view)`	Sets the name value.
`GetVisibilityType()` → `VisibilityType`	Gets or sets the worksheet visibility state.
`SetVisibilityType(value: VisibilityType)`	Sets the visibility type value.
`GetTabColor()` → `Color`	Gets or sets the worksheet tab color.
`SetTabColor(value: Color)`	Sets the tab color value.
`GetShowGridlines()` → `bool`	Gets or sets whether gridlines are shown in the worksheet view.
`SetShowGridlines(value: bool)`	Sets the show gridlines value.
`GetShowRowColumnHeaders()` → `bool`	Gets or sets whether row and column headers are shown in the worksheet view.
`SetShowRowColumnHeaders(value: bool)`	Sets the show row column headers value.
`GetShowZeros()` → `bool`	Gets or sets whether zero values are shown in the worksheet view.
`SetShowZeros(value: bool)`	Sets the show zeros value.
`GetRightToLeft()` → `bool`	Gets or sets whether the worksheet view is right-to-left.
`SetRightToLeft(value: bool)`	Sets the right to left value.
`GetZoom()` → `int`	Gets or sets the worksheet zoom percentage.
`SetZoom(value: int)`	Sets the zoom value.
`GetCells()` → `Cells`	Gets the cell grid facade for the worksheet.
`GetCells()` → `Cells`	Returns the cells.
`GetHyperlinks()` → `HyperlinkCollection`	Gets the worksheet hyperlink collection.
`GetHyperlinks()` → `HyperlinkCollection`	Returns the hyperlinks.
`GetValidations()` → `ValidationCollection`	Gets the worksheet data validation collection.
`GetValidations()` → `ValidationCollection`	Returns the validations.
`GetConditionalFormattings()` → `ConditionalFormattingCollection`	Gets the worksheet conditional formatting collection.
`GetConditionalFormattings()` → `ConditionalFormattingCollection`	Returns the conditional formattings.
`GetPageSetup()` → `PageSetup`	Gets page setup settings for the worksheet.
`GetPageSetup()` → `PageSetup`	Returns the page setup.
`GetProtection()` → `WorksheetProtection`	Gets worksheet protection settings.
`GetProtection()` → `WorksheetProtection`	Returns the protection.
`GetAutoFilter()` → `AutoFilter`	Gets auto-filter settings for the worksheet.
`GetAutoFilter()` → `AutoFilter`	Returns the auto filter.
`Protect()`	Marks the worksheet as protected using the current protection settings.
`Unprotect()`	Clears worksheet protection and resets supported protection flags.

Worksheet

Overview

Accessor Methods

Methods

See Also