format_cell
Set cell formatting in Excel files, including font styles, fill colors, and borders, for precise customization of spreadsheets.
Instructions
セルの書式（フォント、塗りつぶし、罫線）を設定します
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | セル位置（例: A1） | |
| filePath | Yes | Excelファイルのパス | |
| format | Yes | セルの書式設定 | |
| sheetName | Yes | ワークシート名 |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"cell": {
"description": "セル位置（例: A1）",
"type": "string"
},
"filePath": {
"description": "Excelファイルのパス",
"type": "string"
},
"format": {
"additionalProperties": false,
"description": "セルの書式設定",
"properties": {
"border": {
"additionalProperties": false,
"description": "罫線設定",
"properties": {
"bottom": {
"additionalProperties": false,
"properties": {
"color": {
"type": "string"
},
"style": {
"type": "string"
}
},
"required": [
"style",
"color"
],
"type": "object"
},
"left": {
"additionalProperties": false,
"properties": {
"color": {
"type": "string"
},
"style": {
"type": "string"
}
},
"required": [
"style",
"color"
],
"type": "object"
},
"right": {
"additionalProperties": false,
"properties": {
"color": {
"type": "string"
},
"style": {
"type": "string"
}
},
"required": [
"style",
"color"
],
"type": "object"
},
"top": {
"additionalProperties": false,
"properties": {
"color": {
"type": "string"
},
"style": {
"type": "string"
}
},
"required": [
"style",
"color"
],
"type": "object"
}
},
"type": "object"
},
"fill": {
"additionalProperties": false,
"description": "塗りつぶし設定",
"properties": {
"fgColor": {
"description": "前景色（ARGB形式）",
"type": "string"
},
"pattern": {
"description": "パターン（solid等）",
"type": "string"
},
"type": {
"const": "pattern",
"description": "塗りつぶしタイプ",
"type": "string"
}
},
"required": [
"type",
"pattern",
"fgColor"
],
"type": "object"
},
"font": {
"additionalProperties": false,
"description": "フォント設定",
"properties": {
"bold": {
"description": "太字設定",
"type": "boolean"
},
"color": {
"description": "フォント色（ARGB形式）",
"type": "string"
},
"italic": {
"description": "斜体設定",
"type": "boolean"
},
"size": {
"description": "フォントサイズ",
"type": "number"
}
},
"type": "object"
}
},
"type": "object"
},
"sheetName": {
"description": "ワークシート名",
"type": "string"
}
},
"required": [
"filePath",
"sheetName",
"cell",
"format"
],
"type": "object"
}