How to close Excel-file after writetable()?
30 ビュー (過去 30 日間)
古いコメントを表示
I want to use writetable() for an Excel-file in a for-loop. But at the second loop it stops with an error, because the first file is still open and there is no permission. Before I'd open a new folder for the new excel-file, but it doesn't work in this way now, because the file is still open.
0 件のコメント
採用された回答
Image Analyst
2016 年 10 月 10 日
編集済み: Image Analyst
2016 年 10 月 10 日
I got this from the Mathworks directly:
You can use the following SYSTEM command via MATLAB to kill the process:
>> system('taskkill /F /IM EXCEL.EXE');
4 件のコメント
Md Bhuyian
2020 年 6 月 25 日
I created an excel file named Comparison.xlsx. How do I only close that excel uding this command?
その他の回答 (2 件)
Walter Roberson
2016 年 10 月 11 日
Use table2cell() to create a cell array, and use xlswrite1() from the File Exchange, as that gives you an interface in which you have specific control over closing the spreadsheet.
5 件のコメント
Md Bhuyian
2020 年 6 月 25 日
I am getting the following error:
Undefined function or variable 'workbooks'
Image Analyst
2020 年 6 月 26 日
You must have changed the file. There is no workbooks variable in the attached function. You forgot to give the complete error which included the line of code so I don't know how you modified the function. Nevertheless, that demo is from 4 years ago and I have a new one, which I'm attaching here. And I just ran this so I know it works.
Plus I attached a second, separate demo showing how to put a formula into an Excel cell.
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!