Writing data into excel for unknown range using ActiveX commands

2012 1 27
1 个回答
4 次查看（30 天）

0 个投票

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

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

提问:

Suma
Suma
2012-1-27

Community Treasure Hunt

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

Start Hunting!

Translated by