Run macros and formulas in Excel file

post

https://api.apispreadsheets.com/macro/{file_id}/

Run macros and formulas within your macro enabled Excel files (.xlsm)

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Path Params

file_id

string

required

^[A-Za-z0-9]{16}$

16-character alphanumeric file identifier.

Body Params

post_formula_actions

array of objects

List of actions to run after macros and formulas are executed

post_formula_actions

macros

string

required

Name of the macro to run from the Excel file

input_cells

object

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

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

Headers

accessKey

string

required

Access key credential unique to each file

secretKey

string

required

Secret key credential unique to each file

Responses

Language

Loading…

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

201Macro run result and requested outputs (if output_cells provided)

400Bad request.

401Unauthorized (keys invalid for existing file)

402Exceeded plan quota

404File not found

500Internal server error.