The following tables list the members exposed by XLSheet.
Public Properties
| Name | Description | |
|---|---|---|
 | Book | Gets a reference to the C1XLBook that owns the sheet. |
| 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. |
| 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 gridlines. |
| 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. |
| 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. |
| 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. |
| Visible | Gets or sets the sheet's visibility. |
Public Methods
| Name | Description | |
|---|---|---|
 | Clone | Creates a copy of this sheet. |
| CopyFormula | Copies the formula from a source cell to a destination cell, adjusting relative references. |
| GetCell | Gets a reference to a cell at the specified coordinates or null if the cell doesn't exist. |
| GetFormattedText | Gets formatted text is using XLStyle format value of the cell. |
| LoadAsync | Overloaded. Loads the Excel worksheet from a file storage. |
| LoadCsv | Loads data from a stream containing comma-separated values (.csv) into the current sheet. |
| LoadCsvAsync | Loads async data from a file containing comma-separated values (.csv) into the current sheet. |
| SaveCsv | Saves data from the current sheet into a comma-separated values (.csv) formatted stream. |
| SaveCsvAsync | Saves data from the current sheet into a comma-separated values (.csv) formatted file storage. |
See Also