READPRN in a referenced worksheet.

[OLUBUKOLAADEBOY]

Good Morning Community,

Would anybody be kind to look into the Mathcad sheet. My goal is to read Steel section properties in the attach W.prn file into Mathcad, but I was getting an error messages. Please help.

Best Regards

Moses

[LucMeekes · Accepted solution]

The function READPRN requires that all data in each column is of the same type.

If you strip the two top rows from the file, you should be able to read the data with READPRN.

Otherwise see if you can use READFILE.

Success!
Luc

[OLUBUKOLAADEBOY]

Thanks to both of you.

Moses

[Werner_E]

You have to delete the first row of your data file as Mathcads READPRN thinks that data started whenever it encounters the first digit.

The column headers in the second row are no problem here.

Why don't you use the Excel file for data import? You may use READEXCEL. to do so.

Furthermore your sheet references a lot of functions like columns(null) which are not defined anywhere in your sheet !?

[terryhendicott]

Hi,

The Mathcad 15 sheet following reads a text file to input Universal Beam property data.

The top row of the file is header information

Enclosed is the text file.

The worksheet is capable of determining the beam to use in a given situation.

Australian steel sections.  I remember doing a European steel version but could not find it.

Cheers

Terry

[terryhendicott]

Hi

Here is a file of your data that can be opened in Mathcad Prime with READCSV.

Cheers

[OLUBUKOLAADEBOY]

Thanks Terry