How read cells from an Excel file?

[giada]

Hi,

I want to search in the first column of a Excel file a name and when I found it I want to read the near cells (same row but different column).

I try with the Activex but I don't found the rigth solution.

Can I help me, please?

Thanks

[Mathan]

--------------------------------------------------------------------------------------------------------------
I try with the Activex but I don't found the rigth solution.
--------------------------------------------------------------------------------------------------------------

Please post what you have did so far. That will help in finding out the exact problem.

[muks]

You can use "read from spread sheet"

[Philip.k]

Hey giada,

Before you can use the read from spreadsheet file VI the data of the Excel file must be copied to a .txt file then using the VI mentioned when set to string you can perform array searches to the data

I shall write you an example to show the search aspect of your problem 

[giada]

Ok, thanks

[Philip.k]

Here's the comma spaced .txt file search VI it may be possible to copy the Excel file to a comma spaced text file using active X before performing the search

[giada]

Sorry, but I have LabView 8.5.1.

Thanks

[Philip.k]

Here it is I'm currently working on a way to convert the Excel file to a Text file

[Philip.k]

This will Search the Excel file for you

Hope this helps