how to read the data in excel sheet

[steps]

Dear sir,

How to read the data in excel sheet when i recieve a data serial communication... ie i have store a data in excel such that

Cell A       Cell B

   A           Apple 

   B           Ball

   C           Cat

   D           Doll

when i recieve A from serial communication i have to display Apple, and when i recieve B i have to display Ball and so on.. 

[Himanshu_Goyal]

Hi,

You can find your solution here

Thanks and Regards

Himanshu Goyal

[Sagar_NI]

Hi, 

I would recommend you to have a look at the VI attached. It makes use of a VI named 'Read from Spreadsheet' to read the row and column data from the tab delimited excel file. The read data is then searched for the Alphabet specified and finally returns you the corresponding string. The test file used to validate the operation of the VI is also attached. 

Trust this would help you solve the issue. 

Regards, 

Sagar G Yadav | Application Engineer | National Instruments