Do you mind if I ask one last question? I have been told now that they want all the data to be processed in Excel for them (someone has been giving them ideas...). To tackle this I have created an Excel template, cut the data up into manageable chunks (30,000*8) with array subset and then pasted the data into the right columns. Now all this is working fine 🙂
However I only see two ways of opening the data "Read from spreadsheet file.vi" and "Read DBL spreadsheet file". Now if I use the first it always converts the data into 0.00x and i need 0.0000x at least so I get whole swathes of zeros with the occasional 0.001! Even changing the "format" to "%.7f" or "%.7g" makes no difference? Do I have to dig into the code? Somewhere inside it it must have a constant set to "%3.f"??
Using the second vi I get a whole different problem, it doesn't seem to round the data but it can't recognize the correct tab points. I.e the date stamp is spread over the first 8 or so columns. is there a specific tab limiter I need to put in to the "write waveform to spreadsheet file" I tried "\t" to no avail!
Thanks
Jon
