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

Mathcad to excel

  • April 26, 2017
  • 1 reply
  • 15367 views

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!

Best answer by LucMeekes

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.

1 reply

L
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.

T
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?

T
tdonov1-VisitorAuthor
1-Visitor
April 27, 2017

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

Terms & ConditionsCookie settingsAccessibility statement