|
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
|