format_cells_advanced
Apply advanced cell formatting to Google Sheets: set alignment, fonts, borders, number formats, and text wrapping for a specified range.
Instructions
Apply advanced formatting including alignment, fonts, borders, and number formats
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_row | Yes | Ending row index (exclusive) | |
| sheet_id | Yes | The ID of the sheet | |
| font_size | No | Font size in points | |
| start_row | Yes | Starting row index (0-based) | |
| border_top | No | ||
| end_column | Yes | Ending column index (exclusive) | |
| text_color | No | Text color (RGB values 0-1) | |
| border_left | No | ||
| font_family | No | Font family name | |
| border_right | No | ||
| start_column | Yes | Starting column index (0-based) | |
| border_bottom | No | ||
| number_format | No | Number format pattern (e.g., '$#,##0.00', '0.00%', 'yyyy-mm-dd') | |
| wrap_strategy | No | Text wrapping strategy | |
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| vertical_alignment | No | Vertical text alignment | |
| horizontal_alignment | No | Horizontal text alignment |