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

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.

Answer 1

[Keld Stefan Pedersen]

This should do the trick:

Excel = actxserver('Excel.Application');

Excel.Calculation = 'xlCalculationManual';

% Update worksheet here

Excel.Calculation = 'xlCalculationAutomatic';

cheers

[Rouven Müller]

It's not working

but no problems with

Excel.Application.ScreenUpdating = false;

Excel.Application.EnableEvents = false;