R2018a reopens excel after calling multiple readtable

1 次查看（过去 30 天）
Mark Nardi
Mark Nardi 2018-7-4
回答： Harsh 2018-7-20
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?

请先登录，再回答此问题。

采纳的回答

Harsh
Harsh 2018-7-20
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by