API Reference

Run spreadsheet formulas

post
https://api.apispreadsheets.com/calculate//

Run formulas in Excel (.xlsx/.xlsm) files and/or Google Sheets and return computed results.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required
^[A-Za-z0-9]{16}$

16-character alphanumeric file identifier.

Body Params
input_cells
object
required

Cells to write before calculation. Keys are sheet names; values are A1 cell maps. Pattern: {"Sheet1": {"A1": "Awesome", "B123": "cool"}, "Sheet2": {"C2": "dope"}}

output_cells
object
required

Cells to read after calculation. Keys are sheet names; values are arrays of A1 references. Pattern: {"sheet1": ["A1", "b2", "c2"], "sheet2": ["c1"]}

boolean
Defaults to false

If true, saves the file after calculation.

Headers
string
required

Access key credential unique to each file

string
required

Secret key credential unique to each file

Responses

Updated 11 months ago

Did this page help you?
Language
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 11 months ago

Did this page help you?