Regarding the Actxserver spec

4 visualizzazioni (ultimi 30 giorni)
open_file = Activate.Workbooks.Open(fullfile(pwd, 'DD.xlsx'),0,false)
In the above expression what does 0 and false indicates?
Thank you

Risposta accettata

Guillaume
Guillaume il 13 Mag 2015
Assuming that before the line you've shown there is a line:
Activate = actxserver('Excel.Application'); %And what a misleading variable name!
Then Open is an excel function. The whole excel interface is very well detailed by Microsoft. For example, this is the page about Open. On there you learn, that
  • 0 means do not update link in the workbook
  • false means do not open workbook as readonly
Since these are the default values anyway, they could just as well be omitted. It would make more sense since none of the other optional values are specified:
open_file = Activate.Worbooks.Open(fullfile(pwd, 'DD.xlsx')); %would do the same.

Più risposte (0)

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!

Translated by