array is a Lua array containing
the data.CGrid:SetCol
The SetCol method stores an array of values to a grid column.
bSuccess = G:SetCol( array, nCol )
bSuccess = G:SetCol( array, nCol, nRows )
bSuccess = G:SetCol( array, nCol, nRowMin, nRowMax )
where
array is a Lua array containing
the data.
nCol is the
column index. Data is stored in all rows in the column.
nRows is the number of rows to set. The array
data are stored starting at row 1. The row range is clipped to the
range [1, GetNumRows].
nRowMin, nRowMax are the indices of the beginning and
ending grid rows. The row range is clipped to the range [1,
GetNumRows].
bSuccess is the returned success code. On
success it is true,
otherwise false.
The following script creates a grid and stores numbers in columns 1 through 5 and rows 1 through 3. The script retrieves data from column 2, row 2:
|
|
-- new grid with 3 cols, 10 rows, 1 Sheet |
|
|
-- set 5 columns in row 1 |
|
|
-- set 5 columns in row 2 |
|
|
-- set 5 columns in row 3 |
|
|
-- specify column 2, row 2 |
|
|
-- result: Cell[2][2] = 5 |
|
|
-- setup a table of data |
|
|
-- set data in column c (= 2) |
|
|
-- result: Cell[2][2] = 101 |
The following script creates a grid like the one above. The script sets data in column 1, rows 2 through 3:
|
|
-- new grid with 3 cols, 10 rows, 1 Sheet |
|
|
-- set 5 columns in row 1 |
|
|
-- set 5 columns in row 2 |
|
|
-- set 5 columns in row 3 |
|
|
-- specify column 1 and rows |
|
|
-- result: Cell[2][2] = 4 |
|
|
-- setup a table of data |
|
|
-- set data in column c (= 1) |
|
|
-- result: Cell[2][2] = 100 |