When you just use mycol1 and mycol2, Origin is looking for columns named mycol1 and mycol2, and when it doesn't find them it correctly returns the "failed to resolve range" error.
Keep in mind that the loop will only run once. The next time it tries to evaluate the input for plotxy, the workbook is no longer active, so it won't be able to. Your input range for the plotxy function needs to contain the workbook name.
I have something working but it plots each of the loop iterations as a separate layer, i desire each loop iteration to draw the plot on the same sheet. The code i have which does this is
range rSheet = $(page.active)!; // range is the active worksheet object
range rPage = rSheet.GetPage()$; // range is page to which the sheet is attached
int mycount = int(rSheet.NCOLS); // number of cols in the sheet
int mycol1 = 6;
int mycol2 = 3;
for( ix = 1 ; ix < mycount/6 ; ix += 1 )
{
plotxy [%(rPage.name$)]%(rSheet.name$)!($(mycol1),$(mycol2)) plot:=200;
mycol1 = mycol1 +6;
mycol2 = mycol2 +6;
}
Try this, following your original code as closely as possible.
int mycol1 = 6;
int mycol2 = 3;
string wbkname$=%H;
win -t plot;//create empty plot first so it remains %H
//plot all into 1st layer of active plot
loop (i,1,24)
{
plotxy [wbkname$](1:end)!(wcol(mycol1),wcol(mycol2))
plot:=200 ogl:=1!;
mycol1 = mycol1 + 6;
mycol2 = mycol2 +6;
}
plotxy loop
Posted - 04/09/2009 : 09:24:26 AM
