Skip to main content
O
OLUBUKOLAADEBOY10-Marble
10-Marble
June 3, 2019
Solved

READPRN in a referenced worksheet.

  • June 3, 2019
  • 4 replies
  • 3502 views

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

Best answer by LucMeekes

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

 

4 replies

L
LucMeekes23-Emerald IVAnswer
23-Emerald IV
June 3, 2019

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

 

O
OLUBUKOLAADEBOY10-MarbleAuthor
10-Marble
June 3, 2019

Thanks to both of you.

Moses

W
Werner_E25-Diamond I
25-Diamond I
June 3, 2019

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

T
terryhendicott21-Topaz II
21-Topaz II
June 4, 2019

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

T
terryhendicott21-Topaz II
21-Topaz II
June 5, 2019

Hi

 

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

 

Cheers

 

O
OLUBUKOLAADEBOY10-MarbleAuthor
10-Marble
June 7, 2019

Thanks Terry

Terms & ConditionsAccessibility statement