XLSX Template

FREEMIUM
Door kurukona | Bijgewerkt לפני חודשיים | Business Software
Populariteit

8 / 10

Latency

3,011ms

Serviceniveau

100%

Health Check

N/A

Terug naar alle tutorials (2)

Template Syntax

Syntax list

Syntax
${interpolation} ${interpolation[![defaultValue]]}
Bind the data to display in the cell. You can use javascript expressioin and function, objects within ${}.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-interpolation
#if #if {statement} … [#else if {statement}] … [#else] … #end
Outputs rows within a given block according to the conditional expression.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-if
#foreach #foreach {itemName}:{itemArray} [max={intValue}] [index={indexName=’_foreach_index’}] [range={rangeName=’_foreach_range’}] … #end
Executes a loop over the array set in {itemArray}. Each element is processed with the name specified in {itemName}.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-foreach
#while #while {statement} [max={intValue}] [index={indexName=’_while_index’}}] [range={rangeName=’_while_range’}]
Creates a loop that executes the specified statement while a test condition evaluates to true.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-while
#var #var {variableName}={value}[,{variableName}={value}]
Define a new variable name.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-var
#exec #exec {variableName}={value}
Update the value of a variable.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-exec
#formula #={formula}
Define formulas using variables.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-formula
#pagebreak #pageBreak
Add a page break.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-pagebreak
#comment #// {comment}
Used when defining comments that are not output.
https://xlsx-template.kurukona.net/docs/#TemplateSyntax-comment