David Simpson Apps
Products • Chemistry Toolkit for Confluence • Documentation
Docs

Table from CSV with Rendering Macro

Features

The Table from CSV (with Rendering) macro is an advanced formatting macro for Confluence.

It has the following features:

  • Takes either of the following as input the name of a CSV file which is attached to the current page
  • the URL of a remote CSV file

Display a CSV with a header row as a table, where the first row is always a header row

  • Support for tab separated values (TSV) format
  • Auto detection of the separator – comma ,, tab \t, pipe | , etc

Support for remote files (hosted elsewhere)

Filter/search field for quick access to data

Sort the table by clicking on the header cells

Wrap cell content, or not

Renders the following

  • LaTeX notation to mathematical & chemical equations - where the table header is named LaTeX (with this exact capitalisation)
  • SMILES format to 2D chemical structures - where the table header is named SMILES
  • InChI format to 2D chemical structures - where the table header is named InChI (with this exact capitalisation)
  • URLs and email addresses are hyperlinked
  • Links in markup language are hyperlinked e.g. [David Simpson Apps website](https://dsapps.dev) are rendered in HTML

Horizontal scrollbars for large content with shaded indicators to suggest you can scroll horizontally

Tables can be connected to Charts using the Manage connected data context menu item:

Confluence editor showing the Manage connected data context menu for connecting a table to Charts

How to use

In the Confluence editor, type /table from csv and select Table from CSV (with Rendering).

Confluence editor showing /table from csv macro selection

The macro properties panel will appear.

Table from CSV with Rendering macro properties panel

In the Attachment Filename, either add the name of an attached CSV file, or the URL or a remote CSV file. The attachment must be for an attachment on the same page.

You can use the following example URL to see how the macro works:

https://gist.githubusercontent.com/dvdsmpsn/cfa79f7ef8c7924281af4650af5ac1ea/raw/5f3613837e8435225bd162d5a7a76d4ac668eabf/example-for-table-from-csv-with-rendering.csv

Add the width and height for any rendered SMILES structures, or leave for the default size.

Choose whether or not to wrap the cell content.

Save the Confluence page and the table will be rendered.

Simple example

Table from CSV with Rendering macro simple example output showing a rendered table

Larger dataset with “no-wrap” on cells

The table scrolls sideways, with shading on left or right to show that there is more content out ovf view

Note that these examples are just sample data and not real people.

Table from CSV with Rendering macro showing a larger dataset with no-wrap cells and horizontal scrolling

sample smiles.csv