Matlab 2016a readtable doesnot close excel after reading

16 次查看（过去 30 天）
Vipul Kumar Singh
回答： Steven Lord 2017-4-4
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.

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

回答（1 个）

Steven Lord
Steven Lord 2017-4-4
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.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by