How to close Excel-file after writetable()?

30 次查看（过去 30 天）

Reinhard Palaver 2016-10-10

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306652-how-to-close-excel-file-after-writetable

评论： Image Analyst 2020-6-26

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2016-10-10

5
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306652-how-to-close-excel-file-after-writetable#answer_238395

编辑：Image Analyst 2016-10-10

在 MATLAB Online 中打开

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 个评论
显示 2更早的评论隐藏 2更早的评论

Reinhard Palaver 2016-10-12

Hi Image Analyst,

instead of closing excel completely with unwished consequences I've found a similiar command like following which only is closing the specific spreadsheet:

system('taskkill /F /FI "WINDOWTITLE eq xy*"');

But once more thanks for your hint, because this was the way to solve it!

Md Bhuyian 2020-6-25

I created an excel file named Comparison.xlsx. How do I only close that excel uding this command?

请先登录，再进行评论。

更多回答（2 个）

Reinhard Palaver 2016-10-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306652-how-to-close-excel-file-after-writetable#answer_238450

Now I've an addtional problem. In a for-loop I've to use wait, until the batch is finished, otherwise it doesn't work in they way I want to have. And it's closing "all" excelfiles.

So now I'm looking for a function to close only the specific file after writing.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Walter Roberson 2016-10-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306652-how-to-close-excel-file-after-writetable#answer_238457

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 个评论
显示 3更早的评论隐藏 3更早的评论

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.

请先登录，再进行评论。

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