Skip to main content
D
DM_99879343-Newcomer
3-Newcomer
November 21, 2023
Solved

MathCad Prime 9.0 - Exporting data set Excel

  • November 21, 2023
  • 1 reply
  • 1958 views

Hi,

 

I'm trying to get a set of data in a form where I can copy and paste it into a another application. It is two columns of data. The first is a range variable. The second is a calculation on the range variable.

I've tried to get the two columns of data into an embedded Excel Component but just can't see how to do it. Getting confused between ranges versus vectors/matrices.

Is there a way of converting the range variable into a vector?

Any help would be much appreciated.

 

DM_9987934_0-1700586184892.png

 

I thought if you can see the indices, it is a vector/matrix?

 

Dave

Best answer by Werner_E

AH, I see the main problem now.

sigma.t is not a vector but a range variable! And so epsilon.t(sigma.t) is neither a range nor a vector - its an invalid object which can just be used for displaying the result but it can't be assigned to a variable nor can you access individual entries.

Its a pity that vectors and range look quite the very same in Prime.

 

Here I use a bold  and undocumented trick to turn a range into a vector by using an inline evaluation (the = at the end).

Werner_E_0-1700587826717.png

Don't  try to change Pa to Mpa - it will throw an error.

 

Now you have a vector s of data values which you can use for export or as an input to an Excel component.

When you feed this vector in your function epsilon.t you have to apply vectorization (the arrow over the expression)

Werner_E_1-1700587928382.png

 

1 reply

W
Werner_E25-Diamond I
25-Diamond I
November 21, 2023

In real Mathcad you could simply copy & paste the data from the Mathcad matrix to an Excel sheet, but copy & paste unfortunately is severely broken in Prime.

Why don't you try the WRITEEXCEL() function instead of the Excel component.

Or do you really need the data transferred to an embedded Excel sheet?

W
Werner_E25-Diamond IAnswer
25-Diamond I
November 21, 2023

AH, I see the main problem now.

sigma.t is not a vector but a range variable! And so epsilon.t(sigma.t) is neither a range nor a vector - its an invalid object which can just be used for displaying the result but it can't be assigned to a variable nor can you access individual entries.

Its a pity that vectors and range look quite the very same in Prime.

 

Here I use a bold  and undocumented trick to turn a range into a vector by using an inline evaluation (the = at the end).

Werner_E_0-1700587826717.png

Don't  try to change Pa to Mpa - it will throw an error.

 

Now you have a vector s of data values which you can use for export or as an input to an Excel component.

When you feed this vector in your function epsilon.t you have to apply vectorization (the arrow over the expression)

Werner_E_1-1700587928382.png

 

    Terms & ConditionsCookie settingsAccessibility statement