Excluding rows from import

if (value() == 'foo') {
   excludeRow()
   return
}
return value();

Working with global values

Useful when you need to pass parameters over rows or columns. Following example shows how to count number of rows:

Integer count = getGlobal('key');
if (count == null) {
	count = 1;
}
setGlobal('key', count++);

 

 

  • No labels