excel data to daq card incrementally

[joshlismore]

Hi,

I have an simplfied excel file with 4000 voltage reading varying from 0 to7 volts. I need to feed these values into the DAQ card that will send out analogue signal that will drive a proportional control valve. The output voltage has to change ever 2 seconds. The version of labview I am using is 8.2 and a PCI 6259 DAQ card. Can anybody give me some advice as to what to do as I'm a beginner in terms of contructing vi's.

Thanks in advance,

josh

[Dennis_Knutson]

Save the excel file as a tab delimited text file. Then you could use the Read From Spreadsheet File to get an array. Feed the array through a for loop which will auto-index the array. Inside the array would be a DAQmx set for single value write. With a delay function, you would output every value. When the last element is sent, the VI would stop. Is that what you need to do?

[joshlismore]

Ya this is what i want to do. i've written this program but it doesn't seem to work as it only works for about 5 seconds and it ends. when i test the CB-68LP with a mutlimeter it doesn't output any voltage. I also have the program feeding back data from an anemometer that is down stream of the the control valve. the attached program shows what i've done so far.

[joshlismore]

here is the associated .txt file that i need it to run

[Dennis_Knutson]

You've got nothing correct except for the file read. First, configure the DAQ Assistant for 1 Sample output. It's not configured to do anything at all right now. Take the 1D array and wire it directly to the for loop. Wire this to the Signals input of the DAQ Assistant. Add a delay function in the for loop. Wire your dt to this.

The CB68 is nothing more than a dumb terminal block so I would hope you have an actual DAQ card that outputs a voltage.

Just saw your file. Your Index Array is incorrect. It's column 0 that you want. Array indexes are zero based.

Message Edited by Dennis Knutson on 03-04-2009 08:13 AM

[joshlismore]

Cheers thanks for your help. I've created the vi like you said but it keeps crashing the system. how do i say the excel file so it is in the correct format so that the program can accept the data coming in? I do have a DAQ card as I tested the output voltage in MAX and used a multimeter.

[Dennis_Knutson]

In Excel - File>Save As>Text (tab delimitted).