Error -41117 Using Excel Get Data.Vi with LabVIEW Report Generation Toolkit

Updated Oct 9, 2018

Reported In

Software

  • LabVIEW Report Generation Toolkit
  • LabVIEW Full

Issue Details

When I run my LabVIEW report Generation Toolkit application, I get the following error using the Excel Get Data.VI:

Error -41117 occurred at NI_Excel.lvclass:Excel Get Data (str).vi -> Report Generation Toolkit Test.vi​

Possible reason(s):

Report Generation Toolkit: One or more cells contain invalid data or data that is incompatible with the specified data type.  Remove all invalid data, or specify a different data type.

 
The error is shown in the following dialog box.
 

Solution

When data is read from an Excel Report using the Excel Get Data.VI the following considerations have to be taken:
  • There are some characters that are supported in Microsoft Excel™  but not in LabVIEW, thus those characters can cause this error. In this way, it is not recommended to use this characters.
  • Some error expressions like #DIV/0! and #NUM! will also cause this behavior, in this way it is required to check that the cell that being read does not contain this type of expressions.
  • It is necessary to remember that the star (0,0)input of the Excel Get Data Function determine the cell that it is going to be accessed and that the indexing for this cell starts on 0. In this way, to map the Row 4 and Column E, the parameters that have to be used as input are 3 for the row and 4 for the column.

WAS THIS ARTICLE HELPFUL?

Not Helpful