Skip to main content
tdonov1-Visitor
1-Visitor
April 26, 2017
Solved

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!

LucMeekesAnswer
23-Emerald IV
April 26, 2017

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 in thread

6 replies

LucMeekes23-Emerald IVAnswer
23-Emerald IV
April 26, 2017

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.

Translate
tdonov1-VisitorAuthor
1-Visitor
April 27, 2017

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?

Translate
tdonov1-VisitorAuthor
1-Visitor
April 27, 2017

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

Translate
Terms & ConditionsAccessibility statement