Writing data into excel for unknown range using ActiveX commands

Data length is calculated using length()function. Data should start getting written from 'A3'. How can I specify the Range to be written since the end cell is unknown ? eg :A3+length(param) = A15 or so Matlab should calculate this on its own. Is it possible to do this?

Answer 1

[Kaustubha Govind]

I think you can just use 'A3' (if also specifying a sheet name) or 'A3:A3' (if not specifying a sheet name, because 'A3' may be misinterpreted as a sheet name) to specify it as the first cell to begin writing the data from.

[Suma]

When I just use 'A3'or 'A3:A3' ,it fills out only A3.Thank you for your reply.

I found a way to do this in a for loop.

for ii = 3: length(param.name)+ 2

hCALWs.Range(['A',num2str(ii)]).set('Value',param.name{ii-2});

end

Thanks.