Reading From Excel

[Todder]

I am attempting to pull data from an excel file.  It is a datbase that has model numbers listed in column A with different test parameters across the row.  I am building a test cell and need to be able to select a pump and then pull the data from that row into Labview.  From what I have gathered so far I think I am going to have to create a Macro in excel to sort by Model # and I will be able to run that Macro from Labview.  Then I will have to pull the data in after I sorted.  Is this correct or is their an easier way.  Is what I am trying to do even possibe.

Thanks

Todd

[Wayne.C]

Todd,

There are a couple of ways to do this.  One is to use ActiveX to grab the data from Excel in the form of an array and then sort it in Labview.  You shouldn't need the macro.

The other is to use the vi's in the "Report Generation Toolkit for Microsoft Office" to grab the array of data.  This toolkit is included with some development systems, otherwise it  costs a bit extra.

There are examples of both on the NI webpage.