Spread Windows Forms 18
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IWorksheet Interface
Properties Methods

In This Topic
    IWorksheet Interface Members
    In This Topic

    The following tables list the members exposed by IWorksheet.

    Public Properties
     NameDescription
    PropertyActiveCellGets an IRange object that represents the active cell.  
    PropertyAutoFilterGets an IAutoFilter object if filtering is on.  
    PropertyAutoFilterModeGets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.  
    PropertyAutoUpdateFilterGets or sets a value indicating whether the filter will update automatically after user input new value.  
    PropertyBehaviorsGets or sets the behaviors of operations.  
    PropertyButtonsGets the list of button controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyCellsGets an IRange object which represents the entire worksheet cells (not just the cells that are currently in use).  
    PropertyChartObjectsGets an GrapeCity.Spreadsheet.Charts.IChartObjects object that represents a collection of all the embedded charts on the sheet.  
    PropertyCheckBoxesGets the list of check box controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyCircularReferenceGets an IRange object that represents the range containing the first circular reference on the worksheet, or returns null if there's no circular reference on the worksheet.  
    PropertyColumnCountGets or sets the number of columns in this IWorksheet.  
    PropertyColumnFooterGets the column footer of a worksheet.  
    PropertyColumnHeaderGets the column header of a worksheet.  
    PropertyColumnsGet an IRange object that represents all the columns on the worksheet.  
    PropertyCommentsGets an IComments collection that represents all the comments for the specified worksheet.  
    PropertyCommentsThreadedGets an ICommentsThreaded collection that represents all the top-level/root comments (no replies) for the specified worksheet. Includes legacy and modern comments.  
    PropertyCustomPropertiesGets a GrapeCity.Core.ICustomProperties object representing the identifier information associated with a worksheet.  
    PropertyDataManagerGets the data manager of this worksheet.  
    PropertyDisplayPageBreaksGets or sets a value indicating whether the page breaks (both automatic and manual) on this worksheet are displayed.  
    PropertyDropDownsGets the list of combo box controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyEnableSelectionGets or sets what can be selected on the sheet.  
    PropertyGroupBoxesGets the list of group box controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyHyperlinksGets an IHyperlinks collection that represents the hyperlinks for the worksheet.  
    PropertyIndexGets an integer value that represents the index number of the worksheet within the collection.  
    PropertyLabelsGets the list of label controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyListBoxesGets the list of list box controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyNameGets or sets a string value representing the name of the sheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyNamesGets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).  
    PropertyNextGets an ISheet object that represents the next sheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyOptionButtonsGets the list of option button controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyOptionsGets the WorksheetOptions object that represents all options of the IWorksheet.  
    PropertyOutlineGets an IOutline object that represents the outline for the specified worksheet.  
    PropertyOwnerGets the owner worksheet.  
    PropertyPageSetupGets the page setup of the sheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyPicturesGets a collection of all the GrapeCity.Spreadsheet.Drawing.IPicture objects on this IWorksheet.  
    PropertyPreviousGets an ISheet object that represents the previous sheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyProtectDrawingObjectsGets a boolean value indicating whether shapes are protected. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyProtectionGets an IProtection object that represents the protection options of the worksheet.  
    PropertyProtectionModeGets a value indicates whether user-interface-only protection is turned on. To turn on user interface protection, use the %Protect(WorksheetLocks, string)% method. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyRowCountGets or sets the number of rows in this IWorksheet.  
    PropertyRowHeaderGets the row header of a worksheet.  
    PropertyRowsGet an IRange object that represents all the rows on the worksheet.  
    PropertyScrollBarsGets the list of scroll bar controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertySelectionGets the current selected cell(s).  
    PropertyShapesGets a collection of all the GrapeCity.Spreadsheet.Drawing.IShape objects on this IWorksheet.  
    PropertySlicersGets the GrapeCity.Spreadsheet.Slicers.ISlicers collection that contains the collection of GrapeCity.Spreadsheet.Slicers.ISlicer objects in the specified IWorksheet.  
    PropertySortGets the sort object.  
    PropertySpinnersGets the list of spin button controls of this IWorksheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyStandardHeightGets or sets the standard (default) height of all the rows on the worksheet.  
    PropertyStandardWidthGets or sets the standard (default) width of all the columns on the worksheet.  
    PropertyStylesGets a IWorksheetStyles collection that represents all the styles in the worksheet.  
    PropertySubTypeGets the worksheet sub-type.  
    PropertyTabColorGets or sets the color of the tab. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyTablesGets the ITables object which manages all tables in this IWorksheet.  
    PropertyTypeGets the worksheet type. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyUsedRangeGets an IRange object that represents the used range on the specified worksheet.  
    PropertyViewGets the worksheet view of this IWorksheet object.  
    PropertyVisibleGets or sets a SheetVisibility value that determines whether the sheet is visible. (Inherited from GrapeCity.Spreadsheet.ISheet)
    PropertyWorkbookGets the Workbook object contains current IWorksheet object. (Inherited from GrapeCity.Spreadsheet.ISheet)
    Top
    Public Methods
     NameDescription
    MethodActivateMakes the current sheet the active sheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    MethodCalculateCalculates this worksheet.  
    MethodCircleInvalidOverloaded. Circles invalid entries on the worksheet.  
    MethodClearCirclesClears circles from invalid entries on the worksheet.  
    MethodCopyCopies this ISheet to the specified position in the ISheet collection of the IWorkbook. (Inherited from GrapeCity.Spreadsheet.ISheet)
    MethodDeleteDeletes this ISheet from its owner IWorkbook. (Inherited from GrapeCity.Spreadsheet.ISheet)
    MethodGetValueGets raw data from the specified cell on this sheet.  
    MethodInsertColumnsInserts column(s) to the Worksheet at the specified position.  
    MethodInsertRowsInserts row(s) to the Worksheet at the specified position.  
    MethodMoveMoves this ISheet to the specified position in the ISheet collection of the IWorkbook. (Inherited from GrapeCity.Spreadsheet.ISheet)
    MethodPasteOverloaded. Pastes the contents of the Clipboard onto the sheet.  
    MethodProtectProtects a sheet so that it cannot be modified.  
    MethodRangeOverloaded. Get an IRange object that represents a cell or a range of cells.  
    MethodRemoveColumnsRemoves one or more columns starting with the column at the specified position.  
    MethodRemoveRowsRemoves one or more rows starting with the row at the specified position.  
    MethodSaveAsSaves this IWorksheet to the specified System.IO.Stream. (Inherited from GrapeCity.Spreadsheet.ISheet)
    MethodSelectSelects the sheet. (Inherited from GrapeCity.Spreadsheet.ISheet)
    MethodSetBackgroundPictureOverloaded. Sets the background graphic for a worksheet.  
    MethodSetValueOverloaded. Sets the System.Boolean value for the cell of the specified row and column.  
    MethodUnprotectUnprotects the sheet which is protected by password. (Inherited from GrapeCity.Spreadsheet.ISheet)
    Top
    See Also

    Reference

    IWorksheet Interface
    GrapeCity.Spreadsheet Namespace