Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Exporting MathCad to specific Cells in Excel

Status
Not open for further replies.

HelpAng

Mechanical
Oct 23, 2003
13
0
0
CA
I need to export data from MathCad to specific cell ranges within Excel, where normally in MathCad it automatically starts at A1, where I want it to start at A3
Can someone tell me if this is possible!!!!!!
 
Replies continue below

Recommended for you

Hi!

I suggest you export data from Mathcad first to one Excel sheet, and then link that to a second Excel sheet where the data is re-written in a convenient place.

In case you want data to be passed back to Mathcad from the second Excel sheet after a table lookup, I suggest you use string function str2vec() to pass data from Mathcad to the first Excel sheet, re-convert to string using CONCATENATE function in the first Excel sheet itself, and then use the re-created string to do a LOOKUP in the second Excel sheet.

The idea is that Excel files talk quite well among themselves, while the interfaces with Mathcad are more rudimentary.

Hope this helps!
 
Status
Not open for further replies.
Back
Top