Skip to main content
M
mythos28th1-Visitor
1-Visitor
January 19, 2018
Question

how to bind or embed an Exel spreadsheet in Mathcad Prime

  • January 19, 2018
  • 2 replies
  • 10178 views

I would like to read values from an Excel spreadsheet in Prime, the same way I did in Mathcad 15.  PTC support set up a Mathcad file using the READEXCEL command.  The associated Excel file needs to be in the same folder as the Mathcad file for the data to be read.  Is there away I can bind or embed the Excel file to the Mathcad file, so I don't need a copy of the Excel file I am working with in every folder?

 

I have tried to insert an Excel component.  Due to the size of the spreadsheet, converting it to a matrix in Mathcad Prime, and reading the values is extremely cumbersome and related to how much of the table is visible.  

 

Thank you!

2 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
January 19, 2018

From Prime 3.0 help:

Capture.PNG

    M
    mythos28th1-VisitorAuthor
    1-Visitor
    January 19, 2018

    Fred,

     

    Following the steps above, for the READEXCEL command allows data to be read from an Excel file located in the directory specified.  The data is not bound or saved within the Mathcad File.  So I can locate my file in one location and read from there, but once I send my Mathcad file in an email to some one else, the table values will be lost.

     

    As far as directly copy and pasting the cells, I have attempted to paste the table directly and receive the spinning circle of no response and Mathcad freezes.  While my table is large, it was easily handled when copying and pasting in Mathcad 15. 

    F
    Fred_Kohlhepp23-Emerald I
    23-Emerald I
    January 19, 2018

    The READEXCEL function will allow you to specify the complete path--you do not have to have the files in the same folder.

     

    I agree that it's better (especially when sending the Mathcad file to others) to have the actual EXCEL file in the Mathcad document.  This is possible!  From the Input/output tab

    Capture.PNG

    Will embed an EXCEL component in the document.  A double click in that component will open it in EXCEL, you copy your data and paste it into the component then you can define variables associated with cell ranges.  (Mathcad 15 had data tables that would allow a similar thing.)

    W
    Werner_E25-Diamond I
    25-Diamond I
    January 19, 2018
    @mythos28th wrote:

    I have tried to insert an Excel component.  Due to the size of the spreadsheet, converting it to a matrix in Mathcad Prime, and reading the values is extremely cumbersome and related to how much of the table is visible.  


    If  embedding the Excel component is no option for you,  you have to keep the Excel File separate. The only other option I could think of is to copy the vital parts of the excel sheet to a Mathcad matrix as explained at the end of the help which Fred posted and hide that part of the sheet in a collapsed region to keep it out of the way. But if the sheet is that huge as you say that might not be an option either.

     

    M
    mythos28th1-VisitorAuthor
    1-Visitor
    January 19, 2018

    This may be related to the other posts in the community as to why Prime does not have the same features as 15?  I was able to copy and paste the component with ease, no matter the size.  There is no reason to move on to Prime from 15, if I cannot resolve this issue.

    F
    Fred_Kohlhepp23-Emerald I
    23-Emerald I
    January 19, 2018

    The EXCEL component in Prime was (I believe) intended to replace the data table.  Like many other aspects of Prime it may be a good idea poorly executed.

     

    I have toyed with using that feature to mitigate the truly horrible plotting capabilities.

    Terms & ConditionsAccessibility statement