Documents

Convert an Excel sheet to JSON

Reads one sheet of an .xlsx workbook into an array of objects (or arrays with header=false). Formulas come through as their calculated result. A column with an empty header cell is named col_N (N = its position in the sheet, from 1) and a repeated header gets _2, _3... so no column is lost. Cells to the right of the last header cell are ignored. Up to 1,000 columns.

Costs 1 credit per call.

post/excel-to-json

Request

  • Base URL: https://api.cofferdock.com
  • URL: https://api.cofferdock.com/excel-to-json
  • Auth: API key in header x-api-key

Request body

filestring byte required

The Excel workbook to read, as a base64-encoded .xlsx file (the older .xls format is not supported).

sheetstring

Sheet name or 0-based index. Default: first sheet.

headerboolean

true (default) = the first row holds the column names, so each row becomes an object (an empty header cell becomes col_N and a repeated name gets _2, _3...); false = each row becomes an array of values.

Response

Result.

successboolean

Changes

No recorded changes to this operation across all 1 revision of this API.