cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

Mathcad to excel

tdonov
1-Newbie

Mathcad to excel

Hi,

I have used quite a lot of the functions in mathcad, however for the first time I have to output some data into excel from mathcad.

I have a graph with two variables (x and y axis)

I want to input one of the variables in column A and the other in column B.

I have attached the file as well.

Any help will be much appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
LucMeekes
23-Emerald III
(To:tdonov)

Make sure the data you want to output to excel consists of arrays. Currently your T is a range, rather than an array, and S.d is a function, not an array.

If I change:

and add the sub t to the T for the plot items, I get the same plot.

Then I do:

And I get this from the excel block:

Does that make you happier?

Another way is to just write out the data to a .CSV file and read it into excel.

You might use:

You can import the datafile "File" in into excel.

Success!
Luc

P.S. The file as modified by me is attached. Note, it's a Prime version 4 file. If you have a lower version of Prime (only), you cannot read it.

View solution in original post

6 REPLIES 6
LucMeekes
23-Emerald III
(To:tdonov)

Make sure the data you want to output to excel consists of arrays. Currently your T is a range, rather than an array, and S.d is a function, not an array.

If I change:

and add the sub t to the T for the plot items, I get the same plot.

Then I do:

And I get this from the excel block:

Does that make you happier?

Another way is to just write out the data to a .CSV file and read it into excel.

You might use:

You can import the datafile "File" in into excel.

Success!
Luc

P.S. The file as modified by me is attached. Note, it's a Prime version 4 file. If you have a lower version of Prime (only), you cannot read it.

Hi,

I made the changes, however some reason on the line:

T.t=0.01*t*sec

my t gets a red box around it saying "This value must be a scalar or a matrix."

Have you changed anything above that? Can the problem come from the newer version that you are using?

tdonov
1-Newbie
(To:tdonov)

NVM! I managed to do it! Thanks a lot!

Hey! I'm trying to do the same here, but it's not working. 

I have a function f(t). I wish to get the values at different times into an excel file, it's a lot of values to type it manually. My time step is 0.036sec and I want the values of f(t) from 0-20sec.  

Can u help me! 

Try this:

FredKohlhepp_0-1594123725161.png

 

thank you so much sir. This worked.

I was working on this for soo long and it worked now, with your solution. 

thank you again sir. means a lot. 

Top Tags