LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

store data in excel file in multiple columns

Try this:

Right click on the scan from string input for the format string and select Create Constant. Right click on the constant and select '\' Codes Display.

Go to the front panel and copy one line of data.

Go to the block diagram and paste the string into the constant you created.

In the constant, replace the numeric values with %f.

You should now have three outputs from the scan from string. You may have to play around with the spaces but this should get you started.
0 Kudos
Message 11 of 12
(551 Views)

Just to clarify, what Gerd and Dennis are saying is that you don't have to read/understand all of the Help Files, since your problem is mainly with one function, "Scan from String".  Read the Help, look at the examples, play around with them until you "get" the idea of using it to parse a string that has three values in it and come out with three separate outputs.  There is still a step to do (how to get those three outputs into the single 1D array that Write to Spreadsheet File wants), but that's also been answered earlier.  Don't despair.

 

Bob Schor

0 Kudos
Message 12 of 12
(521 Views)