MATLAB Answers

R2018a reopens excel after calling multiple readtable

11 views (last 30 days)
Mark Nardi
Mark Nardi on 4 Jul 2018
Answered: Harsh on 20 Jul 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?

  0 Comments

Sign in to comment.

Accepted Answer

Harsh
Harsh on 20 Jul 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);

  0 Comments

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Products


Release

R2018a