add_formula
Insert formulas into specified Excel cells using file path, sheet name, and cell position. Automates Excel calculations for data manipulation and analysis.
Instructions
セルに数式を追加します
Input Schema
Name | Required | Description | Default |
---|---|---|---|
cell | Yes | セル位置(例: A1) | |
filePath | Yes | Excelファイルのパス | |
formula | Yes | 数式(=SUM(A1:A10)など、=で始まる) | |
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"
},
"formula": {
"description": "数式(=SUM(A1:A10)など、=で始まる)",
"type": "string"
},
"sheetName": {
"description": "ワークシート名",
"type": "string"
}
},
"required": [
"filePath",
"sheetName",
"cell",
"formula"
],
"type": "object"
}