GrapeCity.Xaml.SpreadSheet.Data
SetTag(Int32,Int32,Object) Method
Example 


The row index (set to -1 for all rows).
The column index (set to -1 for all columns).
The tag value for the specified cell, column, row, or sheet.
Sets the application-defined tag value for the specified cell, column, row, or entire sheet for the specified sheet area.
Syntax
'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.Xaml.SpreadSheet.Data.SheetArea.Cells, "test");
gcSpreadSheet1.Sheets[0].SetText(1, 1, "testing");
//gcSpreadSheet1.Sheets[0].SetText(1, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "Testing");
gcSpreadSheet1.Sheets[0].SetValue(2, 2, "ABC");
//gcSpreadSheet1.Sheets[0].SetValue(2, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "ABC");
//gcSpreadSheet1.Sheets[0].SetValue(2, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "ABC", true);
GcSpreadSheet1.Sheets(0).SetTag(0, 0, "test")
'GcSpreadSheet1.Sheets(0).SetTag(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "test")
GcSpreadSheet1.Sheets(0).SetText(1, 1, "testing")
'GcSpreadSheet1.Sheets(0).SetText(1, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "Testing")
GcSpreadSheet1.Sheets(0).SetValue(2, 2, "ABC")
'GcSpreadSheet1.Sheets(0).SetValue(2, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "ABC")
'GcSpreadSheet1.Sheets(0).SetValue(2, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "ABC", True)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

Worksheet Class
Worksheet Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options