En

Open Document#

Open an Excel document.

Link to Excel[Link] Returns a link to the Excel document processing process
Link to Document[Link] Returns a link to the currently open Excel document being worked on
Use COMIf checked, the work will be done using the installed Excel. Otherwise, it will be done without it
Visibility

If the "Use COM" checkbox is checked and the "Visibility" checkbox is checked, the Excel interface will be displayed on the monitor screen.

If the "Use COM" checkbox is checked and the "Visibility" checkbox is unchecked, the work will be done with an instance of Excel that is physically loaded in memory, but the application window will remain hidden.

If the "Use COM" checkbox is not checked, the "Visibility" property will not be considered.

Read-OnlyIf enabled, the document will be opened with the "Read-Only" flag
File Path[Text] Path to the Excel document that needs to be opened
Read Password[Text/SecureString] Specify the password for reading the document if it was set during saving. If no value is specified and a password was set, the block will pause until the user enters the password
Write Password[Text/SecureString] Specify the password for writing to the document if it was set during saving. If no value is specified and a password was set, the block will pause until the user enters the password. You can enable the "Read-Only" property so that this password is not requested from the user
Update LinksEnable auto-update of links; otherwise, updates will not occur
Update AllUpdates all ranges of external data and pivot table reports
Fix Name Conflict ErrorIf enabled, an attempt will be made to fix the name conflict error when opening the Excel file. This function works only if COM mode is enabled
Error Handling Level

Select the error handling level. Possible values:

  • "Default" - default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value from the "Start" block of this diagram will be used

Message Level

Select the message level that the blocks will output during operation. Possible values:

  • "Default" - default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value from the "Start" block of this diagram will be used

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block's work