office-excel

name office-excel description Read and write Microsoft Excel (.xlsx) files. Use when the user asks to read, analyze, create, or convert Excel spreadsheets. Read an Excel file Converts all sheets of an .xlsx to Markdown tables: uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/read_excel.py "<path_to_xlsx>" Read a specific sheet: uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/read_excel.py "<path_to_xlsx>" "SheetName" Save as .md file: uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/read_excel.py "<path_to_xlsx>" "<output.md>" Write an Excel file Preferred: Directly from markdown content (no intermediate file) Pipe markdown table content directly into the script using --stdin . This avoids creating temporary files: echo '<markdown_content>' | uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/write_excel.py --stdin "<output.xlsx>" For multi-line content, use a heredoc: uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/write_excel.py --stdin "<output.xlsx>" << 'EOF' ## Sheet Name | Col1 | Col2 | |------|------| | a | b | EOF From an existing Markdown file If a .md file with tables already exists, use it directly: uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/write_excel.py "<input.md>" "<output.xlsx>" If you had to create the .md file as an intermediate step (it didn't exist before), delete it after generating the Excel. From JSON Create a .json file with an array of objects, then: uv run --with openpyxl ~/.kiro/skills/office-excel/scripts/write_excel.py "<input.json>" "<output.xlsx>" Notes Each Markdown table becomes a separate sheet when writing Headings before tables are used as sheet names JSON input must be a non-empty array of objects Headers are auto-bolded and columns auto-sized IMPORTANT: Do NOT create intermediate markdown files if you can pipe content directly via --stdin . If you must create one (e.g., content is too large for a heredoc), always delete it after generating the Excel.