File: (Leave blank for jxlrwtest.xls)
       
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:
#xls2query.exportSQLTable(daQries[1],"masterList")# #xlsXml.getXML(workbook = workbook,startRow = form.startRow, maxRows = form.maxRows)#