Xlsx

What it does

This skill enables AI agents to generate, read, and manipulate Excel spreadsheet files (.xlsx). It allows agents to create new spreadsheets from scratch or update existing ones by adding, removing, or modifying rows and columns.

When to use it

• You need an agent to automatically generate financial reports, inventory logs, or sales summaries in a format compatible with standard office software.
• Your workflow requires data analysis where the AI must ingest tabular data from an Excel file to perform calculations or insights.
• You want to automate repetitive data entry tasks by having the agent populate structured cells based on natural language instructions.

Key capabilities

• Create new .xlsx files with defined structures and headers.
• Read existing spreadsheet data for analysis or processing.
• Modify cell values, add rows, and delete columns dynamically.
• Handle complex formatting and layout requirements within spreadsheets.

Example prompts

• "Create a new Excel file named 'Q3_Sales_Report.xlsx' with columns for Date, Product, Quantity, and Total Price."
• "Read the attached inventory list and generate a summary table showing total stock value per category."
• "Update the second column in my existing spreadsheet to include calculated tax amounts based on the price in the first column."

Tips & gotchas

Ensure your AI agent has write permissions to the target directory where the .xlsx files will be saved. For complex formatting or very large datasets, verify that the underlying library supports the specific Excel features you require, such as merged cells or advanced formulas.