Excel Online activities

Note: It can take up to several minutes for the Microsoft API to register changes performed in an Excel file. This may lead to longer debug times for Excel activities and triggers, or to triggers not capturing events.

You must also be aware of when Excel files are updated. With Excel for Desktop, the database is updated when you click the Save button. With Excel Online, the database is updated when you close the Excel window.

Activity	Description
Add Sheet	Adds a sheet to the specified Excel workbook.
Create Workbook	Creates a new Excel workbook.
Delete Range	Deletes a cell range from the specified Excel workbook.
Delete Sheet	Deletes a sheet from the specified Excel workbook.
For Each Row in Workbook	Iterates through the rows in a specified range within a worksheet.
For Each Sheet in Workbook	Iterates through the sheets within a workbook.
Read Cell	Reads information from the indicated Excel workbook cell.
Read Range	Reads and saves the information from a specified Excel workbook cell range.
Rename Sheet	Renames a sheet from the specified Excel workbook.
Write Cell	Writes information in the indicated Excel workbook cell.
Write Range	Writes a DataTable variable to a specified Excel workbook cell range.
Write Row	Write a row in a selected workbook file using an Array Row or a Data Row.
Write Column	Write a column in a selected Excel file using an Array Column or a Data Column.
Delete Rows	Delete one or several rows from a specified position in a Workbook range. When you delete a row, the cells below are shifted up.
Delete Column	Delete a specified column from a sheet, table or range. The column on the right of the deleted column is shifted to the left.

Working with Excel activities

• It can take up to several minutes for the Microsoft API to register changes performed in an Excel file. This may lead to longer debug times for Excel activities and triggers, or to triggers not capturing events.
• You must also be aware of when Excel files are updated. With Excel for Desktop, the database is updated when you click the Save button. With Excel Online, the database is updated when you close the Excel window.
• Shortcuts are not fully supported in the activities, so they are not presented in the Browser widget.