Excel online is the online version of Microsoft's Excel service. It lets you create and modify workbooks and share them with other users so that multiple users can work on one workbook at the same time. This service works with paid Excel Online accounts only.
Triggers
-
New Row
Triggers when a new row is added to the specified workbook
-
New Sheet
Triggers when a new sheet is created in the specified workbook of a specific folder
-
New Row In Table
Triggers when a new row is added to the specified table
Actions
-
Add Rows
Add rows to the specified workbook
-
Add Rows to Table
Add rows to the specified table
-
Get Rows
Retrieve rows from the specified workbook
-
Get Table Rows
Retrieve the rows of the specified table
-
Update Rows
Update the rows of the specified workbook
Common Questions
To use Excel Online in your flow, you will first need to connect it with Built.io Flow.
To do this, drag any Excel Online action listed under Excel Online service on the canvas. In case of configuring Excel Online triggers, double-click on the Start icon on your canvas and select Excel Online service. Then, click on the Add New option listed under the Authorize Excel Online field in the configuration window. You will be prompted to authorize Built.io Flow to access your Excel Online account. Click on ALLOW.
After this, you will be prompted to confirm the Microsoft account you wish to use to create the authorization and sign in to it, in case you are not already signed in. Next, you will be redirected to canvas.
Rename the authorization as per your choice and click the ADD button. You can now see the added authorization under the Authorize Excel Online field. Once added, this authorization will be available in all Excel Online actions and triggers.
The Lookup only fetches workbooks with '.xlsx' extension. If your workbook has '.xls' extension, (in other words, if your workbook was saved as 'Excel 97-2003 workbook') you will first need to convert it to '.xlsx' format for it to be fetched in the lookup.
