接口的使用
com.grapecity.documents.excel.IRange

使用IRange的程序包

程序包	说明
com.grapecity.documents.excel
com.grapecity.documents.excel.drawing
com.grapecity.documents.excel.forms

com.grapecity.documents.excel中IRange的使用

返回IRange的com.grapecity.documents.excel中的方法

修饰符和类型	方法	说明
IRange	IRange.find(Object what)	Finds specific information in a range, starts from the upper-left corner.
IRange	IRange.find(Object what, FindOptions options)	Finds specific information in a range, starts from the upper-left corner.
IRange	IRange.find(Object what, IRange after)	Finds specific information in a range.
IRange	IRange.find(Object what, IRange after, FindOptions options)	Finds specific information in a range.
IRange	ICellCollection.get(int rowOffset, int columnOffset)	Gets the IRange object with the specified row and column offset.
IRange	ICellCollection.get(String reference)	Gets the IRange object with the specified reference.
IRange	IRange.get(int index)	Returns a new instance of IRange by index which represents a cell.
IRange	IRange.get(int rowOffset, int columnOffset)	Returns a new instance of IRange which is offset from this range.
IRange	IRangeProvider.get(int row, int column)	Gets the IRange object with the specified row and column.
IRange	IRangeProvider.get(int row, int column, int rowCount, int columnCount)	Gets the IRange object with the specified row and column.
IRange	IRangeProvider.get(String reference)	Gets the IRange object with the specified reference.
IRange	IWorksheet.getActiveCell()	Gets the active cell.
IRange	IComment.getAnchorCell()	Gets the anchor cell of the comment.
IRange	IAboveAverage.getAppliesTo()	Returns a range object specifying the cell range to which the formatting rule is applied.
IRange	IColorScale.getAppliesTo()	Returns a Range object that specifies the cell range to which the formatting rule is applied.
IRange	IDataBar.getAppliesTo()	Returns a Range object that specifies the cell range to which the formatting rule is applied.
IRange	IFormatCondition.getAppliesTo()	Returns the IRange object that specifies the cell range to which theformatting rule is applied.
IRange	IIconSetCondition.getAppliesTo()	Returns a Range object that specifies the cell range to which the formatting rule is applied.
IRange	ITop10.getAppliesTo()	Returns the IRange object that specifies the cell range to which theformatting rule is applied.
IRange	IUniqueValues.getAppliesTo()	Returns a Range object specifying the cell range to which the formatting rule is applied.
IRange	IAreas.getArea(int index)	Returns the zero based instance of IRange specified by index.
IRange	IRange.getCells()	Returns the IRange object that represents the cells in the specifiedrange.
IRange	IWorksheet.getCells()	Returns the IRange object that represents all the cells on theworksheet (not just the cells that are currently in use).
IRange	IPivotTable.getColumnRange()	Returns a Range object that represents the range that contains the column area in the PivotTable report.
IRange	IRange.getColumns()	Returns the IRange object that represents the columns in thespecified range.
IRange	IWorksheet.getColumns()	Returns the IRange object that represents all the columns on thespecified worksheet.
IRange	IRange.getCurrentArray()	Gets whether the specified cell is part of an array, returns an IRange object that represents the entire array.
IRange	IPivotTable.getDataBodyRange()	Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row.
IRange	ITableColumn.getDataBodyRange()	Returns the IRange object that is the size of the data portion of acolumn.
IRange	ITable.getDataRange()	Returns the IRange object that represents the range that contains thedata area in the table between the header row and the insert row.
IRange	IRange.getEntireColumn()	Returns a new instance of IRange which represents the same range ofcells, but expanded to include all rows.
IRange	IRange.getEntireMergeArea()	Returns an IRange representing the area of the current range which isiteratively grown as needed until it includes no partial merged cells.
IRange	IRange.getEntireRow()	Returns a new instance of IRange which represents the same range ofcells, but expanded to include all columns.
IRange	ITable.getHeaderRange()	Returns the IRange object that represents the range of the header rowfor a table.
IRange	ISortField.getKey()	Gets the sort range.
final IRange	SortFieldBase.getKey()	Specifies the column index.
IRange	IHPageBreak.getLocation()	Returns or sets the range that defines the page-break location.
IRange	ISparkline.getLocation()	Gets or sets the location of a single sparkline.
IRange	ISparklineGroup.getLocation()	Gets the IRange object that represents the location of the sparklinegroup.
IRange	IVPageBreak.getLocation()	Returns or sets the range that defines the page-break location.
IRange	IRange.getMergeArea()	Returns an IRange representing the merged range containing thespecified cell.
IRange	IPivotTable.getPageRange()	Returns a Range object that represents the range that contains the page area in the PivotTable report.
IRange	IAutoFilter.getRange()	Returns a Range object that represents the range to which the specified autoFilter applies.
IRange	IHyperlink.getRange()	Returns the IRange object that represents the range the specifiedhyperlink is attached to.
IRange	IPivotCell.getRange()	Returns a Range object that represents the range the specified PivotCell applies to.
IRange	ISort.getRange()	Gets the sort range.
IRange	ITable.getRange()	Returns the IRange object that represents the range to which thespecified table object applies.
IRange	ITableColumn.getRange()	Returns the IRange object that represents the range to which thespecified list object in the above list applies.
IRange	ITableRow.getRange()	Returns the IRange object that represents the range to which thespecified list object applies.
IRange	IWorksheet.getRange(int row, int column)	Gets the IRange object with the specified row and column.
IRange	IWorksheet.getRange(int row, int column, int rowCount, int columnCount)	Gets the IRange object with the specified row and column.
IRange	IWorksheet.getRange(String reference)	Gets the IRange object with the specified reference.
final IRange	PageContentInfo.getRange()	Returns the range to be printed.
final IRange	RangeEventArgs.getRange()	Represents the IRange of RangeEventArgs.
final IRange	RepeatSetting.getRange()	Returns an instance of IRange whose repeat settings are the same.
IRange	IPivotTable.getRowRange()	Returns a Range object that represents the range including the row area on the PivotTable report.
IRange	IRange.getRows()	Returns the IRange object that represents the rows in the specifiedrange.
IRange	IWorksheet.getRows()	Returns the IRange object that represents all the rows on thespecified worksheet.
IRange	IWorksheet.getSelection()	Gets the selection range.
IRange	IPivotCache.getSourceData()	Gets the data source for the PivotTable report.
IRange	IPivotTable.getTableRange1()	Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields.
IRange	IPivotTable.getTableRange2()	Returns a Range object that represents the range containing the entire PivotTable report, including page fields.
IRange	ITableColumn.getTotal()	Returns the Total row for the ITableColumn object.
IRange	ITable.getTotalsRange()	Returns the IRange object that represents the Total row, if any, froma specified ITable object.
IRange	IRange.getUsedRange()	Returns an IRange representing the used range in the current range.
IRange	IWorksheet.getUsedRange()	Gets the used range, its behavior is equivalent to getUsedRange(EnumSet.of(UsedRangeType.Axis, UsedRangeType.Data, UsedRangeType.Comment, UsedRangeType.Style, UsedRangeType.Merge))
IRange	IRange.intersect(IRange range2)	Returns an IRange object that represents the intersection of two ranges.
IRange	IRange.intersect(IRange... ranges)	Returns an IRange object that represents the intersection of several ranges.
IRange	IRange.offset(int rowOffset, int columnOffset)	Returns an IRange object that represents the offset of this range.
IRange	IRange.specialCells(SpecialCellType type)	Gets a IRange object that represents all the cells that match the specified type and value.
IRange	IRange.specialCells(SpecialCellType type, SpecialCellsValue value)	Gets a IRange object that represents all the cells that match the specified type and value.
IRange	IRange.union(IRange range2)	Returns an IRange object that represents the union of two ranges.
IRange	IRange.union(IRange... ranges)	Returns an IRange object that represents the union of several ranges.

