Hi It251,
To loop over columns in the worksheet:
//assume source data in [book1]sheet1!
int ncols = wks.ncols;
//add new worksheet for the results
newsheet name:=sheet2 cols:=ncols;
//activate the source data worksheet
page.active = 1;
//loop over columns in worksheet, and put the result in the corresponding column of new worksheet [book1]sheet2!
for(int ii = 1; ii <= ncols; ii++) {
range ss = [book1]sheet1!col($(ii));
range dd = [book1]sheet2!col($(ii));
dd = ss/100;;
}
Hope it helps.
Regards, Yuki
OriginLab