Invoke Error, Dispatch Exception

Question

Adam Kaas 2016-10-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307693-invoke-error-dispatch-exception

编辑： Adam Kaas 2016-10-17

Hello,

I'm sorry for the following wall of text, but I'm not sure how to describe this concisely. I created a MATLAB executable and when attempting to run the executable on a different computer, the following error is generated:

---------------------------------------------------------------------

Invoke Error, Dispatch Exception:

Source: Microsoft Excel

Description: Save method of Workbook class failed

Help File: xlmain11.chm

Help Context ID: 0

Error in => file.m at line 205

---------------------------------------------------------------------

Line 205 in "file.m" is a function call that has multiple function calls within it as well so I'm not 100% certain where the error is occurring. There are multiple xlswrite2007() functions that are used, but I believe these have to be the culprit. They are all used in a similar fashion and have never caused a problem before. When running the executable or the source code from my computer, I receive no errors. When running the executable from another computer, it receives the above error. This is where I am getting even more confused but hoping it helps provide the answer, so I'm sorry for all the text.

To give you a better idea of what is happening, the user is printing data to excel from a .csv file that has data for a set number of labels. The data is split into different records that are all identifiable by a time segment. This error is showing up on the longest record, and some other rather lengthy records but it hasn't appeared to happen on any short records. Long > 300 minutes of data, short < 10 minutes of data.

When the user selects the record (let's say the longest record), they then choose what labels they want to analyze. If they choose all of the labels, they see the above error. The fault is occurring on the third of four similar labels (they have their own function calls, but the additional function calls within their own functions are the same functions). So the first two labels run through no problem. Not only is that strange to me, but if the user selects just these four labels that are similar, the error is seen on the fourth label instead of the third. What?!

Some configuration info: I created the executable in MATLAB R2016a 64-bit. I'm on a 64-bit Windows 7 Service Pack 1 with 32-bit Microsoft Excel 2013. The other computer does not have MATLAB installed (but has the MCR installed), but also has the same Windows OS and Excel. I cannot run the source code on the other computer.

Let me know what additional information I can provide. Any assistance is greatly appreciated, and again I apologize for all of the information.