informat.excel Excel File Related

Template expression

 1. Space-separated list
 2. Ternary operator: {{test ? obj : obj2}}
 3. n: marks the cell as numeric: {{n:}}
 4. le: length function: {{le:()}}; used in if/else: {{le:() > 8 ? obj1 : obj2}}
 5. fd: date formatter: {{fd:(obj; yyyy-MM-dd)}}
 6. fn: number formatter: {{fn:(obj; ###.00)}}
 7. fe: loop data and create row
 8. !fe: loop data without creating row
 9. $fe: shift-down insert—shift all rows below current row by size() rows, then insert
10. !if: delete current column: {{!if:(test)}}
11. `''` (single quotes) = constant value, e.g. {{'1'}} outputs 1
12. &NULL& = blank space
13. ]] = line break

Numeric type

By default, all cells are formatted as strings. To display a cell as a number, prefix its content with the n: directive.

 {{n: }}

Example

{
  "str": "123",
  "num": 1
}

{{n:str}}
{{n:num}}

Length

Returns the length of the list

{{ le: (array)}

Example

{
  "users": [1, 2, 3, 4]
}

{{ le:(users) }}

Format Date

Returns formatted date

{{fd:(obj;yyyy-MM-dd)}}

Example

{
  date: new Date();
}

{{ fd:(date;yyyy年MM月dd) }}

Format Number

Returns formatted number

{{fn:(obj;###.00)}}

TIP

• Placeholder rules0
  • More digits than the number → pad with leading/trailing 0
  • More digits than the number → no change
• Placeholder# - More digits than the number → no change

Example

{
  "number": 123.456
}

{{fn:(number;###.0)}} // 123.5
{{fn:(number;###.0000)}} // 123.4560

Iterate over data

{{ fe:array }}

Example

{
  "users": [
    { "id": 1, "name": "zhangsan" },
    { "id": 2, "name": "lisi" },
    { "id": 3, "name": "wangwu" }
  ]
}

{{fe:users t.id t.name }}

Other Loops

• $fe: shifts down all template rows below the current row before inserting the looped data.
• !fe:does not shift anything; the inserted rows overwrite the existing template rows below the current row.
• #fe:works like fe: but loops horizontally (left-to-right).

Image

 {{ img }}

Example

let img = informat.excel.createTemplatePicture({
  type: "file", // Local storage
  content: "path/img.jpg", // Local storage file path
  width: 100, // Width
  height: 100, // Height
});

{{ img }}