xlsx-cn

What This Skill Does

The xlsx-cn skill is a robust, professional-grade utility designed for the OpenClaw agent to create, manipulate, and analyze Microsoft Excel files. Whether you are generating complex financial models from scratch, updating existing spreadsheets, or extracting key insights from massive datasets, this skill provides the necessary technical rigor to ensure accuracy and compliance with industry standards. It supports advanced features including custom formulas, data visualizations, and automated formatting, adhering strictly to professional accounting and documentation guidelines.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/guohongbin-git/xlsx-cn

Use Cases

This skill is designed for analysts, financial planners, and administrative professionals. Common use cases include:

• Automated Financial Reporting: Generate quarterly balance sheets and P&L statements with specific color-coded standards (blue for inputs, black for formulas).
• Bulk Data Processing: Clean, reformat, or aggregate large CSV/XLSX datasets into professional reports.
• Template Maintenance: Update existing company workbooks while preserving legacy formatting and styling constraints.
• Data Analysis & Modeling: Run complex calculations using cell references instead of hardcodes, ensuring all projections are error-free and easily auditable.

Example Prompts

1. "Excel: Please generate a 3-year revenue projection table for Project X based on the provided assumption list, ensuring all formulas are correct and using the standard professional color-coding for financial models."
2. "表格: Open the attached sales report, calculate the year-over-year growth for each region, and add a summary chart showing the trend from 2022 to 2024."
3. "xlsx: Update the attached valuation model. Replace the hardcoded discount rate with a link to the assumption tab and add a citation comment for the source 'Bloomberg Terminal, 2025'."

Tips & Limitations

• Precision is Key: The skill enforces strict formatting rules (e.g., years as text, specific currency formatting). Always provide the required sources for hardcoded data to maintain professional auditability.
• Error Handling: The skill is configured to reject any output containing formula errors such as #REF! or #DIV/0!. Always verify input data quality before processing large ranges.
• Template Integrity: When asked to edit existing files, the skill defaults to preserving the established style. If you have custom brand colors, explicitly mention them to override the default industry standards.