Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Removed translated content for 'zh'
Sv translation
languageen

Excluding rows from import

Code Block
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:

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

 

 

Sv translation
languageja

インポートから行を除外します

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

グローバル値の操作

行または列の上にパラメータを渡す必要があるときに便利です。例に続いて、行数をカウントする方法を参考してください。

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