Name | Description | |
---|---|---|
![]() | Background | Gets or sets the background bitmap (image) of the XLSheet. |
![]() | Book | Gets a reference to the C1XLBook that owns the sheet. |
![]() | CodeName | Gets or sets the code name of the XLSheet. Is need for VBA operations. |
![]() | ColumnMaxLevel | Gets maximum outline level for columns. |
![]() | Columns | Gets a reference to sheet's column collection. |
![]() | Comments | Gets an XLCommentCollection that contains the collection of comments that on the sheet. |
![]() | ConditionalFormattings | Gets the collection of XLConditionalFormatting objects for the current workbook. |
![]() | DataValidations | Gets the collection of XLDataValidation objects for the current workbook. |
![]() | DefaultColumnWidth | Gets or sets the default column width for the sheet (in twips). |
![]() | DefaultRowHeight | Gets or sets the default row height for the sheet (in twips). |
![]() | GridColor | Gets or sets the color used to display grid lines. |
![]() | Item | Gets the cell at a specified position on the sheet, creating a new cell if necessary. |
![]() | Locked | Gets or sets a value that determines if the sheet is locked for editing. |
![]() | MaxOutlineLevel | Gets the maximum subtotals outline level for rows or columns. |
![]() | MergedCells | Gets an XLCellRangeCollection that contains the collection of cells that are merged on the sheet. |
![]() | Name | Gets or sets the name of the XLSheet. |
![]() | OutlinesBelow | Gets or sets a value indicating the vertical location of outline buttons. |
![]() | OutlinesRight | Gets or sets a value indicating the horizontal location of outline buttons. |
![]() | PageBreakPreview | Gets or sets whether Excel should show page break preview when displaying the sheet. |
![]() | PrintSettings | Gets or sets an XLPrintSettings object that controls how the sheet is printed. |
![]() | RowMaxLevel | Gets maximum outline level for rows. |
![]() | Rows | Gets a reference to the sheet's row collection. |
![]() | Scale | Gets or sets the view scale of this worksheet using percentages. |
![]() | ScaleNormal | Gets or sets the view scale for normal view of this worksheet using percentages. |
![]() | SelectedCells | Gets an XLCellRangeCollection that contains the collection of cells that are selected on the sheet. |
![]() | Shapes | Gets a reference to the ShapeCollection for the sheet. |
![]() | ShowGridLines | Gets or sets whether Excel should show the grid lines when displaying the sheet. |
![]() | ShowHeaders | Gets or sets whether Excel should show the row and column headers when displaying the sheet. |
![]() | ShowZeros | Gets or sets whether Excel should show the zero values on the sheet. |
![]() | TabColor | Gets or sets the color used to display the tab of this sheet. |
![]() | TotalsBelowData | Gets whether Excel should show the subtotals data when displaying the sheet. |
![]() | ViewLayout | Gets or sets whether Excel should show view layout (preview) when displaying the sheet. |
![]() | Visible | Gets or sets the sheet's visibility. |