How to read data from excel and plot a graph?

[Sahan@123]

Hi All,

I have an excel file containing the temperature data in one column and respective time at which temperature is updating,i need to plot time v/s temperature in a graph.

Can anyone guide me the steps to read both temperature and time data from excel and writing it to graph without changing the input format of the file to csv. The input format of the file is .xls

can i do it with the help of activex and excel?I am not much familiar in using activex,so it will be of great help if anyone can help me,or any other simplest method other than this is also fine 

[GerdW]

Hi Sahan,

---

Sahan@123 wrote:

can i do it with the help of activex and excel?I am not much familiar in using activex,so it will be of great help if anyone can help me,or any other simplest method other than this is also fine 

---

Yes, you can use ActiveX.

Or you use the RGT functions which come with LabVIEW: they cover all this ActiveX stuff under the hood.

Read both columns and create a XY plot for a XY graph from them.

(You might need to correct the Excel timestamps because Excel uses a different timestamp format/epoch than LabVIEW does. Search the forum for related threads, this has been discussed before.)

[Sahan@123]

Thank you for the information and i will try it once using RGT. can you suggest some example vi's if they are in forum? or links are also fine

[GerdW]

Hi Sahan,

LabVIEW comes with a huge example library, there are also examples on using the RGT functions!

Just open the example finder…