Anyway to turn off Excel automatic calculation by a MatLab command for faster export ?
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (1)
Keld Stefan Pedersen
el 12 de En. de 2016
This should do the trick:
Excel = actxserver('Excel.Application');
Excel.Calculation = 'xlCalculationManual';
% Update worksheet here
Excel.Calculation = 'xlCalculationAutomatic';
cheers
1 comentario
Rouven Müller
el 28 de Oct. de 2022
It's not working
but no problems with
Excel.Application.ScreenUpdating = false;
Excel.Application.EnableEvents = false;
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!