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