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


 

Forums >

comp.lang.ruby

Re: Sorting Excel table with OLE

Victor 'Zverok' Shepelev

3/23/2007 1:43:00 PM

From: list-bounce@example.com [mailto:list-bounce@example.com] On Behalf Of
Damjan Rems
Sent: Friday, March 23, 2007 3:34 PM
>
>David Mullet wrote:
>> On Mar 23, 3:13 am, Damjan Rems <d_r...@yahoo.com> wrote:
>>> Posted viahttp://www.ruby-....
>> xlAscending = 1
>> xlDescending = 2
>> excel.Range("a2:e5000").Sort(excel.Range("b2"), xlAscending)
>>
>
>Thank you very much.
>
>I was looking for references on net (first 5 pages on google), but
>couldn't find anything solid. Do you know any good reference site
>(beside your blog pages ofcourse).
>

For this (and similar) cases, the best "reference" would be: writing macro
in Excel, read its VBA code and translate it to Ruby (the translation is
pretty straightforward).

V.