Anyway to turn off Excel automatic calculation by a MatLab command for faster export ?

5 次查看（过去 30 天）
PA00
PA00 2012-1-23
评论： Rouven Müller 2022-10-28
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:
http://www.mathworks.com/matlabcentral/fileexchange/10465
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.

请先登录，再回答此问题。

回答（1 个）

Keld Stefan Pedersen
This should do the trick:
Excel = actxserver('Excel.Application');
Excel.Calculation = 'xlCalculationManual';
% Update worksheet here
Excel.Calculation = 'xlCalculationAutomatic';
cheers

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by