Convert Binary .xlsx to JSON

1 min

takes the base64 binary data of an excel file and converts rows from the first sheet in a json list api definition { "tab" "examples", "url" "https //orca pathfix com/functions/web/exceltojson", "name" "excel to json api", "method" "post", "request" { "pathparameters" \[], "queryparameters" \[], "headerparameters" \[], "bodydataparameters" \[], "formdataparameters" \[] }, "results" { "languages" \[ { "id" "28usdqyeh3qrdmtvamsqt", "code" "{\n \\"output\\" \[\n {},\n {}\n ]\n ]\n}", "language" "200" }, { "id" "yix64dyiudpjgbrfsfawb", "code" "{\n \\"message\\" \\"error\\"\n}", "language" "404" } ], "selectedlanguageid" "28usdqyeh3qrdmtvamsqt" }, "examples" { "languages" \[ { "id" "encjz9tstg38f0x taa4x", "code" "{\r\n\t\\"input\\" {\r\n\t\t\\"sheet name\\" \\"sheet1\\",\r\n\t\t\\"file\\" \\"\<binary base64 file>\\"\r\n\t}\r\n}", "language" "json" } ], "selectedlanguageid" "encjz9tstg38f0x taa4x" }, "description" "\ncall the following api ", "currentnewparameter" { "label" "body parameter", "value" "bodydataparameters" } }