My last question was obviously too stupid to answer and rightfully so. Since
then I've figured out how to create a spreadsheet using the Generic COM
interface. Got it looking exactly like a bought one. Only problem it takes
ages to run. I think that this is because I'm populating one cell at a time.
If I do it by row I think it will speed things up, but I can't figure out
how to do it. All attempts have failed with type mismatch or populated every
row with the same value.
I assume I'll need to do
range.SetProperty("Value",x)
and that x has to be a variant. I've done this in Delphi in the dim dark
past by using an array of variant. Does anyone know how I do this in Cache ?
