...
To make use of one of the macros click the “Insert” / “+” Button in the edit mode, select one of the macros and follow the macro specific instructions below.
All macros support the table state saving and restoring feature which enabled by default (see macro option “Disable state saving“ below to disable this functionality). The table state information is stored for 7 days in the client’s browser and is used to restore the user specific table state after a page reload. Please note that for this functionality requires “third-party cookies” to be enabled in the client’s browser (see our FAQ page for more details).
Macro “Data Tables”
The “Data Tables” macro uses regular Confluence tables as data source. After inserting the macro, add a regular Confluence table as macro body and change the macro settings appropriately.
...
Enable paging: Check to enable the paging functionality.
Enable searching: Check to enable the searching functionality.
Enable column selector: Check to enable the a button that allows to toggle visibility of individual columns.
Enable copy to clipboard: Check to enable a button that copies the table data to the clipboard.
Enable Excel export: Check to enable a button that exports the table data as .xlsx file.
Enable CSV export: Check to enable a button that exports the table data as .csv file.
Enable PDF export: Check to enable a button that exports the table data as .pdf file.
Enable printing: Check to enable a “print” button.
Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.
Footer row: Comma separated functions (“min”, “max”, “avg”, “sum”) to be used in the footer row.
Data locale: Define the locale that should be used to parse numbers.
Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.
Detail column: Number of the column that contains the information that will be rendered as expandable/collapsible detail row.
Show information: Check to show dataset information such as number of records.
Disable state saving: Check to disable automatic table state saving and restoring.
...
CSV header row: Check to use the first row as column header
CSV quote: Define the character that is used as CSV quote, leave empty if no quote us used.
CSV delimiter: Define the character that is used as CSV delimiter.
Enable paging: Check to enable the paging functionality.
Enable searching: Check to enable the searching functionality.
Enable column selector: Check to enable the a button that allows to toggle visibility of individual columns.
Enable copy to clipboard: Check to enable a button that copies the table data to the clipboard.
Enable Excel export: Check to enable a button that exports the table data as .xlsx file.
Enable CSV export: Check to enable a button that exports the table data as .csv file.
Enable PDF export: Check to enable a button that exports the table data as .pdf file.
Enable printing: Check to enable a “print” button.
Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.
Footer row: Comma separated functions (“min”, “max”, “avg”, “sum”) to be used in the footer row.
Data locale: Define the locale that should be used to parse numbers.
Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.
Show information: Check to show dataset information such as number of records.
Disable state saving: Check to disable automatic table state saving and restoring.
...
URL: URL to load the remote CSV data from
CSV header row: Check to use the first row as column header
CSV quote: Define the character that is used as CSV quote, leave empty if no quote us used.
CSV delimiter: Define the character that is used as CSV delimiter.
Enable paging: Check to enable the paging functionality.
Enable searching: Check to enable the searching functionality.
Enable column selector: Check to enable the a button that allows to toggle visibility of individual columns.
Enable copy to clipboard: Check to enable a button that copies the table data to the clipboard.
Enable Excel export: Check to enable a button that exports the table data as .xlsx file.
Enable CSV export: Check to enable a button that exports the table data as .csv file.
Enable PDF export: Check to enable a button that exports the table data as .pdf file.
Enable printing: Check to enable a “print” button.
Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.
Footer row: Comma separated functions (“min”, “max”, “avg”, “sum”) to be used in the footer row.
Data locale: Define the locale that should be used to parse numbers.
Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.
Show information: Check to show dataset information such as number of records.
Disable state saving: Check to disable automatic table state saving and restoring.
...
Enable paging: Check to enable the paging functionality.
Enable searching: Check to enable the searching functionality.
Enable column selector: Check to enable the a button that allows to toggle visibility of individual columns.
Enable copy to clipboard: Check to enable a button that copies the table data to the clipboard.
Enable Excel export: Check to enable a button that exports the table data as .xlsx file.
Enable CSV export: Check to enable a button that exports the table data as .csv file.
Enable PDF export: Check to enable a button that exports the table data as .pdf file.
Enable printing: Check to enable a “print” button.
Show columns: Select the columns to be included in the table.
Group column: (Optional) column to group the data.
Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.
Show information: Check to show dataset information such as number of records.
Disable state saving: Check to disable automatic table state saving and restoring.