Loss of very small order values during excel exportation

[mattecst]

There you go.

The Write to Measurement File function is at the end, all to the right.

[ben64]

The Write To Measurement File Express vi uses the %g format to convert a number to a spreadsheet string. This formatting works fine with 4.457E-12. In the resulting excel file, what is the cell format of the faulty result? Since it is a string that contain both digits and letters the format is probably set to General (or Standard, I don't have an English version of Excel) and that may cause the issue. Try formatting the cell to scientific with enough decimals.

Ben64

[mattecst]

Doesn't change anything 

I believe it's not an Excel issue because as I posted before nubers until the 6th place after the decimal mark are reported.

I need to expand the digit I can carry after the exportation.

[Taki1999]

I think this Forum post still applies and you're running into a limitation of the Express VI when exporting to Excel. You can export to other formats fine.

[RavensFan]

I've trimmed down and am experimenting.  I'm seeing the same issues with the conversion.  I'm trying to dig deeper into the Express VI to see where it is happening.

[mattecst]

I see, but I need the excel file I guess I'll multyply to a power of 10 to elide some zeroes.

Thank you though 

[Taki1999]

---

@mattecst wrote:

I see, but I need the excel file I guess I'll multyply to a power of 10 to elide some zeroes.

Thank you though 

---

Do you really need the Excel? A lot of times people think they need Excel but they'll get all the same behavior from a .csv. Rather than multiply by powers of 10, the other option would be to dig into the ActiveX Excel calls and push the data that way.

[aputman]

You don't really export an excel file with this function.  You may be naming it with an XLSX file extension but it is just a delimited text file.  You can confirm whether it's excel causing the issue by opening the file in a text editor.  

[Taki1999 · Accepted solution]

---

@aputman wrote:

You don't really export an excel file with this function.  You may be naming it with an XLSX file extension but it is just a delimited text file.  You can confirm whether it's excel causing the issue by opening the file in a text editor.  

---

With the Express VI, it looks like it does actually export an Excel file. Write to Measurement File actually creates binary files. Write to Spreadsheet or Write Delimited create much happier text delimited files.

[mattecst]

I don't really need an excel file what I need a convenient and organized table where I can see al the values.

Is it possible with the .csv?