Delete Enitre column in excel using ruby code

[Idealone Ideally]

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.

 

[David Mullet]

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