LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Help on fonction Write to spreadsheet file

Hello,

 

I come on this forum to find a solution for my issue.

I have made a VI which acquires an input voltage and where the user can modify some parameters.

For each iteration of my while loop, I want to save the data in a csv file that's why I'm using the fonction Write to spreadsheet file.

But when I want to use this saved datas in csv format with Excel, the data were saved in string format so not a numeric. My purpose is to have some numerical datas and not strings because I can't do graphics or calculs.

 

As you can see on the csv saved file, only the iterations of the while loop (column C) are in a numerical format.

 

Here is my problem, thank you in advance for your help

Download All
0 Kudos
Message 1 of 3
(2,226 Views)

Looks like you're using regional decimal signs, try "%.;.3f" as format

 

/Y

G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
0 Kudos
Message 2 of 3
(2,211 Views)

I have forget to thank you.

My issue did not come from this but I've found a solution with the vi Write to TDMS file.

In fact this vi was more appropriate for this kind of applications

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