From: Meena Chidambaram <meena.chidambaram@...>
Date: 2008-02-28T15:38:32+09:00
Subject: find whole words in excel

I am trying to locate a column name in excel and i am using the "find"
method. But it seems to be doing a partial match (instead of whole word
match).
I have two columns in my excel "ParentOrgId" and "OrgId" , when i search
for "OrgId" it returns the "ParentOrgId" . How can i make it do a whole
word match so that it returns "OrgId".

The snippet of code used is given below

equire 'win32ole'

excel = WIN32OLE.connect("excel.application")
excel.visible = TRUE
wbook=excel.Workbooks.open("D:/test.xls")
wsheet=wbook.Worksheets("OrgInfo")
rFoundCell = wsheet.Range("A1:IV1").Find('OrgId')
puts rFoundCell.value
-- 
Posted via http://www.ruby-forum.com/.