We are troubleshooting an issue impacting community login, and it may be intermittently unavailable. Sorry for any inconvenience.
Hi all, is there any ways to import the data from excel into the Mathcad table?
Data in excel table
Data in Mathcad Table
Thank you for your help! *i'm using MathCad Prime 10.0.0.0
Solved! Go to Solution.
@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 ...
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.
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
@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 ...
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!
No worries. Werner had pointed to the solution in his message, as well.
Cheers,
Stuart
@StuartBruff wrote:
No worries. Werner had pointed to the solution in his message, as well.
and he wasn't even aware of that 😄
@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.
Hey, I pressed Ctrl-V, Werner. What more do I have to do to *type* it in? 😁
Stuart