[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Delete Enitre column in excel using ruby code

Idealone Ideally

4/19/2009 1:31:00 PM

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.
--
Posted via http://www.ruby-....
1 Answer

David Mullet

4/19/2009 3:46:00 PM

0

Idealone Ideally 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.bl.../search/l...

David

http://rubyonwindows.bl...

--
Posted via http://www.ruby-....