How to open an excel file in read-only with actxserver?
39 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Kerstin John
il 18 Gen 2021
Commentato: Marcelo
il 19 Gen 2023
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.
0 Commenti
Risposta accettata
Walter Roberson
il 18 Gen 2021
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.
2 Commenti
Marcelo
il 19 Gen 2023
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.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Use COM Objects in MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!