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