From: Venkat r m Reddi <greet.venkat@...>
Date: 2009-12-29T20:54:37+09:00
Subject: Re: ruby/ole excel delete row?

Eric Ching wrote:
> How do I delete a row in an excel spreadsheet with win32ole?
> 
> I want to loop through some rows and delete a row if a cell in the row
> contains a certain value.
> 
> Here's the loop I am using:
> 
> excel.Range("h2:h305").each do |cell|
>   if cell.Value == "blah"
>     # DELETE ROW HERE
>   end
> end
> 
> And,where can I find documentation for using win32ols with excel.  I've
> been looking but haven't found anything to my satisfaction.
> 
> Thanks in advance,
> Eric

Hi, I too stuck on the same page.
I want to iterate the data to read username, password from row2(from 
same row) in excel. I am very much thankful if anybody helps me...I 
couldn't find proper solution in my search, so posting here.


1 Field1 Value           Field1    Value1   Value2  Field2    Value1 
Value2
2 Url   http://gmail.com   username  john     John1     password  pwd1 
pwd2
thanks,
venkat
-- 
Posted via http://www.ruby-forum.com/.