TXlsNamedRange.TXlsNamedRange Constructor
Overloads
- TXlsNamedRange.TXlsNamedRange
- TXlsNamedRange.TXlsNamedRange(String, Int32, Int32, String)
- TXlsNamedRange.TXlsNamedRange(String, Int32, Int32, Int32, Int32, Int32, Int32, Int32)
- TXlsNamedRange.TXlsNamedRange(String, Int32, Int32, Int32, Int32, Int32, Int32, Int32, String)
TXlsNamedRange.TXlsNamedRange
Creates an empty NamedRange.
Syntax
Namespace: FlexCel.Core
public TXlsNamedRange()
See also
TXlsNamedRange.TXlsNamedRange(String, Int32, Int32, String)
Creates a complex Named range, with a formula.
Syntax
Namespace: FlexCel.Core
public TXlsNamedRange(String aName, Int32 aNameSheetIndex, Int32 aOptionFlags, String aRangeFormula)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
aName | String | Name of the range. | |
aNameSheetIndex | Int32 | Sheet index for the sheet that holds the range. 0 means a global range (default on Excel) | |
aOptionFlags | Int32 | Options of this Range. | |
aRangeFormula | String | The formula for the range, expressed as text. For example: "A1:B2,C3:C7" Note that with relative references, we always consider "A1" to be the cell where the name is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula. For example "=A1048575" will evaluate to B7 when evaluated in B8. |
See also
TXlsNamedRange.TXlsNamedRange(String, Int32, Int32, Int32, Int32, Int32, Int32, Int32)
Creates a new Named range with the given values. Use this overload to create a simple range.
Syntax
Namespace: FlexCel.Core
public TXlsNamedRange(String aName, Int32 aNameSheetIndex, Int32 aSheetIndex, Int32 aFirstRow, Int32 aFirstCol, Int32 aLastRow, Int32 aLastCol, Int32 aOptionFlags)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
aName | String | Name of the range. | |
aNameSheetIndex | Int32 | Sheet index for the sheet that holds the range. 0 means a global range (default on Excel) | |
aSheetIndex | Int32 | Sheet index where the range apply. This is where row and col properties apply, not where the range is stored. (1-based) | |
aFirstRow | Int32 | First row on range. | |
aFirstCol | Int32 | First column on range. | |
aLastRow | Int32 | Last row on range. | |
aLastCol | Int32 | Last column on range. | |
aOptionFlags | Int32 | Options of this Range. |
See also
TXlsNamedRange.TXlsNamedRange(String, Int32, Int32, Int32, Int32, Int32, Int32, Int32, String)
Creates a new Named range with the given values. Use this overload to create a simple range.
Syntax
Namespace: FlexCel.Core
public TXlsNamedRange(String aName, Int32 aNameSheetIndex, Int32 aSheetIndex, Int32 aFirstRow, Int32 aFirstCol, Int32 aLastRow, Int32 aLastCol, Int32 aOptionFlags, String aRangeFormula)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
aName | String | Name of the range. | |
aNameSheetIndex | Int32 | Sheet index for the sheet that holds the range. 0 means a global range (default on Excel) | |
aSheetIndex | Int32 | Sheet index where the range apply. This is where row and col properties apply, not where the range is stored. (1-based) | |
aFirstRow | Int32 | First row on range. | |
aFirstCol | Int32 | First column on range. | |
aLastRow | Int32 | Last row on range. | |
aLastCol | Int32 | Last column on range. | |
aOptionFlags | Int32 | Options of this Range. | |
aRangeFormula | String | The formula for the range, expressed as text. Use it if the range is complex and cannot be expressed with aSheetIndex, aFirstRow... etc When you specify this parameter, all SheetIndex, aFirstRow, etc. lose their meaning. |