Convert Excel Binary to Fixed Width using an API

Use our API to convert your Excel Binary Workbook data to Fixed Width/Fixed Length

Convert to
POST https://dataconverter.io/api/v1/convert/xlsb-to-fixed-width

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
    {
      "fields" : [ {
        "name" : "title",
        "width" : 12,
        "fillChar" : null,
        "skip" : false,
        "align" : "LEFT"
      }, {
        "name" : "name",
        "width" : 4,
        "fillChar" : null,
        "skip" : false,
        "align" : "LEFT"
      }, {
        "name" : "price",
        "width" : 5,
        "fillChar" : null,
        "skip" : false,
        "align" : "LEFT"
      } ]
    }
Request Sample

curl -X POST "https://dataconverter.io/api/v1/convert/xlsb-to-fixed-width" \
-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={\"fields\":[{\"name\":\"title\",\"width\":12,\"fillChar\":null,\"skip\":false,\"align\":\"LEFT\"},{\"name\":\"name\",\"width\":4,\"fillChar\":null,\"skip\":false,\"align\":\"LEFT\"},{\"name\":\"price\",\"width\":5,\"fillChar\":null,\"skip\":false,\"align\":\"LEFT\"}]};type=application/json" \
--output converted.txt
          
Show All APIs