R2018a reopens excel after calling multiple readtable

1 vue (au cours des 30 derniers jours)
Mark Nardi
Mark Nardi le 4 Juil 2018
Réponse apportée : Harsh le 20 Juil 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?

Réponse acceptée

Harsh
Harsh le 20 Juil 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);

Plus de réponses (0)

Produits


Version

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by