Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting MathCad to specific Cells in Excel
- Thread starter HelpAng
- Start date
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!
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
Similar threads
- Locked
- Question
