How to solve file permission problem after using excel activeX functions?
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi all,
I have a script where I make some computations and I copy all the results in a excel file. Moreover I want to nicely format its cells in order to improve the file readability. To format them I use activeX functions but when I try to open the created file with excel right after the computations I get the following warning in excel:
Myfile.xslx is already open. Reopening will cause any changes you made to be discharged. Do you want to reopen Myfile.xlsx?
If I click on YES the cell will not be formatted as I did in Matlab, otherwise the cells will be formatted. How could I solve this problem?
Here my code:
Excel = actxserver('Excel.Application');
Excel.Workbooks.Open(OutXLS);
HeaderRange=Excel.Range('B3:BY3');
HeaderRange.Font.Bold='True';
HeaderRange.HorizontalAlignment=3;
DataRange=Excel.Range('E3:M169');
DataRange.NumberFormat='0.00';
DamageRange=Excel.Range('N3:P169');
DamageRange.NumberFormat='0.000E+00';
DamagePercRange=Excel.Range('Q3:BY169');
DamagePercRange.NumberFormat='0.00';
Thanks
Cheers
3 commentaires
Geoff Hayes
le 1 Juin 2014
I think it is. Since the code started the operation to create a new file and update its contents, then the code should perform the save and closing of the file.
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!