Item(String) Property

Gets a new cell with a specified tag, or returns null if there is no cell with the specified tag.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads ReadOnly Property Item( _
   ByVal tag As System.String _
) As Cell

'Usage
 
Dim instance As Worksheet
Dim tag As System.String
Dim value As Cell
 
value = instance.Item(tag)

public Cell Item( 
   System.string tag
) {get;}

Parameters

tag: A specified tag that can be used to find a cell.

Property Value

A Cell object.

Example

This example uses the Item property.

gcSpreadSheet1.Sheets[0].Item(1, 1).Tag = "test";
gcSpreadSheet1.Sheets[0].Item("test").Text = "Item Tag";
gcSpreadSheet1.Sheets[0].Item(2, 2, 3, 3).Text = "Block";

VB.NET

GcSpreadSheet1.Sheets(0).Item(1, 1).Tag = "test"
GcSpreadSheet1.Sheets(0).Item("test").Text = "Item Tag"
GcSpreadSheet1.Sheets(0).Item(2, 2, 3, 3).Text = "Block"

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List