Spread Windows Forms 15.0
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.  
    PropertyBehaviorsGets or sets the behaviors of operations.  
    PropertyCellsGets an IRange object which represents the entire worksheet cells (not just the cells that are currently in use).  
    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.  
    PropertyDataManagerGets the data manager of this worksheet.  
    PropertyHyperlinksGets an IHyperlinks collection that represents the hyperlinks for the worksheet.  
    PropertyIndexGets the index number of the worksheet within the collection of worksheets.  
    PropertyNameGets or sets the name of worksheet.  
    PropertyNamesGets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).  
    PropertyNextGets an IWorksheet object that represents the next sheet.  
    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.  
    PropertyPicturesGets a collection of all the GrapeCity.Spreadsheet.Drawing.IPicture objects on this IWorksheet.  
    PropertyPreviousGets an IWorksheet object that represents the previous sheet.  
    PropertyProtectionModeGets a value indicates whether user-interface-only protection is turned on. To turn on user interface protection, use the Protect method.  
    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.  
    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.  
    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.  
    PropertyTablesGets the ITables object which manages all tables in this IWorksheet.  
    PropertyTypeGets the worksheet type.  
    PropertyUsedRangeGets an IRange object that represents the used range on the specified worksheet.  
    PropertyViewGets the worksheet view of this Worksheet object.  
    PropertyVisibleGets or sets a SheetVisibility value that determines whether the worksheet is visible.  
    PropertyWorkbookGets the Workbook object contains current Worksheet object.  
    Top
    Public Methods
     NameDescription
    MethodActivateMakes the current sheet the active sheet.  
    MethodCalculateCalculates this worksheet.  
    MethodCircleInvalidOverloaded. Circles invalid entries on the worksheet.  
    MethodClearCirclesClears circles from invalid entries on the worksheet.  
    MethodCopyCopies this IWorksheet to the specified position in the IWorksheet collection of the Workbook.  
    MethodDeleteDeletes this IWorksheet from its owner Workbook.  
    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 IWorksheet to the specified position in the IWorksheet collection of the Workbook.  
    MethodPasteOverloaded. Pastes the contents of the Clipboard onto the sheet.  
    MethodProtectProtects a worksheet 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.  
    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 worksheet which is protected by password.  
    Top
    See Also

    Reference

    IWorksheet Interface
    GrapeCity.Spreadsheet Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page