Skip to main content
SFares14-Alexandrite
14-Alexandrite
November 22, 2013
Solved

Import Excel info into Mathcad , and lookup values

  • November 22, 2013
  • 6 replies
  • 11397 views

Hello,

I use mathcad 14. i am attaching a mathcad sheet and an excel sheet that i would like to import it as a table in mathcad to be able to look values for my variables. Based on the selected "Deck Type", it will go in the table which i would like to name"Deck" find the selected deck type, and then look up the proper value for each variable. i listed two variables, "application type" and Gage. Thanks for your help!

Best answer by RichardJ

The text "IntermediateStiffeners?" has a carriage return ()and/or a line feed; can't tell) in the middle. If you double click in the cell you wil see it split to two lines. The same is true in column 22, and other columns. You need to delete all those carriage returns.

6 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
November 22, 2013

You may either use the Excel component or, more transparent and straightforward, use READEXCEL().

You will have to delete the last lines (delete the lines, not just the cells) as Mathcad will choke on the #NV's in column G.

You use a web control to select the deck type and typed in 55 of the 323 posible types by hand, You may consider using a scripted component which reads all possible deck types from the Excel sheet and presents them for selection. There are some examples posted how to do if you search this forum.

is

SFares14-AlexandriteAuthor
14-Alexandrite
November 27, 2013

When i try to use insert , Data, table, then i copy the cells A1:BQ324 in excel and paste table inside Mathcad, the headings are ok up to columns 19 then they wrap around inside mathcad to the next row. i am not sure what's causing this . i just need to copy the table inside excel once. i dont want any interaction between excel and mathcad. just the data. Thanks!

RichardJ19-TanzaniteAnswer
19-Tanzanite
November 27, 2013

The text "IntermediateStiffeners?" has a carriage return ()and/or a line feed; can't tell) in the middle. If you double click in the cell you wil see it split to two lines. The same is true in column 22, and other columns. You need to delete all those carriage returns.

Terms & ConditionsAccessibility statement