参数类型为IRange的com.grapecity.documents.excel中的方法

修饰符和类型	方法	说明
IHPageBreak	IHPageBreaks.add(IRange before)	Adds a horizontal page break within the print area.
IHyperlink	IHyperlinks.add(IRange anchor, String address)	Adds a hyperlink to the specified range ( IHyperlink object).
IHyperlink	IHyperlinks.add(IRange anchor, String address, String subAddress, String screenTip, String textToDisplay)	Adds a hyperlink to the specified range ( IHyperlink object).
IPivotTable	IPivotTables.add(IPivotCache PivotCache, IRange TableDestination)	Adds a new PivotTable report.
IPivotTable	IPivotTables.add(IPivotCache PivotCache, IRange TableDestination, String TableName)	Adds a new PivotTable report.
IStyle	IStyleCollection.add(String name, IRange baseOn)	Creates a new IStyle and adds it to the list of styles that areavailable for the current IWorkbook.
ITable	ITables.add(IRange range)	Creates a table that includes the specified range of cells and returns the newly created object.
ITable	ITables.add(IRange range, boolean containsHeader)	Creates a table that includes the specified range of cells and returns the newly created object.
IVPageBreak	IVPageBreaks.add(IRange before)	Adds a vertical page break within the print area.
void	IRange.copy(IRange destination)	Copies the range to the specified range
void	IRange.copy(IRange destination, PasteOption pasteOption)	Copies the range to the specified range.
IPivotTable	IPivotCache.createPivotTable(IRange TableDestination)	Creates a PivotTable report based on a PivotCache object.
IPivotTable	IPivotCache.createPivotTable(IRange TableDestination, String TableName)	Creates a PivotTable report based on a PivotCache object.
void	IRange.cut(IRange destination)	Cuts the range to the specified range.
final void	PrintManager.draw(org.apache.pdfbox.pdmodel.PDDocument doc, org.apache.pdfbox.pdmodel.PDPage page, Point location, IRange range)	Draw the range data to the specific location in a specified pdf page.
final void	PrintManager.draw(org.apache.pdfbox.pdmodel.PDDocument doc, org.apache.pdfbox.pdmodel.PDPage page, Point location, IRange range, PdfSaveOptions options)	Draw the range data to the specific location in a specified pdf page.
final void	PrintManager.draw(org.apache.pdfbox.pdmodel.PDDocument doc, org.apache.pdfbox.pdmodel.PDPage page, Rectangle rect, IRange range)	Draw the range data to the specific location in a specified pdf page.
final void	PrintManager.draw(org.apache.pdfbox.pdmodel.PDDocument doc, org.apache.pdfbox.pdmodel.PDPage page, Rectangle rect, IRange range, PdfSaveOptions options)	Draw the range data to the specific location in a specified pdf page.
IRange	IRange.find(Object what, IRange after)	Finds specific information in a range.
IRange	IRange.find(Object what, IRange after, FindOptions options)	Finds specific information in a range.
String	IRange.generateGetPivotDataFunction(IRange destination)	Generate the corresponding function "GETPIVOTDATA" for the cells in the pivot table.
final PageContentInfo	PrintManager.generatePageContentInfo(IRange printArea, Size availableSize, int rowStart, int columnStart, boolean rowHeaderVisible, boolean columnHeaderVisible)	Returns a PageContentInfo object.
String	IRange.getAddress(boolean rowAbsolute, boolean columnAbsolute, ReferenceStyle referenceStyle, IRange relativeTo)	Returns a String value that represents the range reference.
static Rectangle	CellInfo.GetRangeBoundary(IRange range)	Gets the position and size (in pixels) of the specified range.
final Size	PrintManager.getSize(IRange range)	Returns the size of the range.
void	ISparklineGroups.group(IRange Location)	Groups the selected sparklines.
final boolean	PrintManager.hasPrintContent(IRange range)	Returns whether there has content to print.
IRange	IRange.intersect(IRange range2)	Returns an IRange object that represents the intersection of two ranges.
IRange	IRange.intersect(IRange... ranges)	Returns an IRange object that represents the intersection of several ranges.
boolean	RangeFindReplace.FindReplaceImpl.FindMatch.invoke(IRange range, Object what, String whatString, boolean useContains, boolean matchCase, boolean matchByte, IDisplayFormat searchFormat)
boolean	RangePartialClasses.FindReplaceImpl.FindMatch.invoke(IRange range, Object what, String whatString, boolean useContains, boolean matchCase, boolean matchByte, IDisplayFormat searchFormat)
void	ITable.resize(IRange range)	The Resize method allows the ITable object to be resized over a newrange.
void	IAboveAverage.setAppliesTo(IRange value)	Sets a range object specifying the cell range to which the formatting rule is applied.
void	IColorScale.setAppliesTo(IRange value)	Sets a Range object that specifies the cell range to which the formatting rule is applied.
void	IDataBar.setAppliesTo(IRange value)	Sets a Range object that specifies the cell range to which the formatting rule is applied.
void	IFormatCondition.setAppliesTo(IRange value)	Sets the IRange object that specifies the cell range to which theformatting rule is applied.
void	IIconSetCondition.setAppliesTo(IRange value)	Sets a Range object that specifies the cell range to which the formatting rule is applied.
void	ITop10.setAppliesTo(IRange value)	Sets the IRange object that specifies the cell range to which theformatting rule is applied.
void	IUniqueValues.setAppliesTo(IRange value)	Sets a Range object specifying the cell range to which the formatting rule is applied.
void	ISparkline.setLocation(IRange value)	Sets the location of a single sparkline.
void	ISparklineGroup.setLocation(IRange value)	Sets the IRange object that represents the location of the sparklinegroup.
void	ISort.setRange(IRange value)	Sets the sort range.
final void	PageContentInfo.setRange(IRange value)	Sets the range to be printed.
final void	RepeatSetting.setRange(IRange value)	Sets an instance of IRange whose repeat settings are the same.
void	IPivotCache.setSourceData(IRange value)	Sets the data source for the PivotTable report.
void	IRange.sort(IRange key, SortOrder order, SortOrientation orientation)	Sorts the cells represented by this range according to the specified options.
void	IRange.sort(IRange key, SortOrder order, SortOrientation orientation, boolean caseSensitive)	Sorts the cells represented by this range according to the specified options.
IRange	IRange.union(IRange range2)	Returns an IRange object that represents the union of two ranges.
IRange	IRange.union(IRange... ranges)	Returns an IRange object that represents the union of several ranges.

