Allow Export of Table View

On this page

Overview

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. 

Available with version 7.2.0 on Server only

Screenshot

Message

Macro Browser Input

Select this Macro

Macro NameTable Plus
Macro Syntax{table-plus}

Define these Parameters/Values

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


Wiki Markup Input

{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


Product 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



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


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!

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.