From: David Mullet <david.mullet@...>
Date: 2009-04-20T00:46:10+09:00
Subject: Re: Delete Enitre column in excel using ruby code

Idealone Ideally wrote:
> Hi All,
>          I need to delete entire column(GB) in excel using ruby code.
> let me whether i should write some code or is there a way to call an
> macro in excel.
> whichever is simpler or easy way to maintain.

Where ws is your Worksheet object:

  ws.Columns('GB').Delete

More info on automating Excel with Ruby can be found here:

  http://rubyonwindows.blogspot.com/search/label/excel

David

http://rubyonwindows.blogspot.com

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