From: Li Chen <chen_li3@...>
Date: 2006-12-15T23:31:24+09:00
Subject: Re: ruby/ole excel delete row?

Simple version:


worksheet1.Range("A1:L40").each do |cell|

   if cell.Value=~/A/
      column,row=cell.Address.scan(/\w+/)
      worksheet1.Rows("#{row}:#{row}").Delete("Shift"=> 
Excel_constants::XlUp)
  end

end

Li

-- 
Posted via http://www.ruby-forum.com/.