Delete Enitre column in excel using ruby code

ruby-talk
1

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.

···

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

2

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:

  Ruby on Windows: excel

David

···

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