Writing data into excel for unknown range using ActiveX commands

1 次查看（过去 30 天）
Suma
Suma 2012-1-27
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?

请先登录，再回答此问题。

回答（1 个）

Kaustubha Govind
Kaustubha Govind 2012-1-27
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.
  1 个评论
Suma
Suma 2012-1-27
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by