writing data file

[Mike Parker]

Hi Guys,

Ive got 3 2d arrays, each cell having a waveform (dbl) with max of 1000 points in. The 3 arrays are for data from 3 seperate channels. Each column in the arrays represents one measurement process, there can be up to 10 and up to 256 rows.

So my ultimate goal is to get one columns worth of Waveforms into a spreadsheet, side by side.. ie

waveform1    |    waveform2 ... etc

       1                          1

       2                          2

       3                          3

       4                          4

       5                          5

At present im using various loops inside loops to access the right point inside the right waveform, convert them all into a string and csv them, stick it all in shift registers and write it at the end (now changed that to writing after every line to see if it speeded up but didnt make much odds). This works fine for small amounts of data but is just too slow for the amount i need it to do..

Ultimately i want to end up with a spreadsheet with 3 sheets, 1 per channel.

Hope ive explained that well...

From what ive read on other posts writing to CSV files is too slow and ive seen a number of you recommend binary files but ive not got a clue on how to use these and if i will ever be able to get them into excel (matlab is another option but is a little bit less accessible for me atm). If anyone can help that would be fantastic!!!

thanks

Mike

[RavensFan]

Post your code!  What do you consider too slow?  Where are the arrays coming from?  Are they coming from a Data Acquisition inside the same VI?

You might be able to use the Reshape Arrays function to go from a 10x256 to a 1x 2560 array for each of the 2-D arrays, then Build them together into a 3 x 2560 array.

If you're going to be putting them into Excel, then you will need to stick with text files such as CSV to be able to get Excel to open and convert them.

Message Edited by Ravens Fan on 02-27-2008 11:41 PM