how to write 4 or more of floating numerics to a spreadsheet?

[Se]

how to write 4 or more of floating numerics to a spreadsheet?

[mikeporter]

The easiest way is to combine them into an array and then pass the array to the "Array to Spreadsheet String" Function. The output of this function you can then write to a text file.

Alternately, you could also use ActiveX to insert the datavalues into a spreadshhet directly. There are good examples that ship with LV showing how to do this.

Mike...

[Se]

Where's the location of that examples and is there a function called "write a a text file"?

[mikeporter]

The Excel example is in the section demonstrating ActiveX control. Doing a search for "Excel" or "ActiveX" should find it.Under ther File IO palette should be a VI called "Write characters to file.vi"Mike...

[Se]

Hi Mike,
I took ur first advice by build an aray of floating numbers, output it to "Array to Spreadsheet string" and save it using "Write charaters to File.vi", but this is what happens in everytime it runs "The data in the Vi's log file is incompatible with the VI's front panel. What kind of error is this?

[Se]

Mike,
I got it working now, but it's a bit wierd. I have 6 elements of array including date and time, but it only out put 4 elements where the "time" and one of the element is in the front panel called "fx" (display in excel)

[mikeporter]

this is wierd. post the relevant parts of your code in V6.0 format and I'll be glad to look at it. Mike...

[Se]

Mike,
I know why it didn't work, it's because I have timestamp after writing array to spreadsheet. Now that I tried to modify it I cannot connect from 'array to spreadsheet' to 'Write to spreadsheet file'. I attached the file below. How can I fix the problem?

[mikeporter]

Your posing was in V6.1 format. Could you resave it as a V6.0 VI?

(If you don't knwo how to do this look in the documentation on saving in previous versions--it's under Save with Options.)

Mike...

[Se]

This's in version6.0.
Thanks!