Copy a field-vector into excel, or transform to a matrix
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Copy a field-vector into excel, or transform to a matrix
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.
- Labels:
-
Mathcad Usage
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello!
Could you upload your worksheet?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ok, thanks alot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you using Mathcad 15 & Office 2007?
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No, Mathcad 14 and Office 2003.
But the example file from Vladimir works fine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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