MATLAB: How to open an excel file in read-only with actxserver

actxserverexcelread-only

Hi,

I am using actxserver to read some data from various Excel files. The code works fine, but when it encounters a file that is currently opened by another user, it causes an error:

Error using Interface.000208D7_0000_0000_C000_000000000046/Item

Error: Call was rejected by callee.

When I open the same file manually in Excel, I get a dialog option to open it in read-only mode. Since I do not want to change or save the file, that is exactly what I need. Is there a way to choose this option from Matlab and avoid the error?

Thank you.

Best Answer

https://excel.officetuts.net/en/vba/open-workbook-as-read-only

https://www.mathworks.com/matlabcentral/answers/306813-problem-accessing-excel-files-through-xlsread

Which suggests

Excel.workbooks.Open(filename, 0, readOnly)

where Excel is the result of the activex call.

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: Moving excel sheets within excel file

I think you'll have to use ActiveX to copy the sheet, then delete the sheet, then insert a new sheet with the desired sheet number. Search this forum for ActiveX.

Best Answer

Related Solutions

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

MATLAB: Moving excel sheets within excel file

Related Question