Importing Excel Data
Importing Excel Data
(OP)
Is there an easier way to access a large table of values compiled in Excel and use it in Mathcad Prime. For example, I would like to be able to input the name of a wide flange steel shape and then have the different values (section properties) pulled into Mathcad so that I can write calculations in them. The examples I've found use fairly small tables for the Excel Component and Read Excel functions, but to pull in all of the WF shapes you need a very large table or Excel component and it becomes cumbersome. As of now I have a sheet that I manually overwrite the input from the AISC tables. For example if I want to check a W10x45 column I have to manually look up the section properties and enter them in Mathcad. In Excel I've used the VLOOKUP function to do what I'm trying to do now in Mathcad Prime.
RE: Importing Excel Data
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Importing Excel Data
I'm just now realizing that I should have asked a much simpler question. I may not need the whole table in Mathcad. Is there a way to look up one row of an Excel file and import just that row into the Mathcad file? For example, I choose a W10x45 in Mathcad Prime and then I need a function that will go into the Excel table and find the row for W10x45 and import all the section properties. Next time I might need a W12x53 so I need the function tied to the chosen shape. All of the examples/methods I'm finding simply import a fixed range of cells. I've only recently started to use Mathcad so maybe I'm overlooking it. It just seems like a simple task.
RE: Importing Excel Data
http://blogs.ptc.com/2015/12/08/5-tips-to-transiti...
RE: Importing Excel Data
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Importing Excel Data
RE: Importing Excel Data
RE: Importing Excel Data
I put my steel shape in as an input variable. Say I have a table that is A1:BC2000 I will have the steel shape name dump into A2002 or something, aligning with the shape names column.
I add an index column in excel to use MATCH to find the index of the shape I am looking for, then use a LOOKUP command across the row for all the properties I want
I have an output variable from the excel component that covers the range of section properties for the shape I want - this give me a horizontal vector of all the section properties.
I then have property definitions based upon the index of that horizontal vector.
It takes a little work to set up, but it works great for me. I usually define my section with the global definition and have all the excel and property definitions hidden in an area region above all my work, just so its easy to find and copy/paste as needed.
With this set up, I can also add multiple input variables, and pull out the data for multiple shapes at once.