How to apply a formula (autofill) on a range of cells in Excel using MATLAB COM activeX?

Question

hamutal 2012-9-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/47838-how-to-apply-a-formula-autofill-on-a-range-of-cells-in-excel-using-matlab-com-activex

Hello everybody, I was asked to write a code that manipulates a certain data to output as excel document. I read about using COM to work with excel, and have managed to do number of actions like copy&paste special, activating a worksheet etc. Now I can't seem to find the property that allows me to autofill a column with a formula or even applying one on a certain range. I tried to use the code that derives by the macro in Excel, but couldn't translate it write to MATLAB language. Would appreciate your help on the subject, and even a reference to an Index of known properties will help a lot.

Good day, Hamutal

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

hamutal 2012-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/47838-how-to-apply-a-formula-autofill-on-a-range-of-cells-in-excel-using-matlab-com-activex#answer_58683

anyone? please?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Tom 2012-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/47838-how-to-apply-a-formula-autofill-on-a-range-of-cells-in-excel-using-matlab-com-activex#answer_58688

编辑：Tom 2012-9-13

在 MATLAB Online 中打开

From your active worksheet:

 %data:
DataRange = e.Activesheet.get('Range','A1:B1');
DataRange.Value=[1 2];
 %equation:
EqnRange = e.Activesheet.get('Range','C1:C1');
EqnRange.Formula='=SUM(A1:B1)';
 %open Excel
 e.Visible = 1;

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

hamutal 2012-9-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/47838-how-to-apply-a-formula-autofill-on-a-range-of-cells-in-excel-using-matlab-com-activex#answer_59645

You've given me the way to apply a formula on a specific cell row. I wan't a way to apply the same formula on an entire range but according to the specific row. (meaning: c1=sum(a1,b1), c2=sum(a2,b2) etc.)