Format Conversion
XLSX 反透视规范化
将宽表(多列月份)反透视为长表(month/value)以便入库
file· 文件结果打开工具
快速开始
用三种语言从你的代码中调用此工具。
cURL
# 1) Request a presigned URL → returns { uploadUrl, storageKey }
curl -X POST 'https://api.elysiatools.com/api/upload/presign/xlsx-unpivot-normalizer' \
-H 'Content-Type: application/json' \
-d '{"filename":"excelFile.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-unpivot-normalizer' \
-F 'excelFile=uploads/2026/01/01/your-tool-1700000000000-abc123.ext' \
-F 'sheetName=Sheet1' \
-F 'headerRow=1' \
-F 'idColumns=name,region' \
-F 'valueColumns=Jan,Feb,Mar' \
-F 'keyColumnName=month' \
-F 'valueColumnName=value' \
-F 'outputMode=xlsx' \
-F 'dropEmptyValues=true' \
-F 'parseNumbers=true'