Write Data to Range#

Write data to a range.

Document R7[Link] Document R7, which was obtained when creating, opening a file, or connecting to the document.
Sheet

[Number/Text] ID (serial number) or name of the sheet where the Data Table needs to be copied.

Numbering starts from 1.

Range[Text] The upper left cell that will become the first cell for the inserted Data Table (e.g., "A1:B3").
Table[Data Table] The Data Table that needs to be inserted into the Excel document.
Write HeadersWhen enabled, the table headers are written.
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 of the "Start" block of this diagram will be used.

Message Level

Select the level of messages that will be output by the blocks during operation.

Possible values:

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

If "Default" is selected, the value of 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.