Skip to main content
E
entec26-Contributor
6-Contributor
November 30, 2022
Question

Populating a combo box

  • November 30, 2022
  • 1 reply
  • 3296 views

Is there a procedure to use the data from an referenced Excel file or matrix to populate a combo box?

 

Thanks,

1 reply

T
terryhendicott21-Topaz II
21-Topaz II
December 1, 2022

Hi,

 

As far as I know no.

 

It is possible to cut and paste one value at a time!

 

Are the referenced Excel or matrix constant values or are they calculated?

If they are constant values there is a way to manipulate the underlying Prime xml file to create large data combo boxes

File shows examples with 2091 rows and 165 rows respectively.

Can the information needed in the combo box (if constant) be uploaded as either Excel or Matrix?

Cheers Terry

 

 

E
entec26-ContributorAuthor
6-Contributor
December 2, 2022

Please find attached some clips (pdf format) from a sample worksheet. It would appear that you're doing something similar with your large combo box. Note that I'm referencing data from an excel file and then based on the selection in the first combo box, choosing the material shape. In Mathcad 15, it was possible to use that data to populate a second drop-down list for selecting the structure size. Is that possible? If not any suggestions on a simple work around? As you'll note in these clips, there are several different shapes and the number of sizes for each shape varies notably.

Thanks again,

T
terryhendicott21-Topaz II
21-Topaz II
December 3, 2022

Upload the spreadsheet of the section parameters and I will show you.

Is possible to have one big table.  Simply stack the data from each section type.

Enclosed is a spreadsheet of all the sections so not sure if it covers all your sections.

Capture.JPG

Terms & ConditionsAccessibility statement