Read from Spreadsheet File Does Not Return All Digits of Precision
Primary Software: LabVIEW Development Systems>>LabVIEW Professional Development System
Primary Software Version: 7.1
Primary Software Fixed Version: N/A
Secondary Software: LabVIEW Development Systems>>LabVIEW Full Development System, LabVIEW Development Systems>>LabVIEW Base Development System
I have a text based spreadsheet file in which each entry has 17 digits of precision. When I try to read it using Read From Spreadsheet File.vi I only get 6 digits past the decimal place.
As shipped, the Read From Spreadsheet File VI returns single precision numbers so it is only possible to return 17 digits of precision. The Read From Spreadsheet and Write From Spreadsheet VIs were written this way to minimize the memory cost of arrays which generally don't need more than the resolution provided by single precision floating points.
To allow Read From Spreadsheet File.vi to use more digits of precision perform the following:
KnowledgeBase 1RBDAG5P: Precision Errors Writing and Reading with Write to Spreadsheet File and Read from Spreadsheet File.vi
KnowledgeBase 34MDHKFQ: How Can I Display Spreadsheet Data with a Table Control in LabVIEW?
Report Date: 11/13/2001
Last Updated: 03/21/2014
Document ID: 2FC9DK2L