Skip to main content
J
jdesai-21-Visitor
1-Visitor
June 5, 2017
Question

copy and paste excel spread sheet cells

  • June 5, 2017
  • 1 reply
  • 2080 views

How do you copy and paste cells from an excel spreadsheet in Prime? I would like the cells to be editable

1 reply

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
June 6, 2017

Not sure I understand your question.

If you insert an EXCEL document (in Prime), you can insert input expressions at the top that will put the values of Mathcad variables into the sheet and insert output expressions along the bottom to extract values from EXCEL and assign them to variables in Mathcad.

If you double-click the object in Mathcad, the sheet opens as "object" in EXCEL, and you can do whatever EXCEL will let you do:  cut, paste, format, etc.

J
jdesai-21-VisitorAuthor
1-Visitor
June 6, 2017

Thanks Fred.

I highlighted a group of cells in excel, copied and pasted them into Prime, and it put "red paperclips" across all the cells at the top. I don't need the whole document, just a few cells to form a table, so I don't know if I should use the insert command or not

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
June 6, 2017

Jim

When you copy and paste from EXCEL to Prime, Prime creates a "table,"  the "red paper clips" are a request for a variable name.  (Underneath the variable name is a place for units.

Terms & ConditionsCookie settingsAccessibility statement