Appearance
Excel
Read and write data in Excel workbooks
Connect with: OAuth · Type: excel · Tools: 6
| Tool | What it does | |
|---|---|---|
excel_add_worksheet | write | Add a new worksheet (tab) to an Excel workbook. |
excel_clear_range | write | Clear values and/or formatting from a range in an Excel worksheet. |
excel_get_worksheet_used_range | read | Get the used range of a worksheet — the bounding box of all cells with values, formatting, or formulas. |
excel_list_worksheets | read | List all worksheets (tabs) in an Excel workbook. |
excel_read_range | read | Read values from a range in an Excel worksheet. |
excel_write_range | write | Write values into a range in an Excel worksheet. |
Tool names are suffixed with the connection they run against when you have more than one — excel_add_worksheet@production. With a single connection the bare name works.