Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This page demonstrates how to use the Table Plus macro, which is part of the Advanced Tables for Confluence add-on, to provide view users an option to downloading or exporting (as an attachment) a CSV representation of the table view. By specifying the Allow export parameter on the macro, users will be given 2 icons that can be clicked to download or export the current table view to a CSV file. Download will place the file on the user local system. Export will create an attachment. 

Tip
titleAvailable with version 7.2.0 on Server only

 See Release notes 7.2.


Section


Column

Screenshot

Image RemovedImage Added


Column

Exported CSV

Code Block
titleProduct Revenue.csv
""," Product "," On Plan "," Revenue "
"1"," A ","  ","$325,100"
"2"," D ","  ","$315,850"
"3"," C ","  ","$250,420"
"4"," B ","  ","$98,650"
"5"," E ","  ","$79,010"
"","","","$1,069,030"

 

Message

Image Added


Macro Browser Input

Select this Macro

...

Allow exportselected
Table idProduct Revenue

Auto number on each row

selected

Auto total row

selected

Sort descending

selected

Auto sort column

3

Column types

S,E,I

...

Screenshot

Image RemovedImage Added 


Wiki Markup Input

Code Block
languagetext
linenumberstrue
{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

...

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
titleProduct Revenue.csv
"","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 Macro As Is


Csv
script^Product Revenue.csv


With CSV Macro With A Few Parameters To Make It Look More Like the Original


Csv
outputwiki
footingAugments,
columnTypesI,S,E,C
footing1
script^Product Revenue.csv
augments,,!%3%!

The following parameters were used in the CSV macro shown above:


Select this Macro

Macro NameCSV
Macro Syntax{csv}

Define these Parameters/Values

Output formatwiki
Footing rows1

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_SupportFooter_SupportFooter