XL Write

Write attributes to an Excel worksheet

Write attributes to an Excel worksheet

Preview

Location

Name | Write To Excel

Nickname | XL Out

Tab | TTToolbox

Panel | Excel

Division | 1

Inputs

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

Ouputs

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 |