---
title: "Microsoft Excel"
canonical: "https://layest.com/en/integrations/microsoft-excel"
language: "en"
description: "Microsoft Excel is a spreadsheet application for calculations and data analysis. Users can analyze data with formulas, PivotTables, and charts and collaborate on workbooks."
---

# Microsoft Excel

Microsoft Excel is a spreadsheet application for calculations and data analysis. Users can analyze data with formulas, PivotTables, and charts and collaborate on workbooks.

## Authentication

**OAuth 2.0**: Authorize Layest on the provider’s sign-in page. The provider issues access tokens for the permissions you grant.

## Categories

- Other

## Actions from Microsoft Excel

These supported actions can be set up out of the box and used by our agents.

- **Add chart**: Create a chart on a worksheet from a data range.
- **Add defined name**: Create a workbook-level defined name (named range or formula).
- **Add table**: Create a table from an existing range.
- **Add table rows**: Append one or more rows to a table.
- **Add worksheet**: Add a new worksheet to a workbook.
- **Calculate workbook**: Force recalculation of all formulas in the workbook.
- **Create workbook**: Upload a new .xlsx workbook to a drive folder.
- **Delete defined name**: Delete a workbook-level defined name.
- **Delete table**: Delete a table (converts it back to a normal range; does not delete the underlying cell data).
- **Delete workbook**: Delete a workbook file.
- **Delete worksheet**: Delete a worksheet from a workbook.
- **Get chart image**: Render a chart as an image.
- **Get range**: Read cell values from a specific range on a worksheet.
- **Get site drive**: Get the default document library (drive) for a SharePoint site.
- **Get used range**: Read all non-empty cells on a worksheet.
- **Get user drive**: Get a user's personal OneDrive (drive).
- **Get workbook**: Retrieve driveItem metadata for a workbook.
- **List defined names**: List workbook-level defined names.
- **List sites**: Search and list SharePoint sites accessible to the app.
- **List table columns**: List the columns of a table
- **List table rows**: List the data rows of a table.
- **List tables**: List tables in a workbook.
- **List users**: List/search tenant users, to resolve a user id for personal OneDrive access.
- **List workbooks**: List and search .xlsx files within a drive.
- **List worksheets**: List worksheets in a workbook.
- **Update range**: Write cell values into a specific range on a worksheet
- **Update worksheet**: Rename a worksheet and/or change its tab position.

## Triggers from Microsoft Excel

Once configured in Nango, these sync templates can provide changes as triggers.

- **Workbooks**: Sync .xlsx files within a drive
- **Worksheets**: Sync the worksheets within a specific workbook.
