GrapeCity.Spreadsheet.IWorksheet.SetValue

SetValue Method

SetValue(int, int, bool)

Sets the bool value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, bool value)

Function SetValue(row As Integer, column As Integer, value As Boolean) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
bool	value	An bool value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, byte)

Sets the int value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, byte value)

Function SetValue(row As Integer, column As Integer, value As Byte) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
byte	value	An byte value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, CalcError)

Sets the CalcError value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, CalcError value)

Function SetValue(row As Integer, column As Integer, value As CalcError) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
CalcError	value	An CalcError value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, DateTime)

Sets the DateTime value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, DateTime value)

Function SetValue(row As Integer, column As Integer, value As Date) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
DateTime	value	An DateTime value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, decimal)

Sets the int value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, decimal value)

Function SetValue(row As Integer, column As Integer, value As Decimal) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
decimal	value	An decimal value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, double)

Sets the double value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, double value)

Function SetValue(row As Integer, column As Integer, value As Double) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
double	value	An double value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, float)

Sets the int value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, float value)

Function SetValue(row As Integer, column As Integer, value As Single) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
float	value	An float value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int)

Sets the int value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, int value)

Function SetValue(row As Integer, column As Integer, value As Integer) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
int	value	An int value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, long)

Sets the int value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, long value)

Function SetValue(row As Integer, column As Integer, value As Long) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
long	value	An long value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, object)

Sets the object value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, object value)

Function SetValue(row As Integer, column As Integer, value As Object) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
object	value	An object value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, object[,])

Sets an object array into a specified range of cells.

Declaration

bool SetValue(int row, int column, object[,] values)

Function SetValue(row As Integer, column As Integer, values As Object(,)) As Boolean

Parameters

Type	Name	Description
int	row	Row index of the start of the range of cells
int	column	Column index of the start of the range of cells
object[,]	values	Two-dimensional object array[row,column] that contains the values

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, object[,], bool)

Sets an object array into a specified range of cells.

Declaration

bool SetValue(int row, int column, object[,] values, bool vertical)

Function SetValue(row As Integer, column As Integer, values As Object(,), vertical As Boolean) As Boolean

Parameters

Type	Name	Description
int	row	Row index of the start of the range of cells
int	column	Column index of the start of the range of cells
object[,]	values	Two-dimensional object array[row,column] that contains the values
bool	vertical	if True, array will be set follow column index, other, it will be set follow row index.

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, ref CellValue)

Sets the CellValue value for the cell of the specified row and column.

Declaration

void SetValue(int row, int column, ref CellValue cellValue)

Sub SetValue(row As Integer, column As Integer, ByRef cellValue As CellValue)

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
CellValue	cellValue	An CellValue value to set

SetValue(int, int, short)

Sets the int value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, short value)

Function SetValue(row As Integer, column As Integer, value As Short) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
short	value	An short value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, string)

Sets the string value for the cell of the specified row and column.

Declaration

bool SetValue(int row, int column, string value)

Function SetValue(row As Integer, column As Integer, value As String) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the row index of cell.
int	column	An integer value indicates the column index of cell.
string	value	An string value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue<T>(int, int, T[,])

Sets an object array into a specified range of cells.

Declaration

bool SetValue<T>(int row, int column, T[,] values)

Function SetValue(Of T)(row As Integer, column As Integer, values As T(,)) As Boolean

Parameters

Type	Name	Description
int	row	Row index of the start of the range of cells
int	column	Column index of the start of the range of cells
T[,]	values	Two-dimensional object array[row,column] that contains the values

Returns

Type	Description
bool	`true` if success, `false` otherwise.

Type Parameters

Name	Description
T

SetValue<T>(int, int, T[,], bool)

Sets an object array into a specified range of cells.

Declaration

bool SetValue<T>(int row, int column, T[,] values, bool vertical)

Function SetValue(Of T)(row As Integer, column As Integer, values As T(,), vertical As Boolean) As Boolean

Parameters

Type	Name	Description
int	row	Row index of the start of the range of cells
int	column	Column index of the start of the range of cells
T[,]	values	Two-dimensional object array[row,column] that contains the values
bool	vertical	if True, array will be set follow column index, other, it will be set follow row index.

Returns

Type	Description
bool	`true` if success, `false` otherwise.

Type Parameters

Name	Description
T

SetValue(int, int, int, int, bool)

Sets the bool value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, bool value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Boolean) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
bool	value	An bool value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int, int, CalcError)

Sets the CalcError value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, CalcError value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As CalcError) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
CalcError	value	An CalcError value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int, int, DateTime)

Sets the DateTime value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, DateTime value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Date) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
DateTime	value	An DateTime value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int, int, double)

Sets the double value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, double value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Double) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
double	value	An double value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int, int, int)

Sets the int value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, int value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Integer) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
int	value	An int value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int, int, object)

Sets the value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, object value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Object) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
object	value	An object value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.

SetValue(int, int, int, int, string)

Sets the string value for the cell of the specified cell range.

Declaration

bool SetValue(int row, int column, int row2, int column2, string value)

Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As String) As Boolean

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index of cell range.
int	column	An integer value indicates the left column index of cell range.
int	row2	An integer value indicates the bottom row index of cell range.
int	column2	An integer value indicates the right column index of cell range.
string	value	An string value to set

Returns

Type	Description
bool	`true` if success, `false` otherwise.