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)')

This example can be found in the Peakboard Designer under Templates -> Scripting, or can be downloaded via this Link.