Skip to main content
M
MA_101905451-Visitor
1-Visitor
June 8, 2022
Solved

Copying a Matrix from Prime 8 to Excel and Back

  • June 8, 2022
  • 2 replies
  • 4705 views

Hello

I am trying to copy a matrix that is used to look up structural shapes from Prime 8 to Excel so I can update/add information, then copy-paste back into prime. Is this possible?

Best answer by terryhendicott

Hi,

Like this:

Capture.JPG

Cheers

Terry

2 replies

W
Werner_E25-Diamond I
25-Diamond I
June 8, 2022

On contrary to real Mathcad copy and paste does not work satisfactory and as we would expect it in Prime.
But you may try to use WRITEEXCEL and READEXCEL to ex- and import a data matrix in Prime to and from Excel.

You may also try the Excel component in Prime an see if it fits your needs.

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
June 9, 2022

Hi,

Just tried an experiment.

You can cut and paste from Excel to the Excel component.

Select cells in Excel

Copy Cells

Double click the Excel component in Prime, this opens up Excel.

Paste Cells.

 

Add your data to the Excel component.

 

It also works in reverse to copy from Prime to Excel. Don't forget to double click the Excel component to open an instance of Excel.

 

Cheers

Terry

T
21-Topaz II
terryhendicott21-Topaz IIAnswer
21-Topaz II
June 9, 2022

Hi,

Like this:

Capture.JPG

Cheers

Terry

    M
    MA_101905451-VisitorAuthor
    1-Visitor
    June 9, 2022

    Thanks, the copy/paste line by line is not feasible due to an overbearing size. However I do have the information in excel so I have been working with importing the table in and then converting the table to the matrix. I have gotten it working with a little massaging. Need to perfect it for our needs but headed in the right direction. 

     

    Thanks again Community. 

    Terms & ConditionsAccessibility statement