MATLAB: Open an Excel add-in from MATLAB

actxserveradd-inaddinexcelinvokeMATLABudfxlswrite

Hello

I am able to use actxserver to open an excel workbook and make it visible. I then put data into excel using xlswrite into cell A1. I want excel to perform calculations using an add-in. The value always shows #NAME. I believe this is because the add-in is not loaded so how can I do this from MATLAB?

I tried

    xlafile = 'theaddinlocationandname.xla'
and I tried
    invoke(Excel.Workbooks,'Open','theaddinlocationandname.xla')

"xlafile= 'theaddinlocationandname.xla'" displays when I do not surpress the output and "Interface.000208DA_0000_0000_C000_000000000046" shows for the invoke one.

When I click on the cell where the value should be, this shows 'addinlocationandname.xla'!functionname("input",A1)

To get the add in to run, I have to go to the "data" tab, "edit links", and hit "open source".

Best Answer

Hi Collin,

Hope the following link helps,

https://www.mathworks.com/matlabcentral/answers/92269-why-can-i-not-call-add-in-macros-when-using-excel-as-a-com-automation-server-from-matlab-7-4-r2007a?s_tid=answers_rc1-1_p1_MLT

-Sindhu

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Can I not call Add-in macros when using Excel as a COM Automation Server from MATLAB 7.4 (R2007a)

This is the expected behavior. Microsoft Excel does not load Add-ins when started as a COM Automation server. This behavior is not specific to use with MATLAB.

Microsoft has information about the issue, the reasons behind it, and workarounds here:

https://mskb.pkisolutions.com/kb/213489

The following MATLAB code uses the same method. Note that Microsoft's solution involves specifying the path to the XLA-file; assuming the file resides in D:\Work.

%%\nExcel = actxserver('Excel.Application');\nWorkbooks = get(Excel,'Workbooks');\nfWorkbook = invoke(Workbooks,'Add');\nfWorksheet = get(fWorkbook,'Activesheet');\n\nfRange = fWorksheet.Range('A1:B2');\nfRange.Value{1,1} = 'name';\nfRange.Value{2,1} = 'foo';\nfRange.Value{1,2} = 'amount';\nfRange.Value{2,2} = 100;\n\n%% Now load the add-in, using the method suggested by Microsoft:\n% https://mskb.pkisolutions.com/kb/213489% Open file on disk\nExcel.Workbooks.Open('D:\Work\myAddin.xla');\n\n% Use this method to execute any Auto_Run macros.\nExcel.Workbooks.Item('myAddin.xla').RunAutoMacros(1);\n\n% Now that the Add-in is loaded, execute the macro it contains:\nExcel.Run('myMacro');\n\n%% Finally, make Excel visible.\nset(Excel,'Vis',1);

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Can I not call Add-in macros when using Excel as a COM Automation Server from MATLAB 7.4 (R2007a)

Related Question