SpreadsheetAddData (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SpreadsheetAddData (Function)

In french: TableurAjouteDonnée

Adds a data into a Spreadsheet control found in a window.

Example

//  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.

Component: wd300obj.dll