Why do I receive a data conversion error after running a MATLAB Excel Builder generated add-in in Excel?

Why do I receive a data conversion error after running a MATLAB Excel Builder generated add-in in Excel?

I was able to build my MATLAB Excel Builder component, but after adding it to Excel, I received the following error message:

 Error in xlmagic.xlmagic.1_0: Error getting data conversion flags.

Answer 1

[MathWorks Support Team]

This error is a result of mwcomutil.dll not being registered. To register the dll:

1) Open a DOS window

2) If you are running against MATLAB change the directory to $MATLABROOT\bin\win32 (where $MATLABROOT represents the MATLAB installation directory the your system) or if you are running against the MCR change the directory to $MCRROOT\runtime\win32 (where $MCRROOT represents the MCR installation directory the your system)

3)Execute the command

mwregsvr mwcomutil.dll

If the above steps do not work, it can possibly be a registry issue. Please follow the troubleshooting steps below to resolve the issue in that case:

1) Download C-Cleaner and clean the system registry.

2) Delete the MATLAB Preference folder and build the Excel Add-in again. To find the location of the preference directory, execute the following command in the MATLAB command prompt

>>prefdir

3) Delete the startup.m file and build the Add-in again.