Skip to main content

Merge Excel

Merges contents of two excel sheets side by side. If the first Excel has Name, Location, Age columns and the second Excel has Surname and Company columns the final Excel will have all the columns.

Common Properties

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If ContinueOnError property is true, no error is caught when the project is executed even if Catch node is used.

Input

  • First File Descriptor - The descriptor of the first excel file to merge.
  • First Sheet Name - The name of the sheet to merge from the first excel file.
  • Second File Descriptor - The descriptor of the second excel file to merge.
  • Second Sheet Name - The name of the sheet to merge from the second excel file.