HOW MANY TIMES DO WE HAVE TO ASK EVERYONE TO NOT POST ANY QUESTIONS IN THIS THREAD. PLEASE ONLY USE THIS THREAD TO POST EXAMPLES OR TO LINK TO OTHER THREADS WHERE EXAMPLES ARE POSTED. IF YOU HAVE A QUESTION THAT NEEDS TO BE ANSWERED THEN POST IT IN THE PUBLIC LV FORUM.
You would think we were asking for something really difficult.
In this thread: http://forums.ni.com/t5/LabVIEW/Search-excel-file-return-value-from-different-column/m-p/2138864#M69... I was trying to use the VLookup function with LabVIEW.
Attached is the solution VI that searches for a value and can return the value from a different column/row using VLookup.
Just an opinion: I have been working very heavily with Excel spreadsheets and reports. We have a very flexible piece of software that acquires data then sends the data to an Excel workbook. In Excel we analyze the data then generate pass/fail using formulas. I am finding the combination very powerful and flexible. The code can be greatly simplified, reducing the change of bugs. The bugs that do appear are usually in the spreadsheet template and can be tracked down and fixed a lot faster. Never thought I would have so much fun using Excel.
Do you have an updated version of the Excel toolkit for later versions of LabVIEW? I have a later version and I cannot open any of your VIs. Thanks!
I saw some Visual Studio code where the developer used a database connection to read data from an Excel workbook. Here is a simple LabVIEW implementation.
I looked into that once and I thought there were big limitations in the types of things it could do. Something like this uses the Excel for web browsers which had less features than full Excel. Or is this the full Excel in LabVIEW?
It's not really full blown Excel, no. It's basically a Workbook window. That is, you have access to your sheets, you can see the row and column headers and you can do anything with the right click menu on a cell that you can do in Excel.
This is more than enough for what we're trying to do, which essentially just let the user view the data.
This is the view you get: