From Mathcad to Microsoft Excel
From Mathcad to Microsoft Excel
(OP)
Is there a way to import data (calculation results) from Mathcad into MS Excel? Please list the steps involved.
Please note: I am asking about getting information *into* Excel *from* Mathcad and not the other way around.
Please note: I am asking about getting information *into* Excel *from* Mathcad and not the other way around.





RE: From Mathcad to Microsoft Excel
Other than that, you can write out a data file that's read in by Excel, I suppose.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: From Mathcad to Microsoft Excel
You'll want to strip the data of any units before the transfer. Also, if you have a lot of data, it is possible to transfer it as an an array of data.
RE: From Mathcad to Microsoft Excel
assuming you have a matrix called test, type
test =
highlight the rows/columns you want to copy
right click, and select "copy selection" (DON'T select "copy")
paste into excel normally.
Peter
RE: From Mathcad to Microsoft Excel
Also, Ctrl-C does the same thing as Copy Selection.
You have to format matrix results as a table to select rows/columns instead of the whole matrix.
RE: From Mathcad to Microsoft Excel
I think Tom gutman wrote/documented it. It used a short VBscript function.
Philip