Actxserver unable to find 'Workbooks'

Hi, I am trying to create an output excel file to load data into while using Actxserver. For some reason, I cannot find the 'Workbooks' class. Here is my error and code:

 results = actxserver ('Excel.Application');

invoke(results.Workbooks, 'add');

Answer 1

[Vatsal]

Hi,

It seems like you are trying to create an Excel file using MATLAB’s actxserver function. The error message encountered is due to MATLAB not recognizing 'Workbooks' as a property of the results object.

In MATLAB, the actxserver function returns a handle to an instance of a COM object, in this case, Excel. To access the 'Workbooks' property of the Excel application object, dot notation should be used instead of trying to invoke it as a method.

Here is an example of how this might be done:

% Create Excel COM server
Excel = actxserver('Excel.Application');

% Add a new workbook
Workbook = Excel.Workbooks.Add;

I hope this helps!