format_range
Apply formatting options like bold, colors, alignment, borders, and number formatting to a specified Excel cell range.
Instructions
Apply formatting to a cell range.
Args: cell_range: Range like 'A1:D10'. workbook: Workbook name or path. Defaults to active workbook. sheet: Sheet name. Defaults to active sheet. bold: Set bold. italic: Set italic. underline: Set underline. font_size: Font size in points. font_color: Hex colour like '#FF0000'. bg_color: Background hex colour like '#FFFF00'. number_format: Excel format like '#,##0.00'. alignment: 'left', 'center', 'right', 'justify'. wrap_text: Enable text wrapping. border: Apply thin borders.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell_range | Yes | ||
| workbook | No | ||
| sheet | No | ||
| bold | No | ||
| italic | No | ||
| underline | No | ||
| font_size | No | ||
| font_color | No | ||
| bg_color | No | ||
| number_format | No | ||
| alignment | No | ||
| wrap_text | No | ||
| border | No |