GrapeCity.Xaml.Excel
IExcelWorksheet Interface Members
Properties  Methods 

GrapeCity.Excel Namespace : IExcelWorksheet Interface

The following tables list the members exposed by IExcelWorksheet.

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

Reference

IExcelWorksheet Interface
GrapeCity.Excel Namespace