files_text_formats
Reads the cell formatting in an A1 range (the inverse of files_format), so you can inspect existing styles before changing them. Returns one entry per cell that has a non-default format: { cell (A1), and the set properties among bold/italic/underline/strikethrough/text_color/fill_color/align/vertical_align/wrap/number_format/negative/decimals/currency_symbol/numeric_commas/custom_format/date_time/font_size } — the same vocabulary files_format accepts, so a read format can be re-applied. custom_format holds an ECMA-376 number format code in the invariant (English) notation and takes precedence over the discrete tokens when both are present. Read-only; reflects the file's latest live state. Signature: files_text_formats(file_uuid, range, sheet?).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_uuid": "<file_uuid>",
"range": "<range>"
},
"name": "files_text_formats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range to inspect, e.g. 'A1:H50'. | |
| sheet | No | Sheet name (defaults to the first sheet). | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | ||
| formats | Yes | ||
| file_uuid | Yes | ||
| truncated | Yes |