En

Upload Data Table#

Upload the "Data Table" from an Excel document.

Data Table[Data Table] The Data Table where data from the Excel document will be uploaded.
File Path[Text] The path to the Excel document from which information needs to be loaded into the Data Table. There is no need to open the file in advance using the "Open Document" block.
HeaderIf checked, the first row will be used as the header. Otherwise, the header will be absent.
Sheet[Number/Text] ID (serial number) or name of the sheet from which data needs to be read into the Data Table. Numbering starts from 1.
Read Password[Text/SecureString] Specify the password for reading the document if it was set during saving.
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 blocks will output during operation. Possible values:

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

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.