Add(String,XLSheet,Int32,Int32,Int32,Int32) Method

Creates an XLNamedRange object and appends it to the collection.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Add( _
   ByVal name As System.String, _
   ByVal sheet As XLSheet, _
   ByVal rowIndex As System.Integer, _
   ByVal colIndex As System.Integer, _
   ByVal rowCount As System.Integer, _
   ByVal colCount As System.Integer _
) As XLNamedRange

public XLNamedRange Add( 
   System.string name,
   XLSheet sheet,
   System.int rowIndex,
   System.int colIndex,
   System.int rowCount,
   System.int colCount
)

Parameters

name: The name of XLNamedRange object.
sheet: The worksheet containing the range.
rowIndex: The index of the top row in the cell range.
colIndex: The index of the left column in the cell range.
rowCount: The number of rows in the cell range.
colCount: The number of columns in the cell range.

Return Value

A reference to the object if it was successfully added to the collection, or null if the object could not be added (usually because it overlaps another cell range already in the collection).

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

XLNamedRangeCollection Class
XLNamedRangeCollection Members
Overload List