Using An Excell Component

[JohnRudnicki]

I am trying to use an Excell sheet in a worksheet.  Using Insert Component, I can insert the Excel sheet but I cant seem to assign it correctly to something in MathCad. I was trying to follow the example in the Quicksheet but obviously am doing something wrong. With using the Inputs and Outputs menu? (Using MC 14 and Excel 2013)

[ttokoro]

[Werner_E]

What kind of problems do you experience?

When I open your sheet it seems to work OK (Mathcad 15, Excel 2016)

[JohnRudnicki]

Hmm. I get that A and B are undefined and the error message "The range value specified is invalid"

[Werner_E · Accepted solution]

The sheet again works OK with MC15 and Excel 2016.

Which version of Excel do you have installed? Which format has the file you embedded? I am not sure if MC14 can already handle the xlsx format introduced with Excel 2007.

As you use MC14 you may also ave a look at the release notes of newer Mathcad versions to see if its a known bug which was fixed in a later version. VladimirN posted those readmes here in the forum from time to time - here the one for the latest release M050 of MC15: https://community.ptc.com/sejnu66972/attachments/sejnu66972/PTCMathcad/176901/5/PTC%20Mathcad%2015.0%20M050%20Read%20This%20First.pdf

At a quick glance I spotted "Microsoft Excel 2007 Support" as a feature of MC15 F000 and also a fix in MC15 M010:

2007304: Fixes a problem with assigning data to a variable using an Excel component and an existing Excel 2007 file

Not sure of course if that relates to the problem you experience. Generally I see a lot of fixes in the list which in some way deal with Excel.

[JohnRudnicki]

Thanks. Saving the Excel file as *.xls instead of *.xlsx solved the problem. I should have remebered this: I had the same problem using Data File Input