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 for Programming
 LabTalk Forum
 confusion with range notation and datasets		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

fexxor

USA
Posts
Posted - 03/15/2009 :  5:36:19 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin 8 Ver. and Service Release 4



After computing several datasets, call them ds1,ds2, etc, I want to put these dataset (save them ) into the appropriate worksheet column, say col(3), col(4), etc. I know the range of the entire worksheet call it rr. How can I do this?

Is there a way of specifying the columns of the worksheet in range notation without having to define a different range for every column?

Thanks for any clarification.

greg

USA
1379 Posts
Posted - 03/23/2009 :  11:38:46 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
There isn't a shortcut notation that gets a range as a string for use in declaring a new range so you have to construct the string from it's parts.

string strBk$ = rr.GetPage()$; // Get the Book referenced by 'rr'
string strSh$ = rr.name$; // Get the Sheet referenced by 'rr'

Then you can use these parts to declare new ranges and if need be use variables in the declaration such as:

loop(ii,1,5)
{
range rTemp = [strBook$]strSheet$!$(ii); // Re-declare range rTemp to use the next column
rTemp = ds$(ii); // copy dsN to next column
}
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