Skip to main content
ArneClaußen1-Visitor
1-Visitor
June 24, 2011
Solved

Copy a field-vector into excel, or transform to a matrix

  • June 24, 2011
  • 7 replies
  • 4151 views

Hey Guys,

I've got a field vector (i dont know if it's the right english term.. the one which i get when i type in 100,150..2000 for example)

And i have to export it to excel, but when i use an excel component Mathcad only copies the last value (2000 in this example)

So my question is, if there is an quick&easy way to:

copy the whole "field-vector" to excel (without marking the values manually)

or to transform the field-vector in a "normal matrix/vector".

Greetings.

Best answer by VladimirN

Take a look at the problem in the document for Mathcad 15. There is a difference between a matrix created using "Range variable" and without it. The document also shows the ability to create files ".xlsx", containing the results of the calculations.

7 replies

VladimirN24-Ruby IV
24-Ruby IV
June 24, 2011

Hello!

Could you upload your worksheet?

ArneClaußen1-VisitorAuthor
1-Visitor
June 24, 2011

Of course, here you are!

VladimirN24-Ruby IVAnswer
24-Ruby IV
June 24, 2011

Take a look at the problem in the document for Mathcad 15. There is a difference between a matrix created using "Range variable" and without it. The document also shows the ability to create files ".xlsx", containing the results of the calculations.

MikeArmstrong1-Visitor
1-Visitor
June 24, 2011

Are you using Mathcad 15 & Office 2007?

Mike

ArneClaußen1-VisitorAuthor
1-Visitor
June 24, 2011

No, Mathcad 14 and Office 2003.

But the example file from Vladimir works fine.

MikeArmstrong1-Visitor
1-Visitor
June 24, 2011
No, Mathcad 14 and Office 2003.

But the example file from Vladimir works fine.

Ok, if your happy with that example I will leave it there. I was going to pass a few examples of exchanging data between Mathcad and Excel using scripted components, as I have collated a large collection over the years.

On another note have a look at the attached. I have changed your range variable to a vector using a pre-defined function (vec) in the collapsed area. It's good practice to keep away from range variables for later use (Well in my opinion anyway).

Mike

Terms & ConditionsAccessibility statement