How to apply a formula (autofill) on a range of cells in Excel using MATLAB COM activeX?
10 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!