spreadsheet_write_styles
Apply bulk style updates to a cell range in a Synology Spreadsheet, setting fonts, colors, alignment, borders, and number formats with a single request.
Instructions
Bulk overwrite cell styles (fonts, colors, alignment, number formats, borders) for a rectangular block in a Synology Spreadsheet. Uses offset-based PUT /styles endpoint — simpler than batch_update for style-only writes. Requires Synology Office >= 3.7.0. For mixed value+style edits use spreadsheet_batch_update. Provide either file_id or name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_id | No | Alphanumeric Spreadsheet ID (overrides name lookup). | |
| name | No | Spreadsheet display name (resolved via local cache). | |
| path | No | Optional Drive path to disambiguate same-name files. | |
| sheet_name | Yes | Target sheet name, e.g. "Sheet1" | |
| start_row | Yes | 0-based starting row offset | |
| start_col | Yes | 0-based starting column offset | |
| styles | Yes | 2D grid; styles[i][j] applies to cell (start_row+i, start_col+j). Must be rectangular. |