spreadsheet-processor
The spreadsheet-processor skill provides tools to create, edit, analyze, and transform Excel files using Python libraries pandas and openpyxl. It enforces strict formatting, formula construction, and error-checking standards to ensure dynamic and accurate financial models.
Is spreadsheet-processor safe to install?
Review the source first: our audit of spreadsheet-processor's source files found 2 shell commands, 0 external URLs, file reads and writes (high risk). Every command and URL listed appears verbatim in the skill's source. The skill executes shell commands to run a Python script for formula recalculation and performs read/write operations on local Excel files.
How we audit skills: our security review methodology.
Who is this skill for?
Data analysts, financial modelers, and developers who need to automate Excel file manipulation while maintaining professional formatting and formula integrity.
What can you do with it?
- Creating new Excel workbooks with custom formatting and formulas
- Editing existing Excel files while preserving original styles and structures
- Analyzing data within Excel files using pandas
- Recalculating Excel formulas using LibreOffice via a dedicated script
- Validating Excel files for formula errors like #REF! or #DIV/0!
How good is this skill?
Quality score: 9/10. The documentation is highly specific regarding technical requirements, error handling, and formatting standards. It provides clear code examples and a structured workflow for users.
What does the skill file contain?
# Requirements for Outputs ## All Excel files ### Zero Formula Errors - Every Excel model MUST be delivered with ZERO formula errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?) ### Preserve Existing Templates (when updating templates) - Study and EXACTLY match existing format, style, and conventions when modifying files - Never impose standardized formatting on files with established patterns - Existing template conventions ALWAYS override these guidelines ## Financial models ### Color Coding Standards Unless otherwise stated by the user or existing template #### Industry-Standard Color Conv...
Frequently asked questions
How do I ensure my Excel formulas are calculated correctly?
Use the provided recalc.py script to trigger LibreOffice to recalculate all formulas in the workbook.
What should I do if the recalc.py script reports errors?
Review the JSON output from the script, which identifies the specific error types and cell locations, then manually correct the formulas and run the script again.
Should I calculate values in Python and write them to the Excel file?
No. The skill requires the use of Excel formulas for all calculations to ensure the spreadsheet remains dynamic and updateable.
How do I preserve existing formatting in an Excel file?
Use the openpyxl library to load and modify the file, which maintains existing styles and formulas, rather than overwriting them with pandas.
Related skills
lark-workflow-meeting-summary
219.7KUsers who need to summarize meeting minutes, generate weekly reports, or review meeting history within the Lark ecosystem
The lark-workflow-meeting-summary skill provides a structured workflow for agents to aggregate meeting minutes from Lark VC, generate summaries, and create or update reports in Lark Docs.
programmatic-seo
83.5KContent strategists, SEO specialists, and marketers building large-scale, data-driven website content
The programmatic-seo skill provides a framework for generating SEO-optimized pages at scale using templates and data. It guides users through keyword research, data sourcing, template design, internal linking, and indexation strategies while emphasizing content uniqueness to avoid search engine penalties.
ad-creative
64.0KPerformance marketers, growth teams, and advertisers who need to produce ad copy at scale or optimize existing ad creative
The ad-creative skill generates, iterates, and scales ad copy for paid advertising platforms including Google, Meta, LinkedIn, TikTok, and Twitter. It provides frameworks for creating ad headlines, descriptions, and primary text based on product context and performance data.
customer-research
46.7KProduct marketers, founders, and researchers who need to ground their strategy in customer data
The customer-research skill provides a framework for analyzing existing research assets and gathering new insights from online communities to inform product marketing, messaging, and persona development.