Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Export data

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-07-2017
09:37 AM

04-07-2017
09:37 AM

Export data

Hello,

I am using Prime 3.0. I want to export data from a trace in a plot into Excel. How can I do this?

I can see one can import data from Excel, but what about exporting from Mathcad to Excel?

Thanks in advance

Pascal

Labels:

5 REPLIES 5

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-07-2017
09:55 AM

04-07-2017
09:55 AM

Re: Export data

One possibility is:

You can use WRITEPRN and APPENDPRN to write successive rows of a matrix to the same output file and after completion read the data into Excel as a (comma separated) delimited file.

Success!

Luc

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-07-2017
10:20 AM

04-07-2017
10:20 AM

Re: Export data

Thank you. I'll try to do it this way. I have to get my data into a matrix. I have defined how to plot Gain ad Phase of a complex transfer function. I only have the traces so far. I'll try to manage that before using your advise.

Thanks

Pascal

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-08-2017
09:45 AM

04-08-2017
09:45 AM

Re: Export data

I don't have Prime 3 (but Express Prime 3.1 and 4). But I do have Mathcad 11.

You should be able to write a program like this in Prime 3 to produce a .CSV formatted file from a matrix:

Success!

Luc

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-08-2017
09:51 AM

04-08-2017
09:51 AM

Re: Export data

Ah, Prime (at least in version 3.1 and up) has the function WRITEFILE to write a matrix to a text or Excel file. So maybe you don't need to pragram at all.

Produces a file with contents:

"One" "Two" "Three"

1 2 3.14159265358979

-1 -2 -3.14159265358979

That is Tab-separated, which is also good for Excel.

Success!

Luc

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-08-2017
10:16 AM

04-08-2017
10:16 AM

Re: Export data

So probably an implementation of my WRITECSV function that better matches Prime's WRITEFILE function is:

Should anyone need this functionality in Mathcad (15 or below), it is attached.

Luc