Reading and Setting Values in a Worksheet with Widgets
You can pass values from the worksheet to the widget and vice versa, but only for widgets with HTML content type.
Passing values from the worksheet to the widget
params, while B1 would be
params, and so on.
__exec is executed by default every time source values change, so the widget refreshes the data.
Passing values from the widget to the worksheet
__set() is used. As its single parameter,
__set expects the value to return.
The following example code returns the current value of a text input field to the worksheet once the user clicks the button:
Of course, the target of the widget must be specified to pass the result back to the spreadsheet.