Worksheet

Vue d’ensemble

« Workheet » est une classe dans Aspose.Cells FOSS pour C++.

Encapsule un seul feuillet de travail et ses fonctionnalités supportées v0.1.

Cette classe fournit 38 méthodes pour travailler avec des objets de feuille de travail dans les programmes C++. Les méthodologies disponibles comprennent: ‘GetAutoFilter’, ‘Cells’ , ‘BiencondicionalFormattings’, GatHyperlinks', ‘GitModel', ’GtName’, 'PageSetup', ‚GedProtection', ''GotRightToLeft', ‘’GetshowGridlines, ‘ShowRowColumnHeaders` et 16 méthode supplémentaires. Tous les membres publics sont accessibles à toute application C ++ après l’installation du package Aspose.Cell FOSS pour le pack C+.

Méthodes d’accès

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

méthodes

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.

Voir aussi

Aspose.Cells — référence API d’entreprise