set_column_formula
Fill a worksheet column by applying a LabTalk formula to other columns. Create the target column if it does not exist.
Instructions
Fill a worksheet column from a formula of other columns.
Args: book_name: Workbook name sheet_name: Sheet name col: Target column (1-based); created if it does not exist formula: LabTalk expression, e.g. "col(1)^2", "col(2)*100/col(3)"
Returns: Success message
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| book_name | Yes | ||
| sheet_name | Yes | ||
| col | Yes | ||
| formula | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |