Format Conversion
XLSX Datenvalidierungs-Dropdown-Manager
Erstellt Batch-Dropdowns, abhaengige Kaskaden und Eingabehinweise
file· DateiergebnisWerkzeug öffnen
Schnellstart
Rufen Sie dieses Werkzeug aus Ihrem Code in drei Sprachen auf.
cURL
# 1) Request a presigned URL → returns { uploadUrl, storageKey }
curl -X POST 'https://api.elysiatools.com/api/upload/presign/xlsx-data-validation-dropdown' \
-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/de/api/tools/xlsx-data-validation-dropdown' \
-F 'workbookFile=uploads/2026/01/01/your-tool-1700000000000-abc123.ext' \
-F 'rulesJson=[
{
"type": "list",
"sheetName": "Input",
"target": "B2:B50",
"values": [
"Open",
"Pending",
"Closed"
],
"promptTitle": "Status",
"prompt": "Choose a workflow status"
},
{
"type": "cascade",
"sheetName": "Input",
"parentTarget": "C2:C50",
"childTarget": "D2:D50",
"mapping": {
"Hardware": [
"Laptop",
"Monitor",
"Keyboard"
],
"Software": [
"CRM",
"ERP",
"Analytics"
]
},
"parentPromptTitle": "Category",
"parentPrompt": "Choose a category first",
"childPromptTitle": "Item",
"childPrompt": "Then choose an item"
}
]'