Skip to main content
10-Marble
August 17, 2013
Question

Export data from mathcad to Creo notebook(earlier layout)

  • August 17, 2013
  • 2 replies
  • 8047 views

Hello,

I have a done calculation in mathcad to check my design for safety.

Now, i want those inputs used for calculation in mathcad to become parameters in creo. These parameters i want to use in notebook which will drive my assembly.

Also , if i change my design in mathcad, corresponding change should occur in notebook parameter and so in assembly.

If direct link is not possible, excel as a link will also do.

thank you for you time.

2 replies

24-Ruby IV
August 17, 2013
vkothari10-MarbleAuthor
10-Marble
August 17, 2013

hi,

thank you for your response, it was helpful, but not what i was seeking.

In notebook when i check analysis, all analysis are grayed out(inactive) , excel analysis/tool based/external/mathcad analysis/prime analysis.

All inactive.

Hope to get an answer from somewhere ....

If there is a method where i can convert mathcad inputs into excel and then from excel to creo notebook and as a parameter...even that will do...

I also found there is command named writeexcel(filename,input) but gives error saying check unit.

my inputs are of different units and it does not take them into one array.

.........................................................................................................................................................

25-Diamond I
August 17, 2013

The "Mathcad inputs" you are talking about are outputs, viewed from Mathcad, right? 😉

I don't use Creo but maybe I can help you in getting your data into an Excel file.

You don't state if you are using Prime or real Mathad (15 or below), but as of the unit problem you report, I guess you are using MC15 or similar. Prime would support different units in an array - a plus of Prime among a lot of minus.

As Excel does not support units you would have to get rid of the units anyway if you write your data to an Excel file. You can do this by simply dividing the variable by the unit you want the value to be in when you collect your "inputs" into a matrix.

If you have further problems it may be helpful if you post your worksheet, if possible, and state what values you want to be written to which cells in the Excel sheet with WRITEEXCEL.

1-Visitor
July 7, 2015

Simplified Logic Inc specializes in bi-directional Excel to Creo or Creo to Excel data transfer this with an application called Nitro-CELL.  Please see this Website: Simplified Logic, Inc. and YouTube Channel:  Simplified Logic, Inc. - YouTube