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

READPRN in a referenced worksheet.

OLUBUKOLAADEBOY
7-Bedrock

READPRN in a referenced worksheet.

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

View solution in original post

6 REPLIES 6

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

 

Thanks to both of you.

Moses

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 !?

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

Hi

 

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

 

Cheers

 

Thanks Terry

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."