how to close an excel file

149 次查看（过去 30 天）
pradeep kumar
pradeep kumar 2014-11-21
评论： Image Analyst 2023-3-30
Hellow everyone . i am using
winopen('myfile.xlsx')
to open an excel file , after doing some modification, i want to close the excel file in order to overwrite the existing data by
xlswrite('myfile.xlsx', my_modified_data )
but sometimes i forgot to close the file manually in between and MATLAB generates an error . Is there any way to automatically close the excel file(by some command like winclose or something like that) before writing into it . Thank You all .

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

采纳的回答

Image Analyst
Image Analyst 2014-11-21
Yes. You can use actxGetRunningServer() to connect to Excel and shut it down.
  9 个评论
显示 7更早的评论
Ihaveaquest
Ihaveaquest 2023-3-30
works for powerpoint as well - theres not much info online for how to with powerpoint
import mlreportgen.ppt.*
taskToLookFor = 'Powerpnt.exe';
% Now make up the command line with the proper argument
% that will find only the process we are looking for.
commandLine = sprintf('tasklist /FI "IMAGENAME eq %s"', taskToLookFor)
% Now execute that command line and accept the result into "result".
[status result] = system(commandLine)
% Look for our program's name in the result variable.
itIsRunning = strfind(lower(result), lower(taskToLookFor))
%closes powerpoints if they are open so system does not crasah when it
%tries to open a new PP
if itIsRunning
if exist('Plotted Circulator', 'file')==0
system('taskkill /F /IM POWERPNT.EXE');
end
else
end
Image Analyst
Image Analyst 2023-3-30
@Ihaveaquest if Excel is open with several sheets, you can use
Excel = actxGetRunningServer('Excel.Application');
to get a handle to the Excel server, then use Excel to save the active sheet and close it.
Excel.ActiveWorkbook.Save;
Excel.ActiveWorkbook.Close(false); % The 'false' argument prevents the popup window from showing, forcing the closure without user intervention.

请先登录，再进行评论。

更多回答（1 个）

Artem Smirnov
Artem Smirnov 2017-1-19
Try this:
close all
  1 个评论
Image Analyst
Image Analyst 2017-1-19
And when/if you do, you'll see that close does not shutdown other processes and applications like Excel.

请先登录，再进行评论。

类别

在 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