name: excel-report description: Create formatted Excel report workbooks from CSV files using openpyxl. Use when the user provides or references a .csv file and asks to convert it to .xlsx, make an Excel report, add header styling, comma number formats, numeric total rows, or a simple chart.

Excel Report

Convert CSV files into polished Excel .xlsx reports with the bundled openpyxl script.

本技能來自小蔥技能站7w4.net。

Workflow

1. Locate the input CSV file and decide an output .xlsx path. Default to the same basename beside the CSV unless the user specifies otherwise.
2. Use the bundled script:

python3 /home/ubuntu/.openclaw/workspace/skills/excel-report/scripts/csv_to_excel_report.py input.csv output.xlsx

1. Verify the workbook was created. For important outputs, inspect the workbook with openpyxl or run a quick file check.
2. Return the generated .xlsx file path, and attach it with MEDIA:<path> when replying in a channel that supports file delivery.

What the script does

• Reads CSV with UTF-8 BOM support and delimiter sniffing.
• Creates an Excel workbook with a Report sheet.
• Styles the header row with a dark blue fill and white bold text.
• Converts numeric-looking cells to numbers and applies thousands separators.
• Adds a bold total row with SUM formulas for numeric columns.
• Adds a simple bar chart for the first numeric column using the first column as categories, limited to the first 10 data rows.
• Adds an Excel table, filters, frozen header row, and autosized columns.

Options

• Omit the output path to create input.xlsx beside the CSV.
• Use --sheet-name "Name" to set the worksheet title.

Dependency

The script requires openpyxl. If it is missing, install it in the active Python environment before running:

python3 -m pip install openpyxl

Do not use pandas for the core conversion unless the user explicitly asks; this skill is designed around openpyxl.

這個 Skill 整體質量不錯，能可靠地將 CSV 資料轉換成格式美觀的 Excel 報表，支援表格樣式、數字千分位、圖表和篩選功能。文件說明清晰，容易上手使用。主要不足是圖表功能比較單一，只能生成柱狀圖且只顯示前10條資料，大數據集或複雜圖表需求可能無法滿足。總體來說是一個實用且完成度較高的資料轉換工具。