How to solve file permission problem after using excel activeX functions?
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
Geoff Hayes
2014-6-1
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.
回答(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!