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

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.

Answer 1

[Walter Roberson]

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.

[Kerstin John]

Thank you very much for the quick answer. It is working, although I have not been able to reproduce the initial error. But this solves my problem.

[Marcelo]

Hi Walter

I took your suggestion and ran with it.

Excel.Workbooks.Open(fileName,0,0,1,'','',1);

Opens an "read-only suggested" Excel file with write access, skipping the nagging pop-up dialogue.