Delete Enitre column in excel using ruby code

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.

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:

http://rubyonwindows.blogspot.com/search/label/excel

David

http://rubyonwindows.blogspot.com

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs