| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
...
| Table settings > Formatting > Table id | Product Revenue |
| Table settings > Advanced settings > Enable download and export as attachment | On |
Column settings > Formatting > Column type (1 ,2 ,3) | S ,E ,I |
Column settings > Numbering & Totaling > Insert auto number column | On |
Column settings > Numbering & Totaling > Auto total numeric columns | On |
Column settings > Sorting > Automatically sort in descending order | On |
Column settings > Sorting > Automatically sort by this column | 3 |
Screenshot
Wiki Markup Input
...
The attachment Product Revenue.csv exported above, can be imported back to a Confluence page using the CSV Table Macro. This could be used for showing snapshots of tables that have been archived for a historical view. The following is like CSV macros Table macro with the attachment on this page.
...
| 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" |
With CSV Table Macro As Is
| Csv | ||
|---|---|---|
| ||
With CSV Table Macro 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:
Select this Macro
| Macro Name | CSV Table |
| Macro Syntax | {csv} |
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 Revenue.csv |
Column settings > Formatting > Column type (1, 2, 3, 4) | I, S, E, C |
Other Examples
Visit our full list of product examples for additional inspiration!
...