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

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Using An Excell Component

JohnRudnicki
14-Alexandrite

Using An Excell Component

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)

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

5 REPLIES 5
ttokoro
20-Turquoise
(To:JohnRudnicki)

image.pngimage.pngimage.pngimage.png

What kind of problems do you experience?

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

Werner_E_0-1615685351363.png

 

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

 

JohnRudnicki_0-1615738676539.png

 

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
14-Alexandrite
(To:Werner_E)

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 

Top Tags