Exporting Dynamic data to a formatted excel-readable array

[msmartei]

Hi all,

I am trying to export some data into an excel sheet (csv) by creating a new file in which the data is stored. With the current set up that i have, i keep on running into the following problems:

1. After every iteration in a single run, a dialogue box pops up and asks me  where to save the data, after i have already specified a file name

2. The data format in the excel file is not what i wasnt. The data is all displayed as one string while i would like it to store the data in different columns.

Some background: In the section of the vi that i have attached, i use 2 DAQ assistants. The first is used to obtain the initial voltage value at the 2 piezos which is then fed into the rest of the vi, this needs to be done just once, at the beginning of the vi run. The second DAQ asst is used to monitor and save the voltage as it is gradually increased and applied to the piezos.

A picture of the section of the vi im having trouble with is attached, along with the entire vi.

I would appreciate any help you can give me on these problems.

Thanks!

[craigc]

I Cant run your vi at the moment but from what i can see.

- use the file open vi from the file I/O pallette rather than the Express file open VI you have and supply it with a proper path, not a string.

- I prefer to use .csv (Commas Seperated) instead of tab seperated as i find it easier to read in a string indicator or similar and is just as easy to open in excell.

- How many Samples is your 2nd Express DAQ function doing?  If it is multiple you will need to seperate the samples by comma also (or average them out etc).

- I rarely use dynamic data but i think you would be best to extract the actual data values out from the data type at least to get you up and running (It is coerced at the moment and may not be doing what you expect it to do).

craigc

Message Edited by craigc on 05-19-2009 03:24 AM