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 all Excel operations. Excel operations include the reading, modification, and creation of entire files and file elements in the Excel format.
-
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.