TSTool / Command / SetExcelWorksheetViewProperties
SetExcelWorksheetViewProperties command sets view properties associated with an Excel worksheet,
for example to facilitate automated creation of Excel workbooks.
Additional properties will be added in the future.
Currently the command can set the following properties:
- Freeze pane for rows and columns
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.
SetExcelWorksheetViewProperties 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 of the worksheet in the workbook to set view properties. Can be specified with
||If not specified, set properties for the first worksheet.|
||Indicate whether to keep the Excel file open (
||The column to the right of the freeze pane split, using notation B, etc. (specifying A will have no effect).||Columns will not be frozen.|
||The row below the freeze pane split, specified as row number
||Rows will not be frozen.|
See the automated tests.