Format Conversion
XLSX 公式注入器
按列批量填充公式，并可锁定公式单元格用于模板保护和只读区域
file· 文件结果打开工具
快速开始
用三种语言从你的代码中调用此工具。
cURL
# 1) Request a presigned URL → returns { uploadUrl, storageKey }
curl -X POST 'https://api.elysiatools.com/api/upload/presign/xlsx-formula-injector' \
-H 'Content-Type: application/json' \
-d '{"filename":"workbookFile.ext","contentType":"application/octet-stream","size":12345}'
# 2) PUT the file bytes directly to the presigned uploadUrl
curl -X PUT '<presigned uploadUrl>' \
--data-binary @/path/to/file.ext
# 3) Call the tool, passing the returned storageKey for each file field
curl -X POST 'https://api.elysiatools.com/zh/api/tools/xlsx-formula-injector' \
-F 'workbookFile=uploads/2026/01/01/your-tool-1700000000000-abc123.ext' \
-F 'formulaRulesJson=[
{
"sheetName": "Sheet1",
"targetColumn": "D",
"startRow": 2,
"endRow": 12,
"formulaTemplate": "=IF($A{{row}}=\"\",\"\",$B{{row}}*$C{{row}})",
"numberFormat": "#,##0.00",
"styleSourceRow": 2
}
]' \
-F 'editableRangesJson=[
{
"sheetName": "Sheet1",
"range": "A2:C12"
}
]' \
-F 'protectSheets=true' \
-F 'lockFormulaCells=true' \
-F 'hideFormulaText=false' \
-F 'sheetPassword='