cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

excel component errors

Re: excel component errors

The "missing file" is in the zipped package I posted.  I have found that you sometime have to redo those readexcel call to get then to work properly.  The referenced file in in the directory tree one level above the file with the problem.

Re: excel component errors

I think I fixed the broken links in the new attachment.  Unzip as a directory and everything should work, link-wise. I found that there was one other file needed and it is included.   I've also added one more entry to the excel component at the far right of the excel component box.  The error message is "This expression is too large to calculate".  If you remove the last entry, the error clears. 

Re: excel component errors

Which version of Prime are you using? I have Prime 4.0 and the first time I tried to load your worksheet it crashed. The second (and third) time it loaded OK, but when I deleted one expression, it crashed.

 

Anyway, the problem is simply the very large number of expressions you have. Assign all the values to a matrix, then pass the matrix of values to Excel using one expression.

Re: excel component errors

While you may be correct about there being a limit on the number of expressions you can put in an excel component, the Mathcad Prime help documentation disagrees.  On the "About Excel Components" page, there is a clear statement that "You can add as many input expressions and output expressions as you want" in an excel component.  So its not clear to me that your conclusion is correct.

 

In any case, I've found a way to work around this limitation..  

 

Thank you for responding to my post.

 

 

Re: excel component errors


wrote:

While you may be correct about there being a limit on the number of expressions you can put in an excel component, the Mathcad Prime help documentation disagrees.  On the "About Excel Components" page, there is a clear statement that "You can add as many input expressions and output expressions as you want" in an excel component.  So its not clear to me that your conclusion is correct.

 

It has a problem when you add the last expression. There is, as far as I can tell, nothing wrong with the last expression that should cause a problem. So I guess you can choose to believe your own eyes, verified by someone elses eyes, or the documentation.

Announcements