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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

2-Guest

## Exporting output Mathcad Prime 7.0.0 to Excel

Dear all,

I would like to extract the results from my Mathcad Prime run into Excel, but I’m not able to do so. I looked at the PTC community page but all suggestions given there do not work for me. I think it has to do with the way I run my calculations: I integrate in steps of 200 iterations and store intermediate result in a matrix and run the whole thing 'pmax' times (thus total number of iterations is 200 x pmax).

I would like to extract the output from a certain row and column of matrix for different data points (1..pmax) and export this to Excel. For example, I would like to extract (Yt_ii)1,3 with ii := 1..pmax. Hope anyone can advise.

1 ACCEPTED SOLUTION

Accepted Solutions
24-Ruby V
(To:LucMeekes)

What you create using the range ii are NOT vectors, even if they look that way. Thats the reason you can't use them for anything further.

Here is a way to properly create the vectors and use WRITEEXCEL to export the data:

You have to divide by the correct units otherwise the values in Excel would represent the standard Mathcad units which would be seconds and Kelvin. Getting rid of the Celsius unit is a bit tricky as you can see (you can't just divide by °C),

In case you don't want the data to start at cell A1 you may use the optional range argument of WRITEEXCEL.

3 REPLIES 3
23-Emerald III
(To:JS_10280708)

Success!

Luc

24-Ruby V
(To:LucMeekes)

What you create using the range ii are NOT vectors, even if they look that way. Thats the reason you can't use them for anything further.

Here is a way to properly create the vectors and use WRITEEXCEL to export the data:

You have to divide by the correct units otherwise the values in Excel would represent the standard Mathcad units which would be seconds and Kelvin. Getting rid of the Celsius unit is a bit tricky as you can see (you can't just divide by °C),

In case you don't want the data to start at cell A1 you may use the optional range argument of WRITEEXCEL.

2-Guest
(To:Werner_E)

You're a lifesaver! Thanks a lot, it works smoothly now.

Announcements