Read/Write data from/To Excel sheet

HCL Domino Domino Forum
1

This is my requirement.

I want to read the data from excel sheet and check the data with lotus notes database . If the field value is matches with the document and write that document into new excel sheet.

  1. I want to read the data from excel sheet.

  2. Take name field data from excel and check with database, whether the name is present or not.

  3. If the name is available then take next address field and check whether the address is there in database.

  4. If the address field is there then take city and zip code and check with database. If the all these are matched with in a database

  5. Take that document and export all the information (Additional information) into one new excel sheet.

If possible, please send me a lotus script.

Thanks,

Mallik