LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to get more decimals with the Excel Get Data.VI?

Like the title says, is it possible to get more than 2 decimals with the Excel Get Data.VI from the Report Generation Toolkit? Writing more decimals is no problem but if I get the data from the Excel file it will only give me more decimals when I manually fill in the data in the excel sheet. If I use the RGT to write the data, it won't return more than 2 decimals.

 

*The data that only returns 2 decimals is created with a formula in Excel

0 Kudos
Message 1 of 3
(2,674 Views)

Just a thought without really looking at it, but you could always get the data as a string and then convert to your desired precision afterwards.

---
CLA
0 Kudos
Message 2 of 3
(2,631 Views)

I don't really know how or why, but I tried some different things in the Excel Get Data.VI and suddenly I get more decimals, but as far as I know all the settings are back to original.. Using a double now and it works for what I need, thanks anyway!

0 Kudos
Message 3 of 3
(2,604 Views)