Worksheet

Overview

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

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

Properties

NameTypeAccessDescription
WorksheetWorksheetRead

Methods

SignatureDescription
Worksheet()WorksheetConstructs a Worksheet wrapping the specified model within the given workbook. The parent workbook. The underlying worksheet model.
GetName()std::stringGets or sets the worksheet name.
SetName(value: std::string_view)
GetVisibilityType()VisibilityTypeGets or sets the worksheet visibility state.
SetVisibilityType(value: VisibilityType)
GetTabColor()ColorGets or sets the worksheet tab color.
SetTabColor(value: Color)
GetShowGridlines()boolGets or sets whether gridlines are shown in the worksheet view.
SetShowGridlines(value: bool)
GetShowRowColumnHeaders()boolGets or sets whether row and column headers are shown in the worksheet view.
SetShowRowColumnHeaders(value: bool)
GetShowZeros()boolGets or sets whether zero values are shown in the worksheet view.
SetShowZeros(value: bool)
GetRightToLeft()boolGets or sets whether the worksheet view is right-to-left.
SetRightToLeft(value: bool)
GetZoom()intGets or sets the worksheet zoom percentage.
SetZoom(value: int)
Protect()Marks the worksheet as protected using the current protection settings.
Unprotect()Clears worksheet protection and resets supported protection flags.

See Also