TSTool / Command / NewExcelWorkbook
NewExcelWorkbook command creates a Microsoft Excel workbook file and
optionally also creates worksheets in the new workbook.
See also other Excel processing commands that can be used to further manipulate the Excel file.
TSTool uses the Apache POI software to 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.
NewExcelWorkbook Command Editor (see also the full-size image)
The command syntax is as follows:
|The name of the Excel workbook file (
||None – must be specified.|
||The name(s) of the worksheets to create in the workbook. Can specify using processor
||Don’t create any named sheets.|
||Indicate whether to keep the Excel file open (True) or close after creating (
See the automated tests.