Ok, my data workbook contains 30 worksheets each with 32 columns. I would like to apply a function on each column of each worksheet. I want the output of this function to be placed in another file in the corresponding worksheet and the corresponding column. I know how to loop over a column but I don't know how to loop over a worksheet. I am aware of the doc -e LB function but it doesn't fit the need. To loop over columns, you increment the column number by using wcol. Is there a corresponding function for worksheets ?
Thanks for the answer. I finally found a way to do it by using doc -e LB. I'm using the name of the worksheet as an "incremental" variable.
doc -e LB { string ss$=wks.name$;
then I perform my operation on every column of the considered worksheet using a for loop and store the final result in a worksheet of the same name but in a different workbook.
// Worksheets are layers in the Workbook (Page Object) for( laynum = 1 ; laynum <= page.nlayers ; laynum++ ) { page.active = laynum; // Set the Sheet/Layer as active ty layer.name$; // Demonstrate next sheet is now active }
Looping over worksheets
Posted - 03/26/2010 : 3:57:52 PM
