| T O P I C R E V I E W |
| gkbradshaw |
Posted - 04/14/2011 : 12:13:37 AM
Origin Ver. 8.1 and Service Release 8.1.88.89
Operating System: Windows XP
I'm very new to Origin and I guess I'm still stuck in my ways of using Excel somewhat. I found this code here that find the x- and y-axis crossings of a line by typing this into the command window:
range r1 = [Book1]Sheet1!col(1);
range r2 = [Book1]Sheet1!col(2);
r2(0)=;
r1(0, r2)=;
This code works great, but I want to set up a template to import data and have the output of this be put into the first cell of two new columns that are otherwise empty. Or if there's a better place to show this data, that's fine. The point is that my Book1 and Sheet1 names can be very long and will always change and I don't want to have to type this in manually every time I import a new data set, that would take forever... Any help on how I can manipulate individual cell values through assignment would be greatly appreciated.
G |
| 1 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 04/14/2011 : 3:43:06 PM
Active elements of a range can be omitted, so if your code executes within the context of the active worksheet of the active workbook, then you can use:
range r1 = col(1);
range r2 = col(2);
col(3)[1] = r2(0);
col(3)[2] = r1(0, r2);
|
|
|
