Excel integration | Flomation Support

00Overview

Microsoft Excel Online spreadsheet operations

Every field below is exactly what you see in the Flomation editor. Fields marked ● live picker let you choose from a list pulled live from your account — no IDs to look up.

01Connecting Excel

Excel signs in with a Microsoft account you connect to Flomation — there is no API key or secret to paste. Connect the account once and every Excel node picks it up automatically. Two optional fields let you steer it:

Field	Type		Details
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

Good to know

Connect the Microsoft account to your Flomation user once — the same grant covers every Microsoft node, so you do not repeat it per flow. The optional Microsoft OAuth Credential field never shows a token: it references a managed credential (e.g. ${credentials.GOOGLE_DRIVE}), not an environment secret. Leave both fields blank and the node just uses your connected account.

02Append

Append Rows

microsoft/excel/append_rows · Action

Append rows to a table in a Microsoft Excel Online workbook

Field	Type		Details
Workbook Item ID	`string`	Required
Table Name	`string`	Required	Table1
Rows to append	`rows`	Required	[["Alice",30],["Bob",25]]

Returns: tool_result, row_index, success, error

03Clear

Clear Range

microsoft/excel/clear_range · Action

Clear contents or formatting from a cell range in an Excel workbook

Field	Type		Details
Workbook Item ID	`string`	Required
Worksheet Name	`string`	Required	Sheet1
Cell Range	`string`	Required	A1:D10
Clear Mode	`string`		choices: All, Formats, Contents

Returns: tool_result, success, error

04Create

Create Workbook

microsoft/excel/create_workbook · Action

Create a new Excel workbook in OneDrive

Field	Type		Details
Filename	`string`	Required	report.xlsx
Folder Path	`string`		Documents/Reports

Returns: tool_result, item_id, web_url, success, error

05Get

Get Workbook Metadata

microsoft/excel/get_metadata · Action

Retrieve metadata for a Microsoft Excel Online workbook

Field	Type		Details
Workbook Item ID	`string`	Required

Returns: tool_result, workbook, success, error

06List

List Worksheets

microsoft/excel/list_worksheets · Action

List all worksheets in a Microsoft Excel Online workbook

Field	Type		Details
Workbook Item ID	`string`	Required

Returns: tool_result, worksheets, count, success, error

07Read

Read Range

microsoft/excel/read_range · Action

Read a cell range from a Microsoft Excel Online workbook

Field	Type		Details
Workbook Item ID	`string`	Required
Worksheet Name	`string`	Required	Sheet1
Cell Range	`string`	Required	A1:D10

Returns: tool_result, values, row_count, column_count, data, success, error

08Write

Write Range

microsoft/excel/write_range · Action

Write values to a cell range in a Microsoft Excel Online workbook

Field	Type		Details
Workbook Item ID	`string`	Required
Worksheet Name	`string`	Required	Sheet1
Cell Range	`string`	Required	A1:D3
Values (JSON 2D array)	`text`	Required	[["Name","Age"],["Alice",30]]

Returns: tool_result, success, error

09Notes & Limitations

Behaviours and constraints worth knowing before you build with these nodes.

Appending rows requires an existing named table object in the worksheet; a plain sheet with no defined table cannot receive appended rows until one is created.
Writing to a range requires the values you supply to match the target range's shape exactly — the same number of rows and columns — or the write is rejected.
These nodes operate on modern .xlsx workbooks stored in OneDrive or SharePoint only; legacy .xls files and workbooks held outside cloud storage are not supported.
Changes made through these nodes can take a short time to become visible, and edits may conflict if the same workbook is open in the Excel desktop or browser app at the same time.
Reading or clearing very large ranges is slower and more likely to hit request-size limits, so bound the range to the cells you actually need rather than referencing an entire sheet.