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?

Answer 1

[Harsh]

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