How to Search for Data in Excel Spreadhseet Using NI Report Generation Toolkit ?

Updated May 8, 2023

Environment

Software

  • LabVIEW 2016 Full
  • LabVIEW 2016 Report Generation Toolkit

Other

  • Microsoft Office 2016

I am using the NI LabVIEW Report generation toolkit and would like to search for a particular element in an Excel Spreadsheet with the output being the Excel cell location where said element is found. How can I achieve this functionality?
 

To search through the contents of an Excel Spreadsheet, you need to follow these set of steps :
  1. Read the Excel sheet in the form of a 2D string array in LabVIEW by using the New report VI followed by the Excel Get Data VI.
  1. Search through this 2D array by using Array functions in the Array Sub Palette of the Functions Palette and find the index of the element in the 2D array.
  2. Use the Excel Set Location VI to convert the LabVIEW 2D array index into an equivalent Excel cell location.

 

Related Links

Report Generation Toolkit for Microsoft Office VI Reference

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement may be required, and support options vary by country.