Retrieving data from excel.

[DelEngUK]

Hi all,

can anyone give me some pointers with this please?

I'd really appreciate the help.

Thanks.

[EvenDeejay]

Hi,

In your database file, which column contains the serial number? Is it the first?

If you MCPC number is 2 and you search for the serial number 1 in your database, you would like to get the first two rows that contains the serial number 1? 

[DelEngUK]

Hi

thanks for the quick repsonse.

My serial number is in column 2 (12345/  2) for example.

If MCPC is 2 i'd like to get row 1 of 12345/  2 and then the next row after it.

Thanks again!

G

[EvenDeejay]

Nice=) I get it now. What would you like to happend if you enter the serialnumber for the last row and your MCPC number is more than 1? Will it only display the last row or add some blank ones?

[DelEngUK]

To be honest i'd like it to high light an error that it is not correct.

This is going to be used to populate a test certificate to a customer. I dont want the chance of missing data!

[EvenDeejay]

Hi,

Please test the VI I have attached. I needs more work and maybe less Rube Goldberg code, but it should get you started. 

[EvenDeejay]

You should add a File Path Constant so you don't have to select it every time you run the code. Also you should create a stronger check for matching serial number. It took me a while to realize that there was 2 spaces between 12345/ and 1. Maybe remove white spaces when you do the searching or something like that.  

[DelEngUK]

That works a treat!!

One Million thankyous!

You have seriously made my day!

I am starting to realise i do not know enough about data and how to manipulate it!!

[EvenDeejay]

You're welcome