Excel Report#

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

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:

bash

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:

bash

python3 -m pip install openpyxl

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