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

Expand|Select|Wrap|Line Numbers

 cell.entireColumn.delete

# or

sheet.range('B1').entireColumn.delete

Delete Enitre column in excel using ruby code

re: Delete Enitre column in excel using ruby code

Similar Ruby / Ruby on Rails bytes

/bytes/development

/bytes/it

/bytes/about