Reading datas from an excelsheet

[danil33]

Hi,

       In the below attached example,while running it is displaying junk values.From one of the threads in LabVIEW I came to know that we have to 'export the data as a text file or must have ActiveX control.How can I export data as a textfile?Or how to activate ActiveX control??Please reply.

[P@Anand]

You are using the spread sheet read function to read a file that is formatted in Excel. So you have to use ActiveX or Report Generation toolkit to read the data. For more details on Excel you can check in this thread.

Good luck.

[danil33]

Ok.Thank you verymuch for your reply.Now Iam able to do that.I have one more question.From the Read Excel.vi can we serially read those datas and display them in another VI. using serial port reading?please reply.

[GerdW]

Hi danil,

???

How os reading a file connected with reading data from serial port? These are two completely different things...

[danil33]

Hi GerdW,

                My question is can we read those analog values from another vi?

[GerdW]

Hi danil,

any text or binary file (like your XLSX) stores digital data. Also the serial port transports digital data.

I don't see any "analog values" involved here and so I don't understand your question...

[P@Anand]

Yes why not you can use Global variables to get the values from other vi's. But it should be in the same PC running if you want to transfer data from some other system or an RT controller you need to TCP IP. But I believe you do not require all these things.

[danil33]

In the above attached VI.How can we incorporate Global Variables to read from another VI?

[danil33]

sorry GerdW,

                    I just mean the values.sorry for writing analog values.

[P@Anand]

In the vi I see you are reading from a .bin file and writing the data to the Excel sheet instead of reading from the .bin file use a Global variable to read the value and write it to the spread sheet file and also the file you are writing is not excel foramtted it will be a simple tab delimited file. The Global variable you can write it in any other vi.