Write to Excel
To enable writing to Excel, the corresponding .xls file must be integrated as a bridge data source via an ODBC request. Instructions can be found here.
The following script example allows to write values to Excel. With the help of a Reload() command, an immediate reload of the linked data source is triggered.
Data.MyOdbcExcelDatasource.ExecuteNonQuery('INSERT INTO [MyTable$] (Col1, [Col 2], [Col 3]) VALUES (15, 25, 35)') Data.MyOdbcExcelDatasource.Reload()
This example can be found in the Peakboard Designer under Templates -> Scripting, or can be downloaded via this Link.