Skip to main content

Find and Replace

Finds and replaces a specific value in an excel file.

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​

  • Excel File Descriptor - The id of the excel file to search in. This ID is generated by the Open Excel or the Create Excel node.
  • Find - The value to search for
  • Replacement - The value to replace with

Options​

  • Format - The data format of the Replacement value
  • Search By Regex - Uses Regular Expression to search for a pattern in the sheet.

OptFormat property has 4 possible values. They are:

  • String
  • Number
  • DateTime
  • Boolean