format_cell
Set cell formatting in Excel, including font style, fill color, and borders. Specify file path, sheet name, cell location, and desired format attributes for precise customization.
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"
}