sheets_read
Read a spreadsheet (.xlsx) from Files. Returns its sheets (name, used_range) and, for one sheet (default the first) and range (A1 notation, e.g. A1:F50; default the used range), rows of cells: null for empty, else {value, formula (without '='), number_format}. value is the saved result of a formula; a formula without one recalculates when the file is opened. Returns at most max_cells cells: when truncated, read on with next_range. Also returns version (pass it as expected_version when you edit), merged ranges and freeze panes.
Parameters
- file_id (string, required)
- sheet (string)
- range (string)
- max_cells (integer, default 2000)