read_cells
Extract cell formulas, calculated values, or formatting details from Excel ranges in live workbooks or .xlsx files without Excel installed.
Instructions
Read cell formulas/values from a range. By default returns formulas where they exist. Use "workbook" for an open Excel workbook, or "path" for a .xlsx file on disk (no Excel needed, preserves images/charts). Set valuesOnly=true to get calculated values instead of formulas. Set formats=true to include formatting details.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workbook | No | Open workbook name (live Excel) | |
| path | No | File path to .xlsx (no Excel needed) | |
| range | Yes | Cell range (e.g. "A1" or "A1:C10") | |
| sheet | No | Sheet name (default: active sheet) | |
| formats | No | Include cell formatting (default: false) | |
| valuesOnly | No | Return calculated values instead of formulas (default: false, returns formulas) |