Why Am I Losing Precision With Excel Easy Table VI?

Updated Aug 14, 2018

Reported In

Software

  • LabVIEW 2015

Other

Software
  • LabVIEW 2015

Issue Details

When using the Excel Easy Table VI to generate a report, the data within LabVIEW has all of the precision it should, but when I write the data to an Excel file, the data is truncated and precision is lost. How can I make all of my data show up in the Excel sheet?

Solution

  1. Wire the array of data through a Number to Fractional String block before wiring it into the Excel Easy Table VI.
  2. Wire the desired precision after the decimal point to the precision input. This defaults to 6 if unwired.
  3. Wire the output from the Number to Fractional String block into the Excel Easy Table VI.
An example of this code is pictured below.

Additional Information

In LabVIEW 2015, the Excel Easy Table VI defaults the representation of double precision numbers directly wired into the Excel Easy Table to 3 decimal points. By converting the data to an array of strings before wiring it into the Excel Easy Table VI, we can control the precision of the representation of the data written to the report and keep any precision of the data that we have.

WAS THIS ARTICLE HELPFUL?

Not Helpful