Read CSV and Embed

[ppal]

I wish to read a CSV file and embed the data into Mathcad.

Files attached

.

[terryhendicott]

Hi,

Enclosed is a file with one matrix data that holds all you data from the csv file.

1)Open Excel and read the csv file, select all the data and Ctrl+C  to copy

2)Open Mathcad 15 and set an equation data=, then Ctl+V to paste matrix into right hand side.

3)convert mathcad 15 to Prime.

[terryhendicott · Accepted solution]

Hi

If you want to do it with Prime only:

Select data in Excel without the headers and Ctrl+C.

In a prime document locate cursor in space and Ctrl+V.

An input table will be created without headers.

Copy/Paste the headers one by one.

See enclosed file

Cheers

Terry

[Werner_E]

---

@terryhendicott wrote:

Hi,

Enclosed is a file with one matrix data that holds all you data from the csv file.

1)Open Excel and read the csv file, select all the data and Ctrl+C  to copy

2)Open Mathcad 15 and set an equation data=, then Ctl+V to paste matrix into right hand side.

3)convert mathcad 15 to Prime.

---

If using Mathcad 15 would be an option, you won't need to use Excel. You could use READCSV to read in in the data into a variable DataL, display DataL and copy and paste the whole matrix either to a new variable and then convert the worksheet or you may copy it to a variable in the Prime sheet directly.

This should work in Prime as well but it doesn't because Prime would only copy the visible part of the matrix. Thats quite idiotic but that the way PTC had implemeted it.

To do it in Prime alone without using any third party software like Excel, you would first had to enlarge the matrix to its full size taking up some pages and then copy and paste it to  anew variable. very tedious for matrices with about 1000 rows or more.

Copy&paste sure is something PTC should improve.

[vnamboodheri]

Hello @ppal,

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.