read_workbook
Read inside one workbook held against a database — a report, importTemplate or setupSheet (use list_database_sheets to see what exists). Called without sheet it returns the workbook's shape: every sheet with its extent, and every defined name with its scope and target — for an Azquo workbook the az_ names ARE the model, so start here. Called WITH sheet it returns that sheet's cells, showing formulas in preference to computed values. It returns structure and text, NOT the file itself: workbooks run to megabytes, so use the admin's Download button if you want the actual file. Setup sheets and import templates are administrator/developer only; reports follow the caller's report permissions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | Yes | Which of the three kinds of workbook to read | |
| name | Yes | For a report, its report NAME or its filename; for an import template or setup sheet, the filename as returned by list_database_sheets | |
| sheet | No | Omit for the workbook's structure; give a sheet name to read its cells | |
| fromRow | No | First row to read, 0-based (default 0). Use with maxRows to page a large sheet. | |
| maxCols | No | Columns to return (default 40) | |
| maxRows | No | Rows to return (default 200) | |
| database | Yes | Database name |