Excel activex, setting multiple cells in a column range

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Excel activex, setting multiple cells in a column range

ar-2
Blair,

Given:

values := #(a b c)
range := xlapp range: 'A1' cell2: 'A3'.
arry := rangeA1A3 value.
values keysAndValuesDo: [ : k : v |
        arry elementAt: (Array with: k with: 1) put: v asVariant].
range value: arry

"compared to setting a row: rangeA1C1 value: values"

Is there any (more efficient) alternative that you're aware of to set multiple
cells in a column in one shot, ie avoiding the safearray calls?
(I dont there is, just checking)

-alan