Write data to an Excel worksheet
Last updated 9 months ago
Name | Write To Excel Classic
Nickname | XL Out*
Tab | TTToolbox
Panel | Excel
Division | 1
Wb | Workbook Filepath (Text) | Path to the Excel file to open. If none is provided, the open workbook will be read or a new one will be created.
Ws | Worksheet Name (Text) | Worksheet name or index (starting from 1). If none is provided, the frontmost worksheet will be used.
D | Data (Text) | A data tree of text values
A | Location Address (Text) | The starting address
O | Settings(Text) | Excel Workbook options
C | Clear (int) | Optionally clear the existing contents of the sheet or the range of a worksheet prior to writing new content.
_S | Stream (Boolean) | True to Write data to Excel
R | Range Address (Text) | The range address