The script command 'Workbook command' sends the whole script line to the workbook. This can execute the following actions:
Script command |
Explanation |
---|---|
clear |
Clears the workbook. After this action there is only one empty worksheet. |
rename sheet, sheet index, new name |
Renames the sheet with the specified index |
append sheet |
Appends an empty worksheet |
save fit parameter names, worksheet name, row, column |
Writes the names of the fit parameters downwards, starting at the given row and column in the specified worksheet |
save fit parameter values,worksheet name, row, column |
Writes the values of the fit parameters downwards, starting at the given row and column in the specified worksheet |
measurement series save fit parameter values,worksheet name, row, column |
Writes the values of the fit parameters downwards, starting at the given row in the specified worksheet. The start column is given as the sum of the specified column value and the series index of the last measurement. 4 cells above the selected row are filled as well with date, product name, sample name and index of the last measurement. |
measurement series average fit parameter values |
Computes and writes the average of the fit parameters for all measurements to the given row in the specified worksheet. The values are written to the column which is computed as the sum of the specified value, the number of measurements of the series and 1. 4 cells above the selected row are filled as well with the date, the product name, the sample name and the index of the last measurement. |
save final number names, worksheet name, row, column, first index, last index |
Writes final number names to the given worksheet, starting in the specified row and column. This routine does not write all names but only those with indices between the given first and last index. |
save final number values, worksheet name, row, column, first index, last index |
Writes final number values to the given worksheet, starting in the specified row and column. This routine does not write all values but only those with indices between the given first and last index. |
measurement series save final number values, worksheet name, row, column, first index, last index |
Writes final number values to the given worksheet, starting in the specified row. The column is the sum of the specified column and the index of the last performed measurement of the series. This routine does not write all values but only those with indices between the given first and last index. 4 cells above the selected row are filled as well with the date, the product name, the sample name and the index of the last measurement. |
measurement series average final number values, worksheet name, row, column, first index, last index |
Writes the average of final number values for a measurement series to the given worksheet in the specified row. The column is the one to the right of the last performed measurement of the series. This routine does not write all values but only those with indices between the given first and last index. 4 cells above the selected row are filled as well with date, product name, sample name and index of the last measurement. |
save optical function names, worksheet name, row, column |
Writes the names of the fit parameters downwards, starting at the given row and column in the specified worksheet |
save optical function values, worksheet name, row, column |
Writes the values of the fit parameters downwards, starting at the given row and column in the specified worksheet |
measurement series save optical function values |
Writes the values of the optical functions downwards, starting at the given row in the specified worksheet. The start column is given as the sum of the specified column value and the series index of the last measurement. 4 cells above the selected row are filled as well with date, product name, sample name and index of the last measurement. |
measurement series average optical function values |
Computes and writes the average of the fit parameters for all measurements to the given row in the specified worksheet. The values are written to the column which is computed as the sum of the specified value, the number of measurements of the series and 1. 4 cells above the selected row are filled as well with the date, the product name, the sample name and the index of the last measurement. |
set column width, worksheet name, column, width |
Sets the width (in pixels) of the specified column of the given worksheet |
write cell number,expression for cell number, worksheet name, expression for cell row, expression for cell column |
Writes a number to the worksheet of the given name. The number is obtained by evaluating the given expression. Both row and column are computed by the given expressions, rounding the outcome to an integer number. All expressions can use master parameters, optical functions and fit parameters. In CODE you can use integral quantities as well. |
write cell text,the text, worksheet name, expression for cell row, expression for cell column |
Writes text to the worksheet of the given name. Both row and column are computed by the given expressions, rounding the outcome to an integer number. The expressions can use master parameters, optical functions and fit parameters. In CODE you can use integral quantities as well. |