xlsx-author

Generate formula-driven Excel workbooks with Inputs, DCF, and Checks sheets.

Updated May 27, 2026
One-click install
npx skills add https://github.com/cwstedctw/financial-services-tw --skill xlsx-author-cwstedctw
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx-author
Source: https://github.com/cwstedctw/financial-services-tw/tree/main/taiwan-finance/skills/xlsx-author
Command: npx skills add https://github.com/cwstedctw/financial-services-tw --skill xlsx-author-cwstedctw

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

xlsx-author 幫你在沒有開啟 Office 的情況下,直接在磁碟上產生 .xlsx 檔,避免需要人工建立或手動編輯活頁簿來支援 managed-agent 工作流程。

Core Features & Use Cases

  • Headless Excel workbook 產生:直接輸出到 out/<name>.xlsx,讓後續代理能以檔案形式取得模型。
  • 以公式導向的模型建構規範:把輸入集中到 Inputs 工作表,計算區用公式而非硬編,降低維護成本與錯誤風險。
  • 適用於 DCF/三表/模型類產出:可建立多張工作表(例如 DCF、Checks),並進行一致性/平衡檢查,適合財務模型交付。

Quick Start

請要求 AI 以 headless 方式根據你的輸入欄位與計算邏輯產生一個包含 Inputs、DCF 以及 Checks 的 Excel 檔,並回傳產出檔案的相對路徑。

Frequently Asked Questions about xlsx-author

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

FAQPage Schema
How do I generate an Excel workbook in headless mode for automated workflows?

To generate an Excel workbook in headless mode, the Skill writes .xlsx files directly to disk without opening Office, saving the output to ./out/<name>.xlsx for downstream managed-agent workflows to consume as a file artifact.

When do I need a formula-driven Excel workbook for financial modeling?

A formula-driven Excel workbook is needed for financial modeling tasks like DCF calculations to ensure calculation cells contain formulas rather than hardcoded values. This centralizes inputs and reduces maintenance costs and error risks.

Can I create multiple worksheets with consistency checks for a DCF model?

Yes, you can create multiple worksheets like Inputs, DCF, and Checks within a single workbook. The Skill supports structured sheet layouts and performs consistency and balance checks for financial model delivery.

Does openpyxl support generating Excel files without opening Office?

Yes, openpyxl supports generating Excel files without opening Office by operating in a headless mode. It writes the workbook directly to the disk, returning the relative output path for subsequent automated processes.

What is the best way to structure inputs for automated Excel workbook generation?

The best way to structure inputs is to centralize them on a dedicated Inputs worksheet. Calculation areas then reference these inputs using formulas instead of hardcoded values, ensuring consistency and lowering maintenance efforts.

Do I need Microsoft Excel installed to run headless workbook generation?

No, you do not need Microsoft Excel installed to run headless workbook generation. The process operates independently on the disk to produce .xlsx files, specifically avoiding manual workbook editing or Office dependencies.