|
|
|
|
|
|
|
|
SpreadsheetAddData (Function) In french: TableurAjouteDonnée Adds a data into a Spreadsheet control found in a window. // Initialize the 1st column with numbers from 1 to 10
FOR I = 1 TO 10
SpreadsheetAddData(PSHEET_Spreadsheet, 1, I, "Row " + I)
END
// Initialize the 1st row with numbers from 1 to 10
FOR I = 1 TO 10
SpreadsheetAddData(PSHEET_Spreadsheet, i, 1, "Column " + I)
END
Syntax
SpreadsheetAddData(<Spreadsheet control> , <Column> , <Row> , <Data>)
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Column>: Integer Column number of the value to add. <Row>: Integer Row number of the value to add. <Data>: Type of data Value to add. Remarks - If the cell (Column, Row) does not exist, this cell is created.
- If the cell (Column, Row) already exists, the content of the cell is replaced with <Data>.
- This function can only be used on a Spreadsheet control found in a window.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|