SetTag(Int32,Int32,Object) Method

In This Topic

Sets the application-defined tag value for the specified cell, column, row, or entire sheet for the specified sheet area.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetTag( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As Object _
)

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim value As Object
 
instance.SetTag(row, column, value)

public void SetTag( 
   int row,
   int column,
   object value
)

Parameters

row: The row index (set to -1 for all rows).
column: The column index (set to -1 for all columns).
value: The tag value for the specified cell, column, row, or sheet.

Example

This example uses the SetTag method.

gcSpreadSheet1.Sheets[0].SetTag(0, 0, "test");
//gcSpreadSheet1.Sheets[0].SetTag(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "test");
gcSpreadSheet1.Sheets[0].SetText(1, 1, "testing");
//gcSpreadSheet1.Sheets[0].SetText(1, 1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "Testing");
gcSpreadSheet1.Sheets[0].SetValue(2, 2, "ABC");
//gcSpreadSheet1.Sheets[0].SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC");
//gcSpreadSheet1.Sheets[0].SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC", true);

VB.NET

GcSpreadSheet1.Sheets(0).SetTag(0, 0, "test")
'GcSpreadSheet1.Sheets(0).SetTag(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "test")
GcSpreadSheet1.Sheets(0).SetText(1, 1, "testing")
'GcSpreadSheet1.Sheets(0).SetText(1, 1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "Testing")
GcSpreadSheet1.Sheets(0).SetValue(2, 2, "ABC")
'GcSpreadSheet1.Sheets(0).SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC")
'GcSpreadSheet1.Sheets(0).SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC", True)

Reference

Worksheet Class
Worksheet Members
Overload List

Product Support Forum | Print this page