read xlsx
read_xlsxRead an Excel .xlsx workbook (by URL) into rows — every sheet, or one you name. Returns cell values (not formula text), dates as YYYY-MM-DD instead of Excel serial numbers, and keeps leading zeros so ID/postcode columns are not silently mangled. Says plainly which sheet it used, which sheets are hidden, and where merged cells left blanks, instead of guessing for you.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | ||
| sheet | No | ||
| inline | No | ||
| max_rows | No | ||
| preview_rows | No | ||
| keep_formulas | No |