Evaluate a formula
xlide_evaluate_formulaEvaluate an Excel formula in a live workbook to preview its result without altering the file. Check formulas before writing or query data with Excel functions like SUMIFS.
Instructions
Works out what a formula would give in a cell of a workbook, without writing it there: to check a formula before xlide_write_cells, or to ask the workbook a question, such as =SUMIFS(Sales[Amount],Sales[Region],"West"). Uses pyOfficeEditor's formula engine, 493 of Excel's functions, with the workbook's cells as they stand. A formula written for one cell answers with one value, as Excel would give it there. Changes nothing. .xlsx, .xlsm and .xlam.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| at | No | The cell it is imagined in, which relative references count from. | A1 |
| sheet | Yes | Worksheet the formula is evaluated on. | |
| formula | Yes | The formula, with or without its '='. | |
| file_path | Yes | Absolute path to the Excel file. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||