Excel Operation Legacy Action

Workflow tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
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

Set Cell Color

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