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

1 view (last 30 days)
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.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 25 Jul 2013
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.

More Answers (0)

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!