cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

how to bind or embed an Exel spreadsheet in Mathcad Prime

Participant

how to bind or embed an Exel spreadsheet in Mathcad Prime

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!

Tags (2)
19 REPLIES 19

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime

From Prime 3.0 help:

Capture.PNG

Re: how to bind or embed an Excel spreadsheet in Mathcad Prime

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. 

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime


@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.

 

Re: how to bind or embed an Excel spreadsheet in Mathcad Prime

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.)

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime

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.

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime

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.

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime

Yes, Prime is far behind Mathcad 15 in many ways. I did not expect that to be true wrt Excel components, too, but its not really a surprise to hear that.

There is no reason to to move on (wouldn't it be rather a move back) to Prime anyway.

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime

Once I insert the spreadsheet as a component, it is clear how to turn the spreadsheet into a Mathcad matrix/table that is readable.  READEXCEL does exactly that.  It makes no sense.  

Re: how to bind or embed an Exel spreadsheet in Mathcad Prime

The advantage to the component is that the numbers are stored in the Mathcad file, there is no need to link to an outside file.  If you send that sheet to someone it will stand alone.  If you send a sheet with a READEXCEL function and don't send the EXCEL file you might as well send a pdf.

Announcements