Copy & Paste From Excel to Mathcad

---

@Werner_E wrote:

Copy & paste is awfully broken in Prime in various aspects.
So I guess the simple way you tried was thus successfully blocked by PTC

What a shame.  I was afraid of that, but thank you for confirming my suspicions.

---

@Werner_E wrote:

Are you sure that this is the suitable data structure you need for your further calculations?

---

After watching countless YouTube videos last night, searching for an answer, and trying all of the things you already mentioned, it was the closest I could get to what seemed like a working solution.  Lo and behold, I again hit a roadblock though.

---

@Werner_E wrote:

You may use the function READEXCEL to read in the data from the external Excel sheet. Either three times to create the very three vectors you cretaed via the table or in one go by reading in the data in a matrix (a 3x3 matrix in case of your example).

 

If the external EXCEL sheet is static and not subject to change you may also consider embedding it by creating an Excel component and then copy the data from the external sheet to it. PTC has provided no way to embed an already existing sheet - what a shame.

Another workaround using a template file was suggested here Insert existing excel component in mathcad sheet

Once the data is in the embedded sheet you can extract any data you like to Prime vectors or matrices.

 

---

I'm trying to set up a clean, succinct workflow for my fellow engineers.  All that should ever change is the 3x3 matrix.  I had hoped to avoid the use of an external Excel file if possible and any external dependency.  It just adds another unnecessary step to the workflow when all I need to do is paste one 3x3 matrix.  Nevertheless, thank you for the feedback.  I understand the situation and can take another route now.

Using a tool like AutoIt or similar sure is not an easy and convenient replacement for simple copy and paste a 3x3 matrix from Excel to Prime. But its a nice idea and I guess with some work it would be possible to automate the process of transferring a couple of values from specific positions in Excel to the Prime table. But then it may be easier to use READEXCEL and then copy the matrix read in to a variable, making the data static to sheet and avoiding the necessity of distributing an external Excel sheet along with the Prime sheet.

According more complex matrix editing features - I would already be happy if PTC would get rid of the idiotic and playful way scrolling is implemented in larger matrices and create a workable way to do it. It's almost impossible to quickly manually target a specific location in a larger matrix with a few thousand entries, such as where positive values and negative values switch or similar.