En

Save Data Table#

Save the Data Table to an Excel document in .xlsx format.

Data Table[Data Table] The Data Table that needs to be saved in the Excel document.
File Path[Text] The path and name of the Excel document where the Data Table needs to be saved (file format .xlsx). The property must specify the actual file path.
Sheet[Number/Text] ID (ordinal number) or name of the sheet where the table will be written. Numbering starts from 1. If the value is not specified, the file name will be taken as the sheet name.
Password[Text/SecureString] Specify a password for saving the document. This password will be used when reading the document.
Write HeadersWhen enabled, the table headers will be written.
Overwrite FileWhen enabled, the file will be overwritten. Otherwise, the table will be overwritten on the specified sheet. If there is no sheet with such an ID (ordinal number) or with such a name, it will be added. Other sheets in the document will remain untouched.
Append to FileWhen enabled, the table data will be appended to the file. If the file does not exist, or there is no data yet, the table header will be written. If data already exists, the table header will be skipped.
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" - 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.