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

Question

MathWorks Support Team 2013-7-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/95899-why-do-i-receive-a-data-conversion-error-after-running-a-matlab-excel-builder-generated-add-in-in-ex

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 2013-7-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/95899-why-do-i-receive-a-data-conversion-error-after-running-a-matlab-excel-builder-generated-add-in-in-ex#answer_105251

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.