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.
Thanks
mhaque
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-08-2011 11:27 AM
03-09-2011 09:50 AM
Is there any way to write exactly how the numbers and letters appear in the array prior?
Thanks
mhaque
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.
Lynn
03-09-2011 10:32 AM
@mhaque wrote:
Is there any way to write exactly how the numbers and letters appear in the array prior?
Thanks
mhaque
Yes,
(CCT would have done that differernt)
Use the format string property on an element of the array
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).