ETableStream
Takes two parameters, ExcelTableData, Options
Description:
This command takes input from the Field named ETData, pulled from the Request Query, when HandsonTable sends data back to Moxie and streams it into the Work Query. ETData can be obtained by using the HtmlETable command in conjunction with the ETableReply command.
Usage:
Options Parameter:
- Header - Naming this as an option will use the first row as the Field Names. Note that you may want to use the FixFields command if using this option with input that contains spaces or other invalid characters. If this option is not specified, Fields will be named as Field01, Field02, etc.
- Changes - When the incoming data is changes only, such as when triggered via an Auto Save, auto set the Field Names to "Row Col Old New" and changes the zero-based offsets to one-based offsets. If Header is also specified, the Row offsets will not be changed to accommodate the first Row being the Field Names in your destination data.
Example:
ETableStream ETData, Options
ETableStream ETData, [""]