GrapeCity.Xaml.Excel
ExcelWorksheet Class Members
Properties  Methods 


GrapeCity.Excel Namespace : ExcelWorksheet Class

The following tables list the members exposed by ExcelWorksheet.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public Property Gets or sets the index of the active column.  
Public Property Gets or sets the index of the active row.  
Public Property Actual total columns count used by the current worksheet  
Public Property Actual total rows count used by the current worksheet  
Public Property Gets or sets the auto filter used in the worksheet.  
Public Property Get or set the column count.  
Public Property Gets or sets the column gutter.  
Public Property Gets or sets the column max outline level.  
Public Property Gets or sets the conditional formats used in the worksheet.  
Public Property Gets or sets the default width of the column.  
Public Property Gets or sets the default height of the row.  
Public Property Gets or sets the default viewport information of the worksheet.  
Public Property Gets the excel charts.  
Public Property Gets the excel images.  
Public Property Gets or sets the extended formats for the worksheet.  
Public Property Gets or sets the frozen column count.  
Public Property Gets or sets the frozen row count.  
Public Property Gets or sets the color of the grid line.  
Public Property Gets or sets a value indicating whether this instance is locked.  
Public Property Gets or sets a value indicating whether this instance is visible.  
Public PropertyGet the ExcelCell at the specified by row and column.  
Public Property Gets or sets the merged cells information.  
Public PropertyGets or sets the name of the ExcelWorksheet.  
Public Property Gets or sets the named cell ranges information  
Public Property Gets or sets the print area information of the worksheet.  
Public Property Gets or sets the print settings of the sheet.  
Public Property Gets or sets the print title information of the worksheet.  
Public Property Gets or sets a value indicating whether the sheet is in 'right to left' display mode  
Public Property Get or set the row count.  
Public Property Gets or sets the row gutter.  
Public Property Gets or sets the row max outline level.  
Public Property Gets the selection information.  
Public Property Gets or sets the color of the sheet tab.  
Public Property Gets or sets a value indicating whether this sheet should display formulas.  
Public Property Gets or sets a value indicating whether show gridlines or not.  
Public Property Gets or sets a value indicating whether show headers.  
Public Property Gets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value.  
Public Property Gets or sets the groups of sparklines on the sheet.  
Public Property Get or set the direction of the summary columns.  
Public Property Get or set the direction of the summary rows.  
Public Property Gets or set the zoom factor of the entire ExcelWorksheet.  
Top
Public Methods
 NameDescription
Public Method Adds the chart.  
Public Method Gets the cell at the specified row and column.  
Public Method Gets the column at the specified column index  
Public Method Gets the all data validation setting in the worksheet.  
Public Method Gets the non empty cells.  
Public Method Gets the non-empty columns.  
Public Method Gets the non-empty rows.  
Public Method Gets the row at the specified column index  
Public Method Returns all charts defined in the current worksheet.  
Public Method Returns all images defined in the current worksheet.  
Public Method Returns all tables defined in the current worksheet.  
Public Method Gets the range of cells that are spanned at a specified cell in this sheet.  
Public Method Get the location of the top left visible cell in the current sheet  
Public Method Sets the value of the cell.  
Public Method Initialize the column at the specified index.  
Public Method Sets the data validation used in the worksheet  
Public Method Add a chart to the current worksheet.  
Public Method Add a image to the current worksheet.  
Public Method Add a sheet table to the current worksheet.  
Public Method Set the location of the top left visible cell in the current sheet  
Public Method Sets the value of the cell.  
Top
See Also

Reference

ExcelWorksheet Class
GrapeCity.Excel Namespace