Matlab 2016a readtable doesnot close excel after reading

I recently shifted from 2015a to 2016a, one of the challenge that i face is that readtable function keeps the excel open as process. Hence when i am running my code which in turn reads data from several excel files, the memory usage increases as excel is not closed. Because of this my sytem goes out of memory soon, whereas in 2015a readtable used to close excels after reading. Same issue exist for writetable as well in 2016a. Please help what to do? Also i don't want to use system('taskkill /F /IM EXCEL.EXE'); as it will close all excel files.

Answer 1

[Steven Lord]

I suspect the reason Microsoft Excel remains open is related to the change made in release R2015b to improve the performance of repeated calls to functions that read from or write to Microsoft Excel files. I don't know if there's a way to disable this behavior, but if you contact Technical Support (using the Contact Us link in the upper-right corner of this page) they may be able to help you determine what's causing the memory usage increase and how to avoid it.