MATLAB: How to close an excel file

activexexcelshut down excel

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 .

Best Answer

Yes. You can use actxGetRunningServer() to connect to Excel and shut it down.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: How do you close a document once it has been opened using WINOPEN in MATLAB 7.1 (R14SP3)

There is no built-in feature in MATLAB 7.1 (R14SP3) that would enable you to close documents once they have been opened using WINOPEN.

It may be possible to open and close your other application using that application's API. The program interface of your application is specific to that application, such that we cannot supply information on accessing your program through its own API. You will need to contact that application's vendor or documentation for more information. Once you have researched the API of your other application, you should be able to connect to it using MATLAB's COM Integration. You can find more information about this in the documentation which can be accessed by typing the following command on the MATLAB Command Prompt:

web([docroot,'/techdoc/matlab_external/ch07clie.html'])

Here's an example that shows how to open and close an Excel file:

% Start Excel.
excelApp = actxserver('Excel.Application')
excelApp.visible = true;
% Open file called test.xls, located in the current folder.
excelWorkbook = excelApp.Workbook.Open(fullfile(pwd, 'test.xls'));
% Alternative: open file 'C:\Temp\test.xls'.
%excelWorkbook = excelApp.Workbook.Open('C:\Temp\test.xls');
% Close file.
% true = save changes, false = don't save changes.
excelWorkbook.Close(true);
% Close Excel.
excelApp.Quit;
% Clean up.
release(excelWorkbook)
release(excelApp)

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: How do you close a document once it has been opened using WINOPEN in MATLAB 7.1 (R14SP3)

Related Question