> ## Documentation Index
> Fetch the complete documentation index at: https://ai-kb.automationanywhere.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Excel

> Workbook management, data operations, and analysis

## Configuración

<img src="https://mintcdn.com/automationanywhere/KYLkRhJ6hNNnwL4a/img/agents-toolkits/28.1.jpg?fit=max&auto=format&n=KYLkRhJ6hNNnwL4a&q=85&s=1c29f1444e2ebbd2f88c0e17ec472529" alt="Microsoft Excel configuration with authentication and file management tools" width="1280" height="629" data-path="img/agents-toolkits/28.1.jpg" />

<img src="https://mintcdn.com/automationanywhere/KYLkRhJ6hNNnwL4a/img/agents-toolkits/28.2.jpg?fit=max&auto=format&n=KYLkRhJ6hNNnwL4a&q=85&s=d3c9b93ab18a8a15db9bd0c58ab4d0a6" alt="Microsoft Excel Workbook, Worksheet, and Data Operations tools" width="1280" height="592" data-path="img/agents-toolkits/28.2.jpg" />

<img src="https://mintcdn.com/automationanywhere/KYLkRhJ6hNNnwL4a/img/agents-toolkits/28.3.jpg?fit=max&auto=format&n=KYLkRhJ6hNNnwL4a&q=85&s=ce898ee2e8dd952d83e9eb93e9c31bf6" alt="Microsoft Excel Formulas, Tables & Charts, and Advanced Analysis tools" width="1280" height="385" data-path="img/agents-toolkits/28.3.jpg" />

* **Auto-save**: Enabled
* **Maximum Chart Results**: 20
* **Authentication**: OAuth 2.0
* **Data Access**: Read/Write, Tables, Charts, Formulas, Advanced Analysis

## Available Tools (20/20)

### Workbook & Worksheet Management

* **List Excel Workbooks**: View all Excel files.
* **Open Workbook**: Open an existing workbook.
* **Create Workbook**: Create a new workbook.
* **Save Workbook**: Save current workbook.
* **Get Worksheets**: List all worksheets in the workbook.
* **Create Worksheet**: Add new worksheet.
* **Add Worksheet with Data**: Create worksheet and populate with data.
* **Copy Worksheet**: Duplicate worksheet.
* **Delete Worksheet**: Remove worksheet.
* **Rename Worksheet**: Change worksheet name.

### Data Operations

* **Read Cell Range**: Get values from range.
* **Write Cell Range**: Update values in range.
* **Format Cells**: Apply formatting (font, color, borders).
* **Insert Formula**: Add Excel formulas.

### Table & Analysis

* **Create Excel Table**: Convert range to table.
* **Create Chart**: Insert charts from data.
* **Create Pivot Table**: Generate pivot table.
* **Apply Filter**: Filter data in range.
* **Sort Range**: Sort data.
* **Find and Replace**: Search and replace values.

## Casos de Uso

* **Financial Modeling**: Build financial models with formulas and scenarios.
* **Data Analysis**: Process datasets with pivot tables and charts.
* **Report Automation**: Generate formatted Excel reports.
* **Sales Dashboards**: Create interactive dashboards.
* **Data Consolidation**: Merge data from multiple sources.