Microsoft Excel
Read and write Excel workbook ranges, tables and worksheets (Microsoft Graph workbook API, OAuth2).
OCNORA ships 9 typed Microsoft Excel operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.
Before you connect Microsoft Excel
- Authentication
- OAuth 2.0
- Credential
- {"client_id": "…", "client_secret": "…", "refresh_token": "…"} with the Files.ReadWrite delegated scope
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Microsoft Excel
Operations, grouped by what they do to your data.
Create and send 2
Read and search 5
Other operations 2
A sample Microsoft Excel workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Microsoft Excel trigger is needed.
- 2Read Rangems_excel.get_rangeRead the values, text and formulas of one A1 range on a worksheet, e.g. A1:D10.
- 3Add Table Rowsms_excel.add_table_rowsAppend one or more rows to a table. Batching the rows into a single call is far faster than one call per row.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 9
- Add Table RowsAppend one or more rows to a table. Batching the rows into a single call is far faster than one call per row.ms_excel.add_table_rows
- Recalculate WorkbookForce Excel to recalculate the workbook, so formulas written by an earlier step are evaluated before the next step reads them.ms_excel.calculate
- Create Workbook SessionOpen a workbook session and return its id, so a run of several reads and writes shares one Excel transaction instead of one per call.ms_excel.create_session
- Read RangeRead the values, text and formulas of one A1 range on a worksheet, e.g. A1:D10.ms_excel.get_range
- Read Used RangeRead the whole populated area of a worksheet, without needing to know how far the data goes.ms_excel.get_used_range
- List Table RowsRead a table's rows, following Graph paging up to max_results.ms_excel.list_table_rows
- List TablesList the named tables in a workbook, with their ids and names.ms_excel.list_tables
- List WorksheetsList the worksheets in a workbook, with their names and positions.ms_excel.list_worksheets
- Write RangeWrite values, formulas or number formats into one A1 range. Each is a two-dimensional array shaped exactly like the range.ms_excel.update_range
Microsoft Excel questions
- How does OCNORA authenticate with Microsoft Excel?
- With a stored OAuth 2.0 credential, shaped {"client_id": "…", "client_secret": "…", "refresh_token": "…"} with the Files.ReadWrite delegated scope. A connection test can check it when you add it.
- What can I automate with Microsoft Excel?
- 9 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Microsoft Excel operation I need is not listed?
- Where Microsoft Excel has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Microsoft Excel?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Microsoft Excel calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
See your first Microsoft Excel workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.