excel into labview

[Jimmy Jeff]

Hello, I am trying to take excel data and put it into labview. The data is points for a cartesian coordinate system, these points come from a thermocouple taking temperature readings off of a condenser. Anyway I want to take these points and make a 3D Surface out of them. I have been able to take the excel data and get it into labview but have not been successful in converting it into a 3d surface graph. If anyone can help it would be much appreciated.

[craigc]

Hi Jeff, If you can post some data i might be able to help.  At the moment i have no idea what format your data is in etc etc.

Craig

[smercurio_fc]

Have you taken a look at the examples that ship with LabVIEW? Basically, all you need to do is feed in the X values and the Y values. You can take a look at the example Plotting Arrays of XYZ Data Using the 3D Surface Graph if you have a Z vector as well.

[Jimmy Jeff]

thanks craig this is an excel file with points described as letters the points have an X, Y, and Z value. The X and Z describe the location of the thermocouple while the Z is the temperature reading for that point.

[Jimmy Jeff]

The labview version I use is Labview 8.5

[corys]

Is this sort of what you're trying to get? It uses the 3DSurface.vi. The X and Z arrays have had their duplicates removed and were sorted before being sent to the VI, and the 2D array 'Y' is the Y data provided with zeros in the spots which did not have explicit data provided (at point [-8.00,-8.00], for instance). Pretty basic, but hopefully it'll be of some help in pointing you in the right direction. Good luck!

Message Edited by corys on 07-30-2008 02:22 PM

[Jimmy Jeff]

This is exactly what I want but, I've been working on this a while and can't get the programming right can you send a file of the programming? Or tell me what you did because I am still just a beginner. Thank you for your help!

Message Edited by Jimmy Jeff on 07-30-2008 02:38 PM

[corys]

Sorry for the delay, but attached is a VI that will produce the surface. It could use some cleaning up (wires galore in the for loop!), and if I get some time, I could do that. Let me know if you need any changes, or have any questions. *edit*...hold on...I'll get it soon 😛

Message Edited by corys on 07-30-2008 03:13 PM

[Jimmy Jeff]

Thank You.

Message Edited by Jimmy Jeff on 07-30-2008 03:15 PM

[corys]

Alright, here it is (I hope...having trouble adding attachments at the moment). You'll have to change the file name that goes into the Workbooks method, as that currently points to the my desktop. Aside from that, hopefully I'll get some time to clean it up a bit for ya, but at least here's some code for you to look at that should be functional with the data you provided. Which, I have a small question about. Will you be using this with other data files that are possibly configured differently? (Different number of data points, etc.). For the most part, the VI attached should be pretty adaptable with minimal changes, but the Cell range would have to be changed. Hope this helps!