Table of Contents

TXlsNamedRange.TXlsNamedRange Constructor

Overloads

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.

See also