quote:

---

range strom = 2:9;
del wcol(32);
del strom;

wtranspose iw:=<active> ow:=<active>;

worksheet -s 0 1 0 1;
wks.SetAsLabel(C,-1,0,0);

col(1)=Data(1,22);

wcolwidth irng:=%H width:=7;

//deleting cols with empty data
ncols=wks.ncols;
for(ii=ncols;ii>=1;ii--)
{
if (mean(wcol($(ii))) == 848)
{
del col($(ii));
}
}

//add new book, activate book1 again 
newbook;
win -a Book1;
wks.name$ = Raw;

//interpolation
n=2;
for(ii=2; ii<=wks.ncols; ii++)
{
interp1xy iy:=[Book1]"Raw"!wcol($(ii)) method:=spline npts:=154 oy:=[Book2]"Sheet1"!wcol($(n));
n++;
}

---