Home Community Example Programs Example Code Document

Example Code

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ASK A QUESTION

Error -2147352571 When Reading Excel Data in LabVIEW Using ActiveX

by: Member
‎05-19-2023 10:12 AM

Products and Environment

This section reflects the products and operating system used to create the example.

To download NI software, including the products shown below, visit ni.com/downloads.

    Software

  • LabVIEW

Code and Documents

Attachment

Description

This example covers how you can fix error -2147352571 from the Variant To Data Function in LabVIEW when reading cells which include an error such as #DIV/0. The example is applicable when you are reading data from a Microsoft Excel sheet using ActiveX.

How to Use

Error -2147352571 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, error -2147352571 will occur. But, if you try to convert the variant data into a numeric array, you can avoid the error.

Related Links

Using ActiveX with LabVIEW - LabVIEW Help

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

0 Kudos