Hello,
Because Origin has a maximum sheet number in a workbook of 255;
How about make 2 new workbooks with 150 sheets each, and in every sheet have 3 columns
The process can be done by LabTalk;
Please see example below:
//create new book with 3 sheets (small number for test)
newbook name:="MyData" sheet:=3;
//loop through each sheet
doc -e lw{
// add 1 column for each sheet
wks.addCol(1);
}
//loop through each sheet in 3 books
loop(ii,1,3) {
range rW = [MyData]$(ii)!2;
range r1=[Book1]$(ii)!2;
range r2=[Book2]$(ii)!2;
//perform arithmetic operation on specific column
rW=r1-r2;
}
Best regards!
Jason
OriginLab Technical Service
