How to apply a formula (autofill) on a range of cells in Excel using MATLAB COM activeX?
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (3)
Ver también
Categorías
Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!