- GC
- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.DataCharts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.DataRange
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Sheets.GanttSheet
- Collaboration
- GC.Spread.Excel
GC.Spread.Sheets.DataRange.DataRangeManager
Class: DataRangeManager
Sheets.DataRange.DataRangeManager
Table of contents
Constructors
Methods
Constructors
constructor
• new DataRangeManager(sheet)
description Represents a data range manager.
Parameters
| Name | Type | Description |
|---|---|---|
sheet |
Worksheet |
The worksheet. |
Methods
add
▸ add(name, dataProvider, range, options?): DataRange
description Adds a data range.
Parameters
| Name | Type | Description |
|---|---|---|
name |
string |
The data range name. |
dataProvider |
string | IDataProvider |
The data provider. String type means the tableSheet name, it will create a TableSheetDataProvider. |
range |
Range |
The range of data range. |
options? |
IDataRangeOptions |
- |
Returns
The added data range.
all
▸ all(): DataRange[]
description Get all data ranges.
Returns
The array of data range instances. Default is empty array.
clear
▸ clear(): void
description Remove all data ranges.
Returns
void
get
▸ get(name): DataRange
description Gets a data range.
Parameters
| Name | Type | Description |
|---|---|---|
name |
string |
The data range name. |
Returns
The target data range.
remove
▸ remove(name): void
description Remove a data range.
Parameters
| Name | Type | Description |
|---|---|---|
name |
string |
The data range name. |
Returns
void