Excel Object

Description

This action component allows you to open/create an Excel workbook.

Input Properties

• File Path (String) – The path of the Excel file you want to use.
• Is Visible (Boolean) – Show Excel file is opened in the foreground while performing actions on it.
• Create New If Not Exist (Boolean) – Creates a new Excel workbook when the workbook cannot be found at the specified path.
• Read Password (String) – The password required for opening password protected Excel workbooks.
• Write Password (String) – The password required for editing password protected Excel workbooks.
• Input Excel Object (IExcelObject) – The input Excel Object connection.
• Body (IExcelObject) – The actions you want to execute within the Excel application.
• Timeout (Int32) – The connection timeout.

Output Properties

• Result (IExcelObject) – The Workbook application connection object will be stored as IExcelObject object.

General Properties

• Global Waits (Checkbox) – Apply global waits when PreWait or PostWait are not specified.
• Ignore Error (Checkbox) – Continue the process flow without throwing error.
• Post Wait (Checkbox) – Apply specified wait after execute the action.
• Pre Wait (Checkbox) – Apply specified wait before execute the action.