Anyway to turn off Excel automatic calculation by a MatLab command for faster export ?
7 ビュー (過去 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!