Excel

Microsoft integration · 7 node(s).

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

Add your credentials as a Flomation environment secret, then pick them in each node. The connection fields are:

Pick an Environment on your flow (Flow Settings → Environment) so the secret resolves. Secret fields never show the value — they reference ${secrets.your_secret}.

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]]
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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]]
Microsoft Account (email)	`string`
Microsoft OAuth Credential	`credential`		${credentials.MICROSOFT_EXCEL}

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.