Delete Enitre column in excel using ruby code

[idealfellow]

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

cheers

[improvcornartist]

I'm not sure about calling macros, but you can delete a column by using something like

cell.entireColumn.delete
# or
sheet.range('B1').entireColumn.delete