TSTool / Command / WriteTableCellsToExcel
WriteTableCellsToExcel command writes table row cells to a Microsoft Excel worksheet’s cells.
Currently cells from a single table row can be output.
The command is designed to populate named ranges in the Excel file,
for example to pre-populate a data-entry form.
Use this command in a template to iterate through rows in a table matched with separate Excel output files.
TSTool uses the Apache POI software to read/write the Excel file and consequently functionality is constrained by the features of that software package.
The following dialog is used to edit the command and illustrates the syntax of the command.
WriteTableCellsToExcel Command Editor (see also the full-size image)
The command syntax is as follows:
|Identifier for table to write.||None – must be specified.|
||Indicate table column names and pattern to use to include rows, in order to match a single table row to output. The format of the parameter is:
where patterns can contain
|Include all rows (which will generate an error if the number of rows is not equal to one)|
|Indicate how to map table column names to Excel addresses. The format of the parameter is:
where the Excel addresses can be specified using
|None – must be specified.|
|The name of the Excel workbook file (
||None – must be specified.|
||The name of the worksheet in the workbook to write. If the worksheet does not exist it will be created.||Write to the first worksheet.|
||Indicate whether to keep the Excel file open (
See the automated tests.