skills.rest
aws-samples
aws-samplesOFFICIAL
Explore all skills by this author →
WebsiteGitHub

excel-spreadsheets

Create and modify Excel workbooks with openpyxl-based Python code.

186|56|Updated Aug 13, 2025
Search Tags:#automation#python#preview#openpyxl#excel#spreadsheets#financial-modeling
One-click install
npx skills add https://github.com/aws-samples/sample-strands-agent-with-agentcore --skill excel-spreadsheets
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-spreadsheets
Source: https://github.com/aws-samples/sample-strands-agent-with-agentcore/tree/main/chatbot-app/agentcore/skills/excel-spreadsheets
Command: npx skills add https://github.com/aws-samples/sample-strands-agent-with-agentcore --skill excel-spreadsheets

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes manual, error-prone Excel work by enabling programmatic creation, modification, previewing, and retrieval of workbooks while enforcing consistent formatting, formulas, and naming rules to reduce human mistakes.

Core Features & Use Cases

  • Automated creation of new workbooks with programmatic sheets, headings, and data insertion.
  • Deterministic modification of existing spreadsheets with enforced new output names to avoid accidental overwrites.
  • Visual sheet previewing to verify layout and styling before and after edits.
  • Financial modeling conventions and formatting rules for professional reports, including currency, percentage, negative number, and year formats.
  • Use cases include generating quarterly financial reports, updating templates with new assumptions, and producing screenshot previews for stakeholder review.

Quick Start

Create a new spreadsheet named quarterly-sales with a Sales sheet and revenue data for Q1–Q4 using the excel-spreadsheets create tool.

Frequently Asked Questions about excel-spreadsheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel spreadsheet creation and formatting with Python?▼

Automate Excel spreadsheet creation and formatting by executing openpyxl-based Python code snippets that programmatically generate workbooks, insert data, and apply financial formatting rules.

Can I use pandas and matplotlib with openpyxl for financial modeling in Excel?▼

Yes, financial modeling and spreadsheet automation support openpyxl, pandas, numpy, and matplotlib to generate workbooks, insert data, and create visual previews for stakeholder review.

What is the best way to prevent accidental overwrites when modifying existing Excel spreadsheets programmatically?▼

Prevent accidental overwrites when modifying existing Excel spreadsheets by enforcing deterministic new output filenames and sequential tool execution to avoid race conditions during workbook editing.

How do I preview an Excel sheet layout and styling before sharing it with stakeholders?▼

Preview an Excel sheet layout and styling by using visual sheet previewing tools that verify formatting, headings, and data placement before and after applying workbook modifications.

Does this approach support professional financial report formatting like currency and percentage conventions?▼

Yes, professional financial report formatting supports currency, percentage, negative number, and year formats, applying financial modeling conventions to ensure reliable calculations in Excel spreadsheets.

How do I update an existing Excel workbook template with new financial assumptions?▼

Update an existing Excel workbook template with new financial assumptions by programmatically modifying spreadsheets with enforced output names to ensure consistent formatting and reliable formula calculations.

Related Skills

Explore More Finance & Accounting Skills→
bomm79crisbomm79cris

python-executor

Execute Python code securely in a sandboxed environment with pre-installed libraries.

Community
Advanced
ekkus93ekkus93

excel-to-delimited

Convert Excel workbooks into per-sheet CSV or TSV files.

Community
Intermediate
rodrigoBermejorodrigoBermejo

Data Processing - pandas, numpy, Data Analysis

Automate data processing and analysis in Python with pandas and numpy.

Community
Intermediate
truongnattruongnat

accounting-pro

Handle double-entry bookkeeping, financial statement preparation, and basic tax calculations.

Community
Intermediate