How to check if excel is installed?

7 vues (au cours des 30 derniers jours)
Noah Kilps
Noah Kilps le 30 Oct 2020
Hello,
My script writes to an xls file. I am packaging this as an app to pass onto others to use. However it occurred to me that it could be possible that they don't have excel. I was wondering if there was a way for matlab to check if you have excel installed before writing/opening an excel file.
Thanks

Réponse acceptée

Walter Roberson
Walter Roberson le 30 Oct 2020
Look at the code for xlswrite, which does
try
Excel = matlab.io.internal.getExcelInstance;
catch exception %#ok<NASGU>
warning(message('MATLAB:xlswrite:NoCOMServer'));
  2 commentaires
Noah Kilps
Noah Kilps le 2 Nov 2020
Just now had the chance to get back to this. Thanks, Walter. Do you happen to know what
matlab.io.internal.getExcelInstance
will output if you do not have the application?
Walter Roberson
Walter Roberson le 2 Nov 2020
It will error in ActiveX attempt, which is why the try/catch

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by