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 | |