Excel Find and Replace VI

LabVIEW 2018 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2018

Part Number: 370274M-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Excel General VIs

Requires: Report Generation Toolkit

Searches the occurrences of searched string and replaces them with a new string or numeric value. The data type you wire to the replacement input determines the polymorphic instance to use.

You can use this VI to generate reports from templates. Insert string placeholders in the template, and use the VI to replace them with actual values.

Use the pull-down menu to select an instance of this VI.

Excel Find and Replace (num)

report in is a reference to the report whose appearance, data, and printing you want to control. Use the Create Report VI to generate this LabVIEW class object.
searched string describes the string to search for and replace.
replacement is the number that replaces instances of searched string.
format string specifies the number formatting to use when LabVIEW converts the numbers to characters. Use format string when you wire numeric data to the replacement input.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
report out is a reference to the report whose appearance, data, and printing you want to control. You can wire this output to other Report Generation VIs.
found? returns TRUE if the VI finds at least one occurrence of the searched string.
error out contains error information. This output provides standard error out functionality.

Excel Find and Replace (str)

report in is a reference to the report whose appearance, data, and printing you want to control. Use the Create Report VI to generate this LabVIEW class object.
searched string describes the string to search for and replace.
replacement is the string that replaces instances of searched string.
format string specifies the number formatting to use when LabVIEW converts the numbers to characters. Use format string when you wire numeric data to the replacement input.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
report out is a reference to the report whose appearance, data, and printing you want to control. You can wire this output to other Report Generation VIs.
found? returns TRUE if the VI finds at least one occurrence of the searched string.
error out contains error information. This output provides standard error out functionality.

WAS THIS ARTICLE HELPFUL?

Not Helpful