Excel

Fill an Excel template with data

Upload a Base64-encoded Excel template and fill named cells, ranges, and tables with provided values. Formulas are recalculated automatically.

post/api/excel/fill-template

Request

  • Base URL: https://api.dokmatiq.com
  • URL: https://api.dokmatiq.com/api/excel/fill-template
  • Auth: API key in header X-API-Key

Request body

templateBase64string required

Base64-encoded Excel template file

valuesobject

Cell values to set (key = cell reference like 'Sheet1!A1' or named range, value = content)

tablesobject

Table data to insert at named ranges (key = range name, value = row data)

recalculateboolean

Recalculate all formulas after filling

passwordstring

Password to protect the filled workbook

Response

Filled XLSX file

Changes

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