microsoft-excel

What problem does it solve?

This Skill simplifies the process of interacting with Microsoft Excel files stored in OneDrive, allowing for programmatic reading and writing of data without manual intervention.

Core Features & Use Cases

• Workbook Management: Read and write entire Excel workbooks.
• Worksheet Operations: Create, update, delete, and list worksheets.
• Data Manipulation: Read, write, and clear data within specific ranges.
• Table Management: Create, update, add/delete rows and columns for tables.
• Chart Integration: Add charts to worksheets.
• Use Case: Automatically update a sales report in Excel with new data fetched from a database, or extract specific financial data from an Excel file for analysis.

Quick Start

Use the microsoft-excel skill to list all worksheets in the file 'report.xlsx' located in the root of your OneDrive.