Transform range
transform_rangeClean Excel ranges by removing duplicate rows, splitting text into columns, and filling cells down, right, or as a series.
Instructions
Remove duplicate rows, split text into columns, or fill down, right or as a series, like Excel's Data and Fill commands.
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": {
"path": "<path>",
"sheet": "<sheet>",
"range": "<range>",
"transform": "<transform>"
},
"name": "transform_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| range | Yes | ||
| sheet | Yes | ||
| transform | Yes |