Delete Enitre column in excel using ruby code

idealfellow · #1 April 19th, 2009, 02:32 PM

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 · #2 April 20th, 2009, 03:46 PM

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

/bytes/development

/bytes/it

/bytes/about