Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / Range Class

In This Topic
    Range Class Methods
    In This Topic

    For a list of all members of this type, see Range members.

    Public Methods
     NameDescription
    Public Methodactivate  
    Public MethodaddComment  
    Public MethodaddGrandTotalAboveForGroups  
    Public MethodaddGrandTotalBelowForGroups  
    Public MethodaddSubtotalAboveForGroupRev  
    Public MethodaddSubtotalBelowForGroup  
    Public MethodapplyStyleOverloaded.   
    Public MethodapplySubtotalToWorksheet  
    Public MethodautoFilterOverloaded.   
    Public MethodautoFit  
    Public Methodcalculate  
    Public Methodcharacters  
    Public Methodclear  
    Public MethodclearBorder  
    Public MethodclearComments  
    Public MethodclearContents  
    Public MethodclearFormats  
    Public MethodclearHyperlinks  
    Public MethodclearHyperLinks  
    Public MethodclearOutline  
    Public MethodcopyOverloaded.   
    Public MethodcountOfTrailingEmptyRows  
    Public Methodcut  
    Public MethoddeleteOverloaded.   
    Public Methoddirty  
    Public Methoddistinct  
    Public MethodfindOverloaded. Finds specific information in a range.  
    Public MethodgetOverloaded.   
    Public MethodgetAddIndent  
    Public MethodgetAddressOverloaded.   
    Public MethodgetArea  
    Public MethodgetAreaCount  
    Public MethodgetAreas  
    Public MethodgetBindingPath  
    Public MethodgetBorders  
    Public MethodgetCellPadding  
    Public MethodgetCellRects  
    Public MethodgetCells  
    Public MethodgetCellType  
    Public MethodgetColumn  
    Public MethodgetColumnCount  
    Public MethodgetColumns  
    Public MethodgetColumnWidth  
    Public MethodgetColumnWidthInPixel  
    Public MethodgetComment  
    Public MethodgetCount  
    Public Methodstatic (Shared in Visual Basic)GetCultureProvider  
    Public MethodgetCurrentArray  
    Public MethodgetDependents  
    Public MethodgetDisplayFormat  
    Public MethodgetEntireColumn  
    Public MethodgetEntireMergeArea  
    Public MethodgetEntireRow  
    Public MethodGetExtensionStyle  
    Public MethodgetFont  
    Public MethodgetFormatConditions  
    Public MethodgetFormula  
    Public MethodgetFormulaArray  
    Public MethodgetFormulaArrayR1C1  
    Public MethodgetFormulaHidden  
    Public MethodgetFormulaR1C1  
    Public MethodgetHasArray  
    Public MethodgetHasFormula  
    Public MethodgetHasValidationReturns true if any of the cells represented by this range have data validation associated with them.  
    Public MethodgetHeight  
    Public MethodgetHeightInPixel  
    Public MethodgetHidden  
    Public MethodgetHorizontalAlignment  
    Public MethodgetHyperlinks  
    Public MethodgetIndentLevel  
    Public MethodgetInterior  
    Public MethodgetLabelOptions  
    Public MethodgetLastColumn  
    Public MethodgetLastRow  
    Public MethodgetLocked  
    Public MethodgetMergeArea  
    Public MethodgetMergeCells  
    Public MethodgetNumberFormat  
    Public MethodgetOrientation  
    Public MethodgetOriginalCellRects  
    Public MethodgetOutlineLevelSpecifies the outline level; OutlineLevel is 1 for the API and 0 for module data and openxml.  
    Public MethodgetPrecedents  
    Public MethodgetReadingOrder  
    Public MethodgetRichText  
    Public MethodgetRow  
    Public MethodgetRowCount  
    Public MethodgetRowHeight  
    Public MethodgetRowHeightInPixel  
    Public MethodgetRows  
    Public MethodgetShowDetail  
    Public MethodgetShrinkToFit  
    Public MethodgetSparklineGroups  
    Public MethodgetStyle  
    Public MethodgetStyleData  
    Public MethodgetSummary  
    Public MethodgetTag  
    Public MethodgetText  
    Public MethodgetUseStandardHeight  
    Public MethodgetUseStandardWidth  
    Public MethodgetValidation  
    Public MethodgetValidationIsSameReturns true if the validation options of all cells represented by this IRange are the same; otherwise, false is returned.  
    Public MethodgetValue  
    Public MethodgetVerticalAlignment  
    Public MethodgetWatermark  
    Public MethodgetWidth  
    Public MethodgetWidthInPixel  
    Public MethodgetWorksheet  
    Public MethodgetWrapText  
    Public Methodgroup  
    Public MethodgroupByNearestValues  
    Public MethodinsertOverloaded.   
    Public MethodintersectsWithTable  
    Public MethodisRichText  
    Public Methoditerator  
    Public MethodmergeOverloaded.   
    Public MethodorderDescendingOverloaded.   
    Public MethodremoveSubtotal  
    Public MethodremoveSubtotalInternal  
    Public MethodreplaceOverloaded. Search in formulas and replace. Using this method doesn't change either the selection or the active cell.  
    Public Methodselect  
    Public MethodsetAddIndent  
    Public MethodsetBindingPath  
    Public MethodsetCellPadding  
    Public MethodsetCellType  
    Public MethodsetColumnWidth  
    Public MethodsetColumnWidthInPixel  
    Public MethodsetFormula  
    Public MethodsetFormulaArray  
    Public MethodsetFormulaArrayR1C1  
    Public MethodsetFormulaHidden  
    Public MethodsetFormulaR1C1  
    Public MethodsetHidden  
    Public MethodsetHorizontalAlignment  
    Public MethodsetIndentLevel  
    Public MethodsetLocked  
    Public MethodsetMergeCells  
    Public MethodsetNumberFormat  
    Public MethodsetOrientation  
    Public MethodsetOutlineLevel  
    Public MethodsetOwner  
    Public MethodsetReadingOrder  
    Public MethodsetRowHeight  
    Public MethodsetRowHeightInPixel  
    Public MethodsetShowDetail  
    Public MethodsetShrinkToFit  
    Public MethodsetStyle  
    Public MethodsetTag  
    Public MethodsetUseStandardHeight  
    Public MethodsetUseStandardWidth  
    Public MethodsetValue  
    Public MethodsetVerticalAlignment  
    Public MethodsetWatermark  
    Public MethodsetWorksheet  
    Public MethodsetWrapText  
    Public MethodsortOverloaded.   
    Public MethodspecialCellsOverloaded.   
    Public MethodsqueezeSubtotalLabel  
    Public MethodsubtotalOverloaded.   
    Public MethodsubtotalInternal  
    Public MethodtoImageOverloaded.   
    Public MethodtoStringOverloaded.   
    Public MethodtranslateSubtotalFunction  
    Public Methodungroup  
    Public Methodunmerge  
    Public MethodUpdateExtensionStyle  
    Top
    See Also

    Reference

    Range Class
    com.grapecity.documents.excel Package

     

     

    Copyright © 2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page