参数类型为IRange的com.grapecity.documents.excel中的构造器

限定符	构造器	说明
	CellColorSortField(IRange key, IInterior interior)	Sorts the interior based on color.
	CellColorSortField(IRange key, IInterior interior, SortOrder order)
	FontColorSortField(IRange key, Color color)	Sorts the font color.
	FontColorSortField(IRange key, Color color, SortOrder order)	Sorts the font color.
	IconSortField(IRange key, IIcon icon)	Sorts the icon.
	IconSortField(IRange key, IIcon icon, SortOrder order)	Sorts the icon.
	RangeEventArgs(IRange range)	Represents the construction.
	RangeTemplateCellType(IRange range)	Use a specific range to create a RangeTemplateCellType.
	ValueSortField(IRange key)	Specifies the normal construct method.
	ValueSortField(IRange key, SortOrder order)	Specifies the normal construct method.
	ValueSortField(IRange key, String customValues)	Specifies the custom sort construct method.

com.grapecity.documents.excel.drawing中IRange的使用

返回IRange的com.grapecity.documents.excel.drawing中的方法

修饰符和类型	方法	说明
IRange	IShape.getBottomRightCell()	Returns the IRange object that represents the cell that lies underthe lower-right corner of the object.
IRange	IShape.getTopLeftCell()	Returns the IRange object that represents the cell that lies underthe upper-left corner of the specified object.

