Jose -
Can be easily done. Well, I suggest, henceforth you try search this forum before you post. The reason is you dont have to wait this long to get a simple query answered.
Here is the logic,
1. Establish connection with Excel using the COM.
2. Read the Excel Workbook.
3. Read the Excel Worksheet.
4. Find out how many total rows are available.
5. Form a For loop to iterate.
6. Check for "value" in the excel cell.
See if you can get this done & Good Luck buddy.
Can be easily done. Well, I suggest, henceforth you try search this forum before you post. The reason is you dont have to wait this long to get a simple query answered.
Here is the logic,
1. Establish connection with Excel using the COM.
2. Read the Excel Workbook.
3. Read the Excel Worksheet.
4. Find out how many total rows are available.
5. Form a For loop to iterate.
6. Check for "value" in the excel cell.
See if you can get this done & Good Luck buddy.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.