Écriture scientifique

[C.A]

Bonjour,

Dans le cadre de mon programme concernant des taux de fuite, je doit exporter la valeur du taux de fuite dans un excel (valeur proche de 5x10^-4) j'utilise donc une variable puis que j’écris, mais lors de l'écriture je m'aperçois qu'il supprime mes zéros par exemple au lieu de 5x10^-4, j'obtiens 5x10^0. 

Saurez-vous comment résoudre ce problème ?

Hello,

As part of my leak rate program, I have to export the leak rate value to an excel (value close to 5x10 ^ -4) so ​​I use a variable then I write, but when writing I realize that it removes my zeros for example instead of 5x10 ^ -4, I get 5x10 ^ 0.

Will you know how to fix this problem?

[AeroSoul]

Have you confirmed the problem is with excel and not when writing values in labview?

In either case, it could be that you are using wrong format to pass these values around.

[GerdW]

Hi CA,

---

@C.A wrote:

As part of my leak rate program, I have to export the leak rate value to an excel (value close to 5x10 ^ -4) so ​​I use a variable then I write, but when writing I realize that it removes my zeros for example instead of 5x10 ^ -4, I get 5x10 ^ 0. Will you know how to fix this problem?

---

How do you "export" the data?

Why do you need a "variable" to do so?

Why don't you attach an example VI to explain your problem?

Why do you use a numeric format of "5x10^-4" instead of the usual "5E-4"? Excel (and LabVIEW) cannot deal with "5x10^4" formatting!

[C.A]

This is the switch between LabVIEW and Excel, I am using the % _3e data format.

[GerdW]

Hi CA,

---

@C.A wrote:

This is the switch between LabVIEW and Excel, I am using the % _3e data format.

---

Excel usually can deal with such values:

[C.A]

I have attached part of my program, the part that deals with this data is framed.

Regarding the format, I wrote a mistake when I made my request on the forum, my bad.

I apologize in advance for the mess in my VI.

About the variable, it comes from a calcul performed in a previous loop.

[GerdW]

Hi CA,

---

@C.A wrote:

I have attached part of my program, the part that deals with this data is framed.

---

Well, you attached an image of a part of your program.

I cannot debug that image because of two reasons:

• LabVIEW in general cannot debug/run/edit images of code
• I don't have MSOffice installed and so cannot use any RGT functions to verify your problem…

[cstorey]

Is this a localization setting problem?   Using Windows/Office with comma separated numbers vs LabVIEW with period separated numbers? 

See the summary of localization issues here - https://forums.ni.com/t5/LabVIEW/decimal-point-format-period-comma/m-p/1325485/highlight/true#M54105...

What are your Windows settings? What format is the Excel column? 

[C.A · Accepted solution]

I managed to solve the problem by uninstalling and installing LabVIEW, don't know where the problem came from though.

Thanks for ur help.