参数类型为IRange的com.grapecity.documents.excel.drawing中的方法

修饰符和类型	方法	说明
void	ISeriesCollection.add(IRange source)	Adds one or more new series to the ISeriesCollection collection.Spread will determine where the values are by the size and orientation of the selected range.
void	ISeriesCollection.add(IRange source, RowCol rowCol)	Adds one or more new series to the ISeriesCollection collection.
void	ISeriesCollection.add(IRange source, RowCol rowCol, boolean seriesLabels, boolean categoryLabels)	Adds one or more new series to the ISeriesCollection collection.
IShape	IShapes.addCameraPicture(String reference, IRange range)	Creates a picture from reference range to the specified range on the current sheet.
IShape	IShapes.addCameraPicture(String reference, String name, IRange range)	Creates a picture from reference range to the specified range on the current sheet.
IShape	IShapes.addChart(ChartType chartType, IRange range)	Creates a chart at the specified range on the current sheet.
IShape	IShapes.addChart(String name, ChartType chartType, IRange range)	Creates a chart at the specified range on the current sheet.
IShape	IShapes.addConnector(ConnectorType type, IRange range)	Creates a connector at the specified range on the current sheet.
IShape	IShapes.addConnector(String name, ConnectorType type, IRange range)	Creates a connector at the specified range on the current sheet.
IShape	IShapes.addPicture(InputStream stream, ImageType type, IRange range)	Creates a picture from an existing stream at the specified range on the current sheet.
IShape	IShapes.addPicture(String filename, IRange range)	Creates a picture from an existing file at the specified range on the current sheet.
IShape	IShapes.addPicture(String name, InputStream stream, ImageType type, IRange range)	Creates a picture from an existing stream at the specified range on the current sheet.
IShape	IShapes.addPicture(String name, String filename, IRange range)	Creates a picture from an existing file at the specified range on the current sheet.
IShape	IShapes.addShape(AutoShapeType type, IRange range)	Returns the IShape object that represents the new AutoShapeat the specified range on the current sheet.
IShape	IShapes.addShape(String name, AutoShapeType type, IRange range)	Returns the IShape object that represents the new AutoShapeat the specified range on the current sheet.
void	ISeriesCollection.extend(IRange source, RowCol rowcol, boolean categoryLabels)	Adds new data points to an existing series collection.
void	IChart.setSourceData(IRange source)	Sets the source data range for the chart.
void	IChart.setSourceData(IRange source, RowCol plotBy)	Sets the source data range for the chart.

com.grapecity.documents.excel.forms中IRange的使用

返回IRange的com.grapecity.documents.excel.forms中的方法

修饰符和类型	方法	说明
IRange	IControl.getBottomRightCell()	Gets the bottom right cell of this control.
IRange	ISelector.getItemsSourceRange()	Represents the items source of this control.
IRange	ICellLinkControl.getLinkedCell()	Gets a cell reference to bind the Value property and theIRange.Value property of a cellwith the two-way binding mode
IRange	IControl.getTopLeftCell()	Gets the top left cell of this control.

参数类型为IRange的com.grapecity.documents.excel.forms中的方法

修饰符和类型	方法	说明
void	ISelector.setItemsSourceRange(IRange value)	Represents the items source of this control.
void	ICellLinkControl.setLinkedCell(IRange value)	Sets a cell reference to bind the Value property and theIRange.Value property of a cellwith the two-way binding mode