| T O P I C R E V I E W |
| KMnO4aq |
Posted - 02/04/2012 : 10:48:35 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8.5 SR1
Operating System: Windows 7
So, I am pretty new to using origin's command line (I usually just use origin to plot). I am working on a 3D plot at the moment. I have all of my data in about 200 worksheets in a workbook, and I need to take the last column of each worksheet in place it into a matrix to make my 3D plot. The worksheets are arranged left to right on the bottom of my workbook in the order they need to be put into the matrix.
I have been playing with "doc -e LB {......" commands, but nothing works at all.
Any ideas?
Thanks! |
| 1 L A T E S T R E P L I E S (Newest First) |
| Drbobshepherd |
Posted - 02/05/2012 : 12:54:51 AM
Open a new workbook. Then execute a script to copy the last col from each data sheet into the new book. Finally, convert the new worksheet to matrix using the Worksheet/Convert to Matrix menu.
In your script, use the loop command to execute the colcopy X-function for each data sheet.
Some objects you may need:
page.nLayers, Number of sheets in a book.
wks.nCols, Number of columns in a sheet.
Have fun programming. Let me know if this helped.
DrBob |
|
|
