Skip to main content
R
Raiko17-Peridot
17-Peridot
April 23, 2024
Solved

Insert existing excel component in mathcad sheet

  • April 23, 2024
  • 2 replies
  • 2250 views

I have an already filled in Excel sheet with parameters and variables that I use in a Mathcad calculation. I could copy 'n paste the content to an embedded Excel component, but I'd like to avoid such menial task.

Has anybody figured out whether and how to insert an Excel component that has content?

Best answer by Perez

Hello @Raiko ,

 

To insert an Excel component with content into Mathcad Prime, please follow these steps:

  1. Save the Excel file you wish to insert as a template with the *.xltx extension.
  2. Insert an empty Excel component in your Mathcad Prime worksheet and open the Excel interface.
  3. Right-click on the 'Sheet1' tab and select 'Insert'. Choose the Excel template you created in step 1.

Note: To find the location to save the Excel template, right-click on an existing template file during the insert step, select 'Properties', and copy the file path.

2 replies

ttokoro
21-Topaz I
ttokoro21-Topaz I
21-Topaz I
April 23, 2024

How about using READEXCEL function?

t.t.
R
Raiko17-PeridotAuthor
17-Peridot
April 23, 2024

Hi,

 

I did that until now. Problem is that you always have to take care that the Excel sheet travels with the Mathcad sheet when handing out Mathcad calculations to colleagues. Usually I ended up helping them to find it and do half of the work for them. An embedded Excel component can't be lost (nor the reference) and is therefore much more convenient.

L
LucMeekes23-Emerald IV
23-Emerald IV
April 23, 2024

Hi Raiko,

 

(real) Mathcad, or Prime?

 

Excel file:

LucMeekes_8-1713894269679.png

 

Mathcad:

LucMeekes_3-1713893912226.png

LucMeekes_4-1713893991232.png

LucMeekes_5-1713894071024.png

LucMeekes_6-1713894129741.png

LucMeekes_7-1713894188658.png

Success!

Luc

P
Perez14-AlexandriteAnswer
14-Alexandrite
April 25, 2024

Hello @Raiko ,

 

To insert an Excel component with content into Mathcad Prime, please follow these steps:

  1. Save the Excel file you wish to insert as a template with the *.xltx extension.
  2. Insert an empty Excel component in your Mathcad Prime worksheet and open the Excel interface.
  3. Right-click on the 'Sheet1' tab and select 'Insert'. Choose the Excel template you created in step 1.

Note: To find the location to save the Excel template, right-click on an existing template file during the insert step, select 'Properties', and copy the file path.

    R
    Raiko17-PeridotAuthor
    17-Peridot
    April 25, 2024

    Thank you Perez. It worked.

    Raiko

    Terms & ConditionsCookie settingsAccessibility statement