R2018a reopens excel after calling multiple readtable

1 visualización (últimos 30 días)
Mark Nardi
Mark Nardi el 4 de Jul. de 2018
Respondida: Harsh el 20 de Jul. de 2018
My program calls readtable 4 times in a Loop. Sometimes it will open 4 excelfiles, which will remain open, and Matlab will read from exactly these 4 open files for the whole run-through. But sometimes it will reopen these excelfiles over and over again (100*6*4 times), which will consume all the Memory. How is this possible, that one time Matlab goes this way, and another time that way?

Respuesta aceptada

Harsh
Harsh el 20 de Jul. de 2018
On Windows, you can use the 'basic' flag of 'readtable' which will work without opening an instance of excel. More info on this in the doc here.
>>readtable('filename.xlsx','Basic',true);

Más respuestas (0)

Etiquetas

Productos


Versión

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by