MATLAB: How to remove the entries for obsolete functions from the Function Wizard in Builder for EX

MATLAB Builder EX

My Function Wizard shows previous addins loaded using the Builder for EX product though I have removed the addin from the Tools->Addin menu and have also deleted the addin XLA files.

Best Answer

The Function Wizard obtains the modules from the Windows registry, which is created while registering the application DLL.

Ideally, the best way to remove this entry is to use the /u switch for regsvr32. For example, to remove a previously registered Excel addin called myapp, use the following command at the Windows command prompt after navigating to the location where the addin resides:

regsvr32 /u myapp.dll

If this file is not available or has been deleted, the entry can be manually deleted from the registry. Please note that manual edits of the Registry is not recommended. Creating a backup is highly adviced in case you proceed with the following.

Steps to delete the entry in Windows registry:

Open the Registry editor. (Start -> Run -> regedit)

Search for the entry. (Ctrl+F, enter the application name)

Delete the entry. (Right click, Delete)

The Function Wizard should no longer display the module in its menu options. To repopulate this list, register the required application DLLs again.

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: Builder Ex – compiling with .mat file included using Excel Compiler

If you want to use your compiled component in Excel, you will have to compile it into an Excel add-in, not as an exe. This option can be selected from the dropdown when using deploytool.

Best Answer

Related Solutions

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

MATLAB: Builder Ex – compiling with .mat file included using Excel Compiler

Related Question