Versions Compared

Key

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

...

The “Data Tables CSV (remote)” macro uses CSV remote data as data source. After inserting the macro, the URL to load the CSV data and all other CSV and table settings options can be defined in the macro settings.

...

  • 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 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 state saving and restoring.

Macro “Data Tables Attachments”

The “Data Tables CSV Attachments” uses the list of attached files to that Confluence table as data source. After inserting the macro, the table options can be defined in the macro settings.

...

The macro supports the following options:

  • Enable paging: Check to enable the paging functionality.

  • Enable searching: Check to enable the searching functionality.

  • 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.

  • 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 state saving and restoring.