Worksheet

Overview

Worksheet is a class in Aspose.Cells FOSS for Java.

Represents a worksheet in a workbook.

Name	Type	Access	Description
`name`	`String`	Read	Returns the name.
`visibilityType`	`VisibilityType`	Read	Returns the visibility type.
`tabColor`	`Color`	Read	Returns the tab color.
`showGridlines`	`boolean`	Read	Returns the show gridlines.
`showRowColumnHeaders`	`boolean`	Read	Returns the show row column headers.
`showZeros`	`boolean`	Read	Returns the show zeros.
`rightToLeft`	`boolean`	Read	Returns the right to left.
`zoom`	`int`	Read	Returns the zoom.
`cells`	`Cells`	Read	Returns the cells.
`protection`	`WorksheetProtection`	Read	Returns the protection.
`pageSetup`	`PageSetup`	Read	Returns the page setup.
`validations`	`ValidationCollection`	Read	Returns the validations.
`hyperlinks`	`HyperlinkCollection`	Read	Returns the hyperlinks.
`autoFilter`	`AutoFilter`	Read	Returns the auto filter.
`conditionalFormattings`	`ConditionalFormattingCollection`	Read	Returns the conditional formattings.

Signature	Description
`getName()` → `String`	Returns the name.
`setName(name: String)`	Sets the name.
`getVisibilityType()` → `VisibilityType`	Returns the visibility type.
`setVisibilityType(visibilityType: VisibilityType)`	Sets the visibility type.
`getTabColor()` → `Color`	Returns the tab color.
`setTabColor(value: Color)`	Sets the tab color.
`getShowGridlines()` → `boolean`	Returns the show gridlines.
`setShowGridlines(value: boolean)`	Sets the show gridlines.
`getShowRowColumnHeaders()` → `boolean`	Returns the show row column headers.
`setShowRowColumnHeaders(value: boolean)`	Sets the show row column headers.
`getShowZeros()` → `boolean`	Returns the show zeros.
`setShowZeros(value: boolean)`	Sets the show zeros.
`getRightToLeft()` → `boolean`	Returns the right to left.
`setRightToLeft(value: boolean)`	Sets the right to left.
`getZoom()` → `int`	Returns the zoom.
`setZoom(value: int)`	Sets the zoom.
`getCells()` → `Cells`	Returns the cells.
`getProtection()` → `WorksheetProtection`	Returns the protection.
`getPageSetup()` → `PageSetup`	Returns the page setup.
`getValidations()` → `ValidationCollection`	Returns the validations.
`getHyperlinks()` → `HyperlinkCollection`	Returns the hyperlinks.
`getAutoFilter()` → `AutoFilter`	Returns the auto filter.
`getConditionalFormattings()` → `ConditionalFormattingCollection`	Returns the conditional formattings.
`protect()`	Enables protection for the current object.
`unprotect()`	Disables protection for the current object.