The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Col(X) of each wksht in wkbk to matrix in order
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

KMnO4aq

3 Posts

Posted - 02/04/2012 :  10:48:35 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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!

Drbobshepherd

USA
Posts

Posted - 02/05/2012 :  12:54:51 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000