Excel Operation Action

Workflow tab

1. Write Variables option forces package action to save variables values into the log file before the execution.
2. It is usually used for debugging and not recommended for production environment.
3. It can be globally disabled using options dialogue

Advanced tab

Check If Sheet Exists

Add Sheet

Check Excel File

Change Excel File Extension

Read Single Excel Cell value

Rename Excel Sheet

Set Active Sheet

Keep Sheet

List Sheets

After execution tab

Specifies which variables will be set once action execution is completed

Use “Check file option” to check if the excel file format is supported

How to read a single excel cell value

Video Tutorial