I actually did something like this on Friday. You've probaby tried to use
the Write to Spreadsheet VI and noticed that you need double-precision
values for the spreadsheet, and you have a boatload of strings. Chalk
that up to a LabVIEW limitation. While there are ways around this (none
of which are that good), what I do is create my own delmited file (if you
create a comma or tab-delimted file, Excel will be able to read it).
I took the values I had and put them in the correct order and put them in
a cluster, and passed that into a sub-VI that had a huge "concatinate
strings" box so that inputs 1,3,5,7... etc. were my strings, and
2,4,6,8... etc. were simply a comma. I made the last input a Carriage
Return (a string constant). Just write the string to a file, and
you're
done!
I assume this is all in a loop, so that each time the loop goes, there
will be a new line of data to the file (you have to make sure you're
appending to the file and not overwriting).
Of course, make sure no commas are in your strings already, or else it'll
mess it up. I created another vi to screen out commas and replace them.
If you have questions or want to see screenshots, just email!
rick
--
rick@csciences.com
Chesapeake Sciences Corp.
1127B Benfield Blvd Millersville, MD 21108
Tel: (410) 923-1300 x3430 Fax: (410) 923-2669
I've tended to dismiss the whole Open Software
movement as more religion than business. But let's
face it. Businesses come and go, but religions
stick around for thousands of years. If Bill Gates
and his employees plan to take on the Linux gang,
they better be prepared for a buzz saw.
--Jack Bryar
