R2018a reopens excel after calling multiple readtable

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?

 采纳的回答

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);

更多回答(0 个)

产品

版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by