format_cells
Apply formatting to Excel cells, including font styles, colors, alignment, borders, and number formats, for both live workbooks and .xlsx files without Excel.
Instructions
Apply formatting to cells. Use "workbook" for live Excel, or "path" for a .xlsx file on disk (no Excel needed, preserves images/charts). Options: bold, italic, underline, fontSize, fontName, fontColor, backgroundColor, textAlign (left/center/right), verticalAlign (top/middle/bottom), numberFormat, wrapText, borders ({top/bottom/left/right/inside/outside: {style, color}}).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workbook | No | Open workbook name (live Excel) | |
| path | No | File path to .xlsx (no Excel needed) | |
| range | Yes | Cell range (e.g. "A1:C3") | |
| format | Yes | Formatting options | |
| sheet | No | Sheet name (default: active sheet) |