Create Document#

Create 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 open Excel document currently 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.

Sheet[Number] Returns the ID of the sheet, i.e., its ordinal number
Sheet Name[Text] The name of the sheet where further actions will take place
Error Handling Level

Select the error handling level. Possible values:

  • "Default" - by 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 blocks will output during operation. Possible values:

  • "Default" - by 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