Excel

[Sorton]

Hello,

I want to get this thing running. Pretty much, what I want to do is to record numbers from the sweep into table and plot them on the graph.  As you may assume I'm beginner with LabView so the help would be appreciated.

Thanx!

[smercurio_fc]

What part of this is not working? Are you getting data? Is it not displaying in the graph?

Tip: You do not need to use the Build Table Express VI to get your numbers converted to a string. Just use one of the number to string functions. They are polymorphic and thus will accept an array input. For example, you can just use the Number to Fractional String function.

[Sorton]

Thanks for you post.

Yeah, I'm trying to get numbers into string (similar to excel) so I can analyze the data (create graphs and so on).  I tried to do it with excel but I couldn't get anywhere with it... So I thought of this idea.

Do you know the better way to get results into strings which would allow the analysis?

Tahnk you!

[craigc]

Hi Sorton,

Use the array to spreadsheet string function in the strings pallette.  You can then write this string to a file.  If you use a comma as the delimiter on the array to spreadsheet string function save your filetype as a *.csv.  This filetype is automatically recognised by MS excel or equivelent.

Craig

[Sorton]

Craig thank you for the post. I appreciate.

However, my knowledge of LabView is pretty limited, so what you explained looks confusing. Is there an easy way, tp put stuff together. I have tried with creating an exel file with Visual Basic code to control it but its really hard. At least for me.

Thank you for your help

[smercurio_fc]

You need to better explain what you're trying to do. The title on your post says "Excel", implying you're trying to do something with Excel. Then you say you're trying to do something in LabVIEW. Then you say you tried to get the numbers into a string similar to Excel so you can "analyze" the date (whatever that means), but you couldn't get anywhere with Excel, so you thought of doing it in LabVIEW. Then you say you tried to create an Excel file with VB but couldn't figure out what to do.

At this point I have no idea whether you're trying to do it in LabVIEW, or trying to get data generated in LabVIEW and written out to a spreadsheet-like file and then read into Excel, or what. Please explain exactly what you're trying to do so that the proper response can be formulated.

[craigc]

Hi Sorton,

Look at the quick example, it takes in an array of results, much the same as your vi does.  It changes them to a string of results seperated by commas.  Then It saves this string as a .csv file.

If you open the .csv file in excell your data will be there!

Any more probs let me know

Craig

[craigc]

.............and the attachment 😛

[Sorton]

Ok guys....here it goes...

I want to get the data from the scope, and analyze it.  I want to create graph out of the recordings....I wanted to use Excel initially but then I found this option in LabView.
What I'm asking you right now is:

What is the best way to get readings from the scope?

Record those readings?

Create a graph out of those readings?

Its supposed to be autamated, so everything is done with minimal user input.

Thank you!

[Dennis_Knutson]

Your original VI is communicating with a Keithley meter and you have a graph that displays the results. You want to replace the measurements done by the meter with a scope? What is the make and model?