Clear Filters
Clear Filters

Actxserver unable to find 'Workbooks'

4 views (last 30 days)
waleed khalid
waleed khalid on 10 Mar 2021
Answered: Vatsal on 5 Jun 2024
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');

Answers (1)

Vatsal
Vatsal on 5 Jun 2024
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!

Community Treasure Hunt

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

Start Hunting!