power1 Posted July 3, 2009 Report Share Posted July 3, 2009 (edited) 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 Quote Link to comment
tkr Posted July 3, 2009 Report Share Posted July 3, 2009 (edited) 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 Quote Link to comment
power1 Posted July 6, 2009 Author Report Share Posted July 6, 2009 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. Quote Link to comment
pankajusic Posted August 30, 2011 Report Share Posted August 30, 2011 Thanks for sharing.. It's working.. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.