Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
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.
Solved! Go to Solution.
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.
Hello!
Could you upload your worksheet?
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.
Ok, thanks alot.
Are you using Mathcad 15 & Office 2007?
Mike
No, Mathcad 14 and Office 2003.
But the example file from Vladimir works fine.
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