Convert Excel Binary to ORC using an API

Use our API to convert your Excel Binary Workbook data to Apache ORC

Convert to

POST https://dataconverter.io/api/v1/convert/xlsb-to-orc

Try API Free

After signing up and verifying your email, you will be able to create an API Token in your account settings.

Headers

Authorization (required) Bearer <<YOUR_API_TOKEN_HERE>>

Request Body — (multipart/form-data)

file (required) string <binary>

uploadSettings

object

{
  "sheetName" : "Sheet1",
  "startingRow" : 0,
  "lastRow" : 100,
  "startingColumn" : 0,
  "skipEmptyRows" : true,
  "fieldNamesInFirstRow" : true,
  "evaluateExpressions" : true,
  "useSheetColumnCount" : false
}

downloadSettings

object

{
  "useTimestampInstant" : false,
  "overwrite" : true,
  "isUTC" : false,
  "writeUuidAsString" : true,
  "rowBatchVersion" : "ORIGINAL",
  "bigDecimalPrecision" : 38,
  "bigDecimalScale" : 10,
  "roundingMode" : "HALF_UP",
  "compressionKind" : "NONE"
}

Request Sample


curl -X POST "https://dataconverter.io/api/v1/convert/xlsb-to-orc" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.xlsb;type=application/application/vnd.ms-excel.sheet.binary.macroEnabled.12" \
-F "uploadSettings={\"sheetName\":\"Sheet1\",\"startingRow\":0,\"lastRow\":100,\"startingColumn\":0,\"skipEmptyRows\":true,\"fieldNamesInFirstRow\":true,\"evaluateExpressions\":true,\"useSheetColumnCount\":false};type=application/json" \
-F "downloadSettings={\"useTimestampInstant\":false,\"overwrite\":true,\"isUTC\":false,\"writeUuidAsString\":true,\"rowBatchVersion\":\"ORIGINAL\",\"bigDecimalPrecision\":38,\"bigDecimalScale\":10,\"roundingMode\":\"HALF_UP\",\"compressionKind\":\"NONE\"};type=application/json" \
--output converted.orc

Show All APIs