Office Excel

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.