03-08-2011 11:22 AM
Right now it only shows to 4 decimal places. I want it to write all (or as many as possible) decimal figures and if necessary in scientific notation.
Please let me know if this can be done.
03-08-2011 11:27 AM
What do you have wired up to the format input at the top of the VI? If it is unwired, it defaults to %.3f which is 3 decimal places. For other formats, check the help file.
03-09-2011 10:11 AM
If you cannot format the data the way you want using the format string input to the Write to Spreadsheet File.vi, then format the data to a string yourself. Use the Write to Text File.vi to write the formatted string to the file. We wrote some rather complicated file formats long before the Write to Spreadsheet File.vi was available.
03-09-2011 10:32 AM
03-10-2011 08:25 AM
Note that a double has about fifteen digits of resolution (timestamps have about thirty). Make sure you save as much resolution as you need (max about fifteen digits for DBL data type - Excel will not handle any more, in any case).