Spread Silverlight Documentation
GrapeCity.Excel Namespace / ExcelWorksheet Class
Properties Methods

In This Topic
    ExcelWorksheet Class Members
    In This Topic

    The following tables list the members exposed by ExcelWorksheet.

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