Can someone show me how to get the data from this vi into four columns in a spreadsheet file.

[BWMPDINC]

I am trying to get the data into four columns in a spreadsheet. The data consists of two strings and two measurements, a max voltage and a voltage after x seconds. I have attached the code. Any help would be great. Thanks.

[nyc_(is_out_of_here)]

Help -> Examples

[crossrulz]

Where are you having problems?

[String_Theory]

Try removing the array to spreadsheet and have the array index. Then connect that terminal to the 2d array terminal on the Write to Spreadsheet.

Like this

Hope this helps

but, your question was "Can someone show me how to get the data from this vi into four columns in a spreadsheet file?"

So, I guess the real answer would be: "yes"

[BWMPDINC]

I'm getting the data I'm supposed to get, I want the data from each iteration to be placed in a single row, it should be four columns of data in each row. The first being user input information, the second a voltage measurement, the third a voltage measurement, and the fourth a date and time stamp. What I'm getting is two columns of data. The first column has the user input information, the second column has the two voltage measurements and the time stamp. I hope I;m not being too confusing, but basically I can't get all the data in one row.

[String_Theory]

You probably need to reshape the array. Try this

[BWMPDINC]

I'm sorry I should have mentioned I have labview 8.2. I can't open the file you uploaded... Could you possibly post a screenshot. Thanks.

[String_Theory]

No problem

[crossrulz]

It's likely you just need to NOT transpose the array (input into the Write to Spreadsheet File.vi should be FALSE)

[BWMPDINC]

None of the above have gotten the result I was looking for. I was able to get all the data in one column with the suggestion of reshaping the array, but I can't seem to get all the data in one row. Just a reminder I am a novice with the software and I'm sure I'm missing something simple. I appreciate all the suggestions so far.