How to apply a formula (autofill) on a range of cells in Excel using MATLAB COM activeX?
10 次查看(过去 30 天)
显示 更早的评论
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!