Jump to content

Reading from 2 different excel files


Recommended Posts

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 by power1
Link to comment

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.

post-2539-124662349816_thumb.png

Edited by tkr
Link to comment

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.

post-2539-124662349816_thumb.png

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.

Link to comment
  • 2 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.