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 MethodapplyStyleOverloaded.   
    Public MethodautoFilterOverloaded.   
    Public MethodautoFit  
    Public Methodcharacters  
    Public Methodclear  
    Public MethodclearBorder  
    Public MethodclearComments  
    Public MethodclearContents  
    Public MethodclearFormats  
    Public MethodclearHyperlinks  
    Public MethodclearOutline  
    Public MethodcopyOverloaded.   
    Public Methodcut  
    Public MethoddeleteOverloaded.   
    Public MethodfindOverloaded. Finds specific information in a range.  
    Public MethodFindAspose  
    Public MethodFindMSExcelOverloaded. Finds specific information in a range.  
    Public MethodgetOverloaded.   
    Public MethodgetAddIndent  
    Public MethodgetArea  
    Public MethodgetAreaCount  
    Public MethodgetAreas  
    Public MethodgetBindingPath  
    Public MethodgetBorders  
    Public MethodgetCellRects  
    Public MethodgetCells  
    Public MethodgetCellType  
    Public MethodgetColumn  
    Public MethodgetColumnCount  
    Public MethodgetColumns  
    Public MethodgetColumnWidth  
    Public MethodgetColumnWidthInPixel  
    Public MethodgetComment  
    Public MethodgetCount  
    Public MethodgetCurrentArray  
    Public MethodgetDependents  
    Public MethodgetDisplayFormat  
    Public MethodgetEntireColumn  
    Public MethodgetEntireMergeArea  
    Public MethodgetEntireRow  
    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 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 MethodgetWidth  
    Public MethodgetWidthInPixel  
    Public MethodgetWorksheet  
    Public MethodgetWrapText  
    Public Methodgroup  
    Public MethodinsertOverloaded.   
    Public MethodisRichText  
    Public Methoditerator  
    Public MethodmergeOverloaded.   
    Public MethodremoveSubtotal  
    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 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 MethodsetWorksheet  
    Public MethodsetWrapText  
    Public MethodsortOverloaded.   
    Public MethodsubtotalOverloaded.   
    Public MethodtoImageOverloaded.   
    Public MethodtoStringOverloaded.   
    Public Methodungroup  
    Public Methodunmerge  
    Top
    See Also

    Reference

    Range Class
    com.grapecity.documents.excel Package

     

     

    Copyright ? 2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page