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

We are troubleshooting an issue impacting community login, and it may be intermittently unavailable. Sorry for any inconvenience.

Import data from excel to mathcad

NA_11204287
4-Participant

Import data from excel to mathcad

Hi all, is there any ways to import the data from excel into the Mathcad table?

 

NA_11204287_1-1726735266163.png

Data in excel table

 

NA_11204287_0-1726735196873.png

Data in Mathcad Table 


Thank you for your help! *i'm using MathCad Prime 10.0.0.0

ACCEPTED SOLUTION

Accepted Solutions
StuartBruff
23-Emerald III
(To:Werner_E)


@Werner_E wrote:

A Prime table can only be typed in manually.


Not quite.  I played and found that you can paste Excel data directly into a worksheet, and Mathcad inserts it as a Table.  Here's an example that I just created ...

 

2024 09 19 A.png

 


To Import Data from Excel

 

Of course, I would have saved myself some time and effort if I'd watched your link first, as this method is explained therein! 🙂

 

Still, nice to know that it worked as I intuitively hoped it would.

 

 

Stuart

 

Edit to add: I couldn't find a way to link a table to Excel, though.  Still, as you say, there is little need to do so.

 

View solution in original post

7 REPLIES 7
Werner_E
25-Diamond I
(To:NA_11204287)

A Prime table can only be typed in manually. Its just for input, not for display of already existing data.

But a Prime table is simply a collection of vectors.

You could use the function READEXCEL to read in the data from the Excel sheet

To Import Data from Excel

StuartBruff
23-Emerald III
(To:Werner_E)


@Werner_E wrote:

A Prime table can only be typed in manually.


Not quite.  I played and found that you can paste Excel data directly into a worksheet, and Mathcad inserts it as a Table.  Here's an example that I just created ...

 

2024 09 19 A.png

 


To Import Data from Excel

 

Of course, I would have saved myself some time and effort if I'd watched your link first, as this method is explained therein! 🙂

 

Still, nice to know that it worked as I intuitively hoped it would.

 

 

Stuart

 

Edit to add: I couldn't find a way to link a table to Excel, though.  Still, as you say, there is little need to do so.

 

wonderful! this solution works on me. many thanks!

StuartBruff
23-Emerald III
(To:NA_11204287)

No worries.  Werner had pointed to the solution in his message, as well.

 

Cheers,

 

Stuart

Werner_E
25-Diamond I
(To:StuartBruff)


@StuartBruff wrote:

No worries.  Werner had pointed to the solution in his message, as well.

and he wasn't even aware of that 😄

Werner_E
25-Diamond I
(To:StuartBruff)


@StuartBruff wrote:

@Werner_E wrote:

A Prime table can only be typed in manually.


Not quite.  I played and found that you can paste Excel data directly into a worksheet,


OK, admittedly thats not 'typing' but still is what I had in mind when I wrote "manually".

You cannot import data from Excel via a command and display them as a table but of course copy & paste still is much less tedious  and failure prone than retyping  😉


I remember quite some threads here where the feature to display already existing vectors and/or matrices in that kind of table format was requested but up to now a table still is intended for input only.

 

StuartBruff
23-Emerald III
(To:Werner_E)

Hey, I pressed Ctrl-V, Werner.  What more do I have to do to *type* it in?  😁

 

Stuart

Announcements

Top Tags