C1.Silverlight.Excel Namespace : XLSheet Class |
The following tables list the members exposed by XLSheet.
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. |
![]() | 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. |
![]() | 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. |
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. |
![]() | Load | Overloaded. Loads the Excel worksheet from a file. |
![]() | LoadCsv | Overloaded. Loads data from a file containing comma-separated values (.csv) into the current sheet. |
![]() | SaveCsv | Overloaded. Saves data from the current sheet into a comma-separated values (.csv) formatted file. |