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

Translate the entire conversation x

Excel and mathcad

DK_9908241
4-Participant

Excel and mathcad

Hello ,

Is it possible to get all the values back to Excel as a product.of L*B as an area. I tried with one row but it is too much time consuming. I believe there is some other way to do may be by programming but I am not sure how to do that can please someone help.

 

excel.jpeg

Somehow I was unable to add excel sheet so attaching screenshot 

Don

3 REPLIES 3
LucMeekes
23-Emerald III
(To:DK_9908241)

See attached.

 

First check the contents of Book1.xlsx.

Then open the mcdx file with Prime.

Then re-check the contents of Book1.xlsx.

 

Success!
Luc

DK_9908241
4-Participant
(To:LucMeekes)

Thank you for the information

 

Can we call out a specific combo box in a worksheet and then a specific row or a column in another combo box?

 

I tried calling out a excel in a worksheet using combo box but not sure if we can call out a specific row from specific excel sheet to get the calculations done in Mathcad prime 7

 

 

LucMeekes
23-Emerald III
(To:DK_9908241)

Read section 2 of the "what's new" in Prime 7 here: https://community.ptc.com/t5/PTC-Mathcad/Mathcad-Prime-7-0-reference-documents/td-p/719101

Then decide if this is what you need. You are more an expert on this than myself, because I'm limited to Prime Express, which implies that lots of the new features of Prime are not usable.

 

Regarding the Combo-box, you should also be aware of this: https://community.ptc.com/t5/PTC-Mathcad/Mathcad-Prime-7-0-Combo-Box-doesn-t-support-unit-with-exponents/m-p/718297#M194871

 

Success!

Luc

Announcements

Top Tags