XL Write
Write attributes to an Excel worksheet
Write attributes to an Excel worksheet
Name | Write To Excel
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 | Attributes (Attribute) | A list of core attributes to write.
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
Usage
The Excel Write components can write to multiple worksheets from a single component.
A single dimension data tree still specifies a column
Datatree = {0}[2], {1}[2]
Sheet 1
| A1 | B1 |
| A2 | B2 |
A multi-dimension data tree still uses the first index
Datatree = {0,0}[2], {0,1}[2], {1,0}[2], {1,1}[2]
Sheet 1
| A1 | B1 |
| A2 | B2 |
Sheet 2
| A1 | B1 |
| A2 | B2 |