Error -41117 Using Excel Get Data VI With LabVIEW Report Generation Toolkit

Issue Details

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.

Solution

• 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.