...
| Tip | ||
|---|---|---|
| ||
| Section | ||||
|---|---|---|---|---|
|
Macro Browser Input
Select this Macro
| Macro Name | Table Plus |
| Macro Syntax | {table-plus} |
Define these Parameters/Values
| Allow export | selected |
| Table id | Product Revenue |
Auto number on each row | selected |
Auto total row | selected |
Sort descending | selected |
Auto sort column | 3 |
Column types | S,E,I |
Screenshot
Wiki Markup Input
| 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
The attachment Product Revenue.csv exported above, can be imported back to a Confluence page using the CSV Macro. This could be used for showing snapshots of tables that have been archived for a historical view. The following is like CSV macros with the 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"Exported Product Revenue Attachment Reference in CSV macro - RawCsv | | |
| footingAugments | , | footing | 1
With CSV Macro As Is
| Csv | ||
|---|---|---|
| Exported Product Revenue Attachment Reference in CSV macro - Parameterized||
With CSV Macro With A Few Parameters To Make It Look More Like the Original
| Csv | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
The following parameters were used in the CSV macro shown above:
Select this Macro
| Macro Name |
| CSV | |
| Macro Syntax | { |
| csv} |
Define these Parameters/Values
| Output format |
|---|
| wiki |
Auto number on each row
selected
Auto total row
selected
Sort descending
selected
Auto sort column
3
Column types
S,E,I
Screenshot
Wiki Markup Input
| 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} |
Example Result
...
| Footing rows | 1 |
|---|---|
Augments to data row values | , , !%3%! |
Augments to footing row values | , , Total |
Location of data | ^Product Revenue.csv |
Column types | I,S,E,C |
Other Examples
Visit our full list of product examples for additional inspiration!Include Page