Le feuilleton

Vue de l’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 accessorielles

NameTypeAccessDescription
WorksheetWorksheetReadGets the worksheet.

méthodes

SignatureDescription
Worksheet()WorksheetCalls Worksheet on this Worksheet instance.
Worksheet()
GetModel()Core::WorksheetModelGets the underlying worksheet model.
GetModel()Core::WorksheetModelReturns the model.
GetWorkbook()WorkbookGets the parent workbook.
GetWorkbook()WorkbookReturns the workbook.
GetName()std::stringGets or sets the worksheet name.
SetName(value: std::string_view)Sets the name value.
GetVisibilityType()VisibilityTypeGets or sets the worksheet visibility state.
SetVisibilityType(value: VisibilityType)Sets the visibility type value.
GetTabColor()ColorGets or sets the worksheet tab color.
SetTabColor(value: Color)Sets the tab color value.
GetShowGridlines()boolGets or sets whether gridlines are shown in the worksheet view.
SetShowGridlines(value: bool)Sets the show gridlines value.
GetShowRowColumnHeaders()boolGets or sets whether row and column headers are shown in the worksheet view.
SetShowRowColumnHeaders(value: bool)Sets the show row column headers value.
GetShowZeros()boolGets or sets whether zero values are shown in the worksheet view.
SetShowZeros(value: bool)Sets the show zeros value.
GetRightToLeft()boolGets or sets whether the worksheet view is right-to-left.
SetRightToLeft(value: bool)Sets the right to left value.
GetZoom()intGets or sets the worksheet zoom percentage.
SetZoom(value: int)Sets the zoom value.
GetCells()CellsGets the cell grid facade for the worksheet.
GetCells()CellsReturns the cells.
GetHyperlinks()HyperlinkCollectionGets the worksheet hyperlink collection.
GetHyperlinks()HyperlinkCollectionReturns the hyperlinks.
GetValidations()ValidationCollectionGets the worksheet data validation collection.
GetValidations()ValidationCollectionReturns the validations.
GetConditionalFormattings()ConditionalFormattingCollectionGets the worksheet conditional formatting collection.
GetConditionalFormattings()ConditionalFormattingCollectionReturns the conditional formattings.
GetPageSetup()PageSetupGets page setup settings for the worksheet.
GetPageSetup()PageSetupReturns the page setup.
GetProtection()WorksheetProtectionGets worksheet protection settings.
GetProtection()WorksheetProtectionReturns the protection.
GetAutoFilter()AutoFilterGets auto-filter settings for the worksheet.
GetAutoFilter()AutoFilterReturns 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
 Français