...
Auto number on each row | On |
Auto total row | On |
| Allow download and export | On |
| Export file delimiter | , |
Sort descending | On |
Auto sort this column | 3 |
| Column types | S,E,I |
| Table id | Product Revenue |
Screenshot
...
Parameters set in the macro editor
Wiki markup input (Old editor)
| Code Block | ||||
|---|---|---|---|---|
| ||||
{table-plus:allowExport=true|id=Product Revenue|autoNumber=true|autoTotal=true|sortDescending=true|sortColumn=3|columnTypes=S,E,FF"$0,0"}
|| Product || On Plan || Revenue ||
| A | (/) | 325100 |
| D | (/) | 315850 |
| C | (x) | 250420 |
| B | (/) | 98650 |
| E | (x) | 79010 |
{table-plus} |
Exported CSV file
The exported attachment, Product Revenue.csv, can be imported back to a Confluence page using the CSV (Comma Separated Values) macro. This could be used for showing snapshots of tables that have been archived for a historical view. The following is like CSV Table macro with the exported CSV file is added to a CSV (Comma Separated Values) macro as an attachment on this page:
As
...
text
| Code Block | ||
|---|---|---|
| ||
"","Product","On Plan","Revenue" "1","A","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$325,100" "2","D","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$315,850" "3","C","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/error.png","$250,420" "4","B","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$98,650" "5","E","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/error.png","$79,010" "","","","$1,069,030" |
...
As-is
| Csv | ||
|---|---|---|
|
...
With a few parameters to make it look more like the original
| Csv | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
The following parameters were used in the CSV Table macro shown above(Comma Separated Values) macro:
Select this macro
| Macro Namename | Advanced Tables - CSV Table |
| Macro Syntaxsyntax (Old editor) | {csv} |
| Macro syntax (New editor - case insensitive) | /CSV (Comma Separated Values) |
Define these parameters/values
...
| CSV Table settings > Data settings > Output format | wiki | |
|---|---|---|
| Row settings > Header & footer rows > Number of header rows | 1 | |
CSV Table settings > Data format > Augments to data row values | , , !%3%! | |
CSV Table settings > Data format > Augments to footing row values | , , Total | |
CSV Table settings > Data source > Method of locating JSON data (Attachment) > Attachment | Product Location of CSV data | ^Product Revenue.csv |
Column settings > Formatting > Column type (1 2 3 4) | types | I,S,E,C |
Other examples
Visit our full list of product examples for additional inspiration!