I am using LabVIEW and trying to read data from an Excel sheet using ActiveX. When reading cells which include an error such as #DIV/0, I get an error -2147352571 from Variant To Data Function in LabVIEW. How can I fix this?
This error can be caused by a data type mismatch. Please try to change the data type that you connect to the type terminal of the Variant To Data Function.An example program is attached below. If you try to convert variant data read from Excel cells which include error #DIV/0 into a string array, the error -2147352571 will occur. But if you try to convert the variant data into a numeric array, you can avoid the error.
Thank you for your feedback.
You changed your response to Not Helpful
You changed your response to Helpful
Using ActiveX with LabVIEW - LabVIEW Help
Collaborate with other users in our discussion forums
A valid service agreement may be required, and support options vary by country.