Excel Operations
Excel operations enable you to interact with Microsoft Excel files by extracting and manipulating their data.
-
Use Excel Controlled Loop to iterate over data from an Excel file.
-
The Excel Session is an element that encompasses Excel operations, except for Execute Excel Macro. Excel operations include reading, modifying, and creating entire files and file elements in Excel format.
-
Run a macro in an Excel file or sheet. This action step doesn’t run inside an Excel Session.
-
Use Read from Excel File to read the contents of an Excel file.
-
Use Recalculate Excel File to recalculate the values of an Excel sheet.
-
Use Save Excel File to save the contents of an Excel file.
-
Use Write to Excel File to write content to the selected Excel file. You can write the content to the same file or to a new destination file.