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

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

create a List box in mathcad prime 9 from Excel

SFares
13-Aquamarine

create a List box in mathcad prime 9 from Excel

Hello,

 

I have a list of material size in an Excel column. Is it possible to create a list of these sizes in a dropdown list? In mathcad 15, there was a way to create this list manually using controls.

 

Thanks,

Sam

 

ACCEPTED SOLUTION

Accepted Solutions
Werner_E
25-Diamond I
(To:SFares)


@SFares wrote:

Hello,

 

I have a list of material size in an Excel column. Is it possible to create a list of these sizes in a dropdown list? In mathcad 15, there was a way to create this list manually using controls.

 

Thanks,

Sam

 


In real Mathcad you also could do it automatically by using some clever scripting (see for instance Richard's Extra Components -> https://community.ptc.com/t5/Mathcad/Extra-Components-and-Controls/m-p/450450?search-action-id=103996328440&search-result-uid=450450 )

But the dropdown lists in Prime are not capable enough to achieve something similar. PTC promised to implement scripting in the upcoming version of Prime. We have to wait to see if in that version its possible to achieve things which we were able to do real Mathcad since a long time.

 

@terryhendicott  once posted an elaborate method where he modified the xml representation of a Prime file to implement a large dropdown list. Guess this only makes sense if the list is not constantly changing.
I think it was this thread: https://community.ptc.com/t5/Mathcad/Excel-and-combobox/m-p/870154/highlight/true#M206266

or this one: https://community.ptc.com/t5/Mathcad/Populating-a-combo-box/m-p/841967/highlight/true#M204040

or this: https://community.ptc.com/t5/Mathcad/Combo-box-input-is-a-Vector/m-p/814201/highlight/true#M202199

 

 

 

View solution in original post

3 REPLIES 3
Werner_E
25-Diamond I
(To:SFares)


@SFares wrote:

Hello,

 

I have a list of material size in an Excel column. Is it possible to create a list of these sizes in a dropdown list? In mathcad 15, there was a way to create this list manually using controls.

 

Thanks,

Sam

 


In real Mathcad you also could do it automatically by using some clever scripting (see for instance Richard's Extra Components -> https://community.ptc.com/t5/Mathcad/Extra-Components-and-Controls/m-p/450450?search-action-id=103996328440&search-result-uid=450450 )

But the dropdown lists in Prime are not capable enough to achieve something similar. PTC promised to implement scripting in the upcoming version of Prime. We have to wait to see if in that version its possible to achieve things which we were able to do real Mathcad since a long time.

 

@terryhendicott  once posted an elaborate method where he modified the xml representation of a Prime file to implement a large dropdown list. Guess this only makes sense if the list is not constantly changing.
I think it was this thread: https://community.ptc.com/t5/Mathcad/Excel-and-combobox/m-p/870154/highlight/true#M206266

or this one: https://community.ptc.com/t5/Mathcad/Populating-a-combo-box/m-p/841967/highlight/true#M204040

or this: https://community.ptc.com/t5/Mathcad/Combo-box-input-is-a-Vector/m-p/814201/highlight/true#M202199

 

 

 

SFares
13-Aquamarine
(To:Werner_E)

Thank you, Werner!

The sequence is involved. Post the excel file and describe what is needed in the combo box I will do  it for you.

Cheers

Terry

Announcements

Top Tags