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

Updated Aug 8, 2018

Reported In

Software

  • LabVIEW 2016 Full
  • LabVIEW 2016 Report Generation Toolkit

Other

  • Microsoft Office 2016

Issue Details

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 ?

Solution

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.

WAS THIS ARTICLE HELPFUL?

Not Helpful