Velocity

=Velocity(string template, range vector) : string

Adds powerful velocity string templating functionality to Excel.

Read more about  velocity syntax

Velocity in SeoTools

Access elements in vector:
$P0, $P1, $P2…

Use any SeoTools function in your template:
$SeoTools.UrlEncode(‘niels is awesome!’)

Eval any excel formula:
$Utils.Eval(‘A1′)
$Utils.Eval(‘A1:C1′)
$Utils.Eval(‘SUM(A1:C1)’)

Look in the cookbook folder for examples.

 

Comments are closed.