value lookup in excel on network

[cb4004]

I'm trying to figure out a way to lookup a value in an excel sheet that is on a network drive and on multiple tabs with different names inside of the spreadsheet.

Example: I'm trying to lookup 200041 in tab "Test C" and report back parameter #2 and parameter #4.

it's located on network drive \\Common\test\Test_Plan.xls

Thank you

[Artem.SPb · Accepted solution]

Use Report Generation Toolkit

[cb4004]

A few little things I'm still trying to figure out how you did it.

See the red boxes - I'm trying to figure out how to define the output bundles as row and I can't find the array that you used in the middle. What's it called?

Thanks

[Artem.SPb]

right click on terminal -> create->constant.
You'll get const with correct names

now you can bundle values.

[ben64]

It is sometimes easyer and more efficient to use Excel native function throught ActiveX (when you familiar with ActiveX) in conjunction with the RGT.

Ben64

[cb4004]

Thanks guys.

Last questions on this, I got the clusters to name but I ended up with "start row" instead of "row" will this impact the output and if so, how can I fix it?

Also, my output tunnels seem wrong. I played around with it a bit and it seems that I need to create something in the case structure to link them to if the value isnt found, what should I use? or other methods to make them correct..?

[Bob_Schor]

I posted a response here to another Excel/RGT query yesterday that discusses and illustrates the Start Row parameters and clusters, including showing a VI with explanations of the functions that you might find helpful.

Bob Schor

[RavensFan]

Bob's original image is a VI snippet.  Drag that image and drop it in your block diagram and you have code.  You can see what is in the other case.  I'm certaing the Report reference wire and the error are are just wired through.  The cluster is probably the default.  Just right click on the tunnel and pick create constant.

[cb4004]

Thanks- I'm actually running 2013 so the drag and drop doesn't work for me at this time. I'm going to try the computers at my school later today and see if they have the 2015 version then i'll just convert it to 2013.