Delete Enitre column in excel using ruby code

Ruby
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.

2

Idealone I. 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