SetClipValue Method (SheetView)
Sets a tab-delimited string that contains the unformatted text in a specified range.
'Declaration
Public Sub SetClipValue( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As String _
)
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value As String
instance.SetClipValue(row, column, rowCount, columnCount, value)
public void SetClipValue(
int ,
int column,
int ,
int columnCount,
string
)
Parameters
- row
- Starting row index, or -1 for all rows
- column
- Starting column index, or -1 for all columns
- rowCount
- Number of rows, or -1 for all rows (may create new rows as needed)
- columnCount
- Number of columns, or -1 for all columns (may create new columns as needed)
- value
- Tab-delimited string to set into the range
Return Value
Tab-delimited string containing the unformatted data in the range
This example gets a tab-delimited string containing the unformatted text in a range.