Read and calculate
read_workbookExtract computed values, formulas, or formatted text from spreadsheet ranges and sheets, then evaluate formulas without changing the workbook.
Instructions
Read a workbook (xlsx, xlsm, xls, xlsb, ods, csv, tsv, json): computed values, formulas or display text of a range or sheet, and evaluate formulas against it without changing anything (e.g. "=SUMIFS(D:D,A:A,"North")", "=AVERAGE(Sales!C2:C99)").
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | values (computed), formulas (formula text where there is one) or formatted (as displayed, number formats applied). | values |
| range | No | A1 range (default: the used range). | |
| sheet | No | Default: the first sheet. | |
| evaluate | No | Formulas to evaluate on the sheet. | |
| max_rows | No | ||
| input_path | Yes |