Spread WPF Documentation
IExcelWorksheet Interface Members
Properties  Methods 

GrapeCity.Excel Namespace : IExcelWorksheet Interface

The following tables list the members exposed by IExcelWorksheet.

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

Reference

IExcelWorksheet Interface
GrapeCity.Excel Namespace