File: jxlrwtest.xls
  Start Row: | Max Rows: (0 for all)

Embedded Excel Row Formulas Example [source]

This is the QueryNew function (for column name reference):
  queryNew("id, name, age, random, active, formulacol, formulacol2","integer,varchar,integer,integer,bit,varchar,varchar")
Formula: [Colum name] = [formula]
In this case, we've got an empty field named "formulacol", and one named "formulacol2" which we'll use to store the formula results
Here are some examples:
  formulacol = SUM(random + age) -- This is obvious- sums the (random + age) row values
  formulacol2 = UPPER(name) -- This will uppercase whatever is in "name" column
Formula Col
Formula Col 2

Test Query Dump:
query
  ACTIVE AGE FORMULACOL FORMULACOL2 ID NAME RANDOM
1 0 37 [empty string] [empty string] 1 User 1 156
2 0 64 [empty string] [empty string] 2 User 2 96
3 0 55 [empty string] [empty string] 3 User 3 376
4 0 20 [empty string] [empty string] 4 User 4 295
5 0 57 [empty string] [empty string] 5 User 5 28
6 0 23 [empty string] [empty string] 6 User 6 43
7 0 25 [empty string] [empty string] 7 User 7 354
8 0 68 [empty string] [empty string] 8 User 8 78
9 0 81 [empty string] [empty string] 9 User 9 114
10 0 71 [empty string] [empty string] 10 User 10 144
11 0 23 [empty string] [empty string] 11 User 11 215
12 0 60 [empty string] [empty string] 12 User 12 157
13 0 21 [empty string] [empty string] 13 User 13 178
14 0 79 [empty string] [empty string] 14 User 14 84
15 0 30 [empty string] [empty string] 15 User 15 322