Reading from 2 different excel files

[power1]

Hi all, I am using Labview7.1 and want to read columns from two different excel files and write what I read in one excel file.

The two file have the following info.

File1 is named EOB.xls and has the following data

Column1 Column2

row1: Energy(kWh) Demand(kVA)

row2: 20 5

row3: 25 6

File2 is named measurements.xls and has the following data

Column1 Column2

row1: Current(A) power factor

row2: 7 0.98

row3: 9 0.972

And want to read column 1 of file1 and column 2 of file 3. The end reasults must be something like this.

Energy(kWh) power factor

20 0.98

25 0.972

Is it possible to read from two different excel files? if yes, what VI must I use?

Edited July 3, 2009 by power1

[tkr]

Hi,

unfortunately I only have LV 8.6.1 installed on my PC any longer. Therefore only a screenshot.

In my opinion, you have to open both files, get the required data and process it.

Edited July 3, 2009 by tkr

[power1]

Hi,

unfortunately I only have LV 8.6.1 installed on my PC any longer. Therefore only a screenshot.

In my opinion, you have to open both files, get the required data and process it.

Thanx tkr, this program can read 2 excel files.

I didn't know it was this simple...but this explains I'm still new in Labview.

[pankajusic]

Thanks for sharing..

It's working..