Open Excel File Step and Close Excel File Step

Brief description

These steps open and close the connection to the selected Excel file. It is always use both steps, you can't close it without opening it first, and conversely

 Step Information

Step Name (Not required)– the custom name of the process step that labels the editor’s process step box

Open Excel File

Input Parameters

• Excel file path (Required) - existing variable name or value that specifies the full path to Excel file
• Excel instance name (Required) – value that specifies the unique connection instance name

Close Excel File

Input Parameters

• Excel instance name(Required) – value of the unique connection instance name previously defined in the Open step
• Save file  (Required)– the indicator that defines whether the changes made in the selected Excel file should be saved. 
  • T (true)
  • F (false- default value)

Additional comments

The Close Excel File step’s 'Excel instance name' text box contains the list of the instance names previously defined in the Open Excel File step/s.