Anyway to turn off Excel automatic calculation by a MatLab command for faster export ?
2 次查看(过去 30 天)
显示 更早的评论
Hello, I am using a excel template file to which I export data. The amount of data is big so I use xlswrite1 command from:
This enables me to lose less time on data exporting. However I noticed that if I disable the auto calculation on Excel the export is even faster.
For sure this happens because my excel file template has graphs for the data to be exported and each time a new data is exported the graph are rebuilt taking its time.
My idea was to somehow, by a MatLab command, disable the Excel auto calculation on the start of exportation and enable it on the end.
Any way to this by a activex command or any other way?
Thanks.
0 个评论
回答(1 个)
Keld Stefan Pedersen
2016-1-12
This should do the trick:
Excel = actxserver('Excel.Application');
Excel.Calculation = 'xlCalculationManual';
% Update worksheet here
Excel.Calculation = 'xlCalculationAutomatic';
cheers
1 个评论
Rouven Müller
2022-10-28
It's not working
but no problems with
Excel.Application.ScreenUpdating = false;
Excel.Application.EnableEvents = false;
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!