CSV to html – include tables in column
With the use of attribute table_in_cell_cols you are able to include a table for each row from specificed columns. These columns can be in column-number (e.g. 2,4) and colum-name (e.g. 2011,2013), and interval of several column numbers (e.g. 2-4).
Original
| Sweden | 1.6% | 2.2% | 3.2% | 4.5% | 6.9% |
| Norway | -6.6% | 1.2% | 1.4% | 1.9% | 2.0% |
| Finland | -16.6% | -14.2% | 10.2% | 11.0% | 13.2% |
| Iceland | 6.6% | 6.2% | 7.2% | 11.0% | 16.2% |
| Denmark | -2.6% | 0% | 2.6% | 2.9% | 2.11% |
With table_in_cell_cols
Shortcode
[csvtohtml_create source_type="visualizer_plugin" path="csvfiles" source_files="sweden;norway;finland;iceland;denmark" table_in_cell_cols="2,4"]
| Sweden | 1.6% | 2.2% | 3.2% | 4.5% | 6.9% | |
| Norway | -6.6% | 1.2% | 1.4% | 1.9% | 2.0% | |
| Finland | -16.6% | -14.2% | 10.2% | 11.0% | 13.2% | |
| Iceland | 6.6% | 6.2% | 7.2% | 11.0% | 16.2% | |
| Denmark | -2.6% | 0% | 2.6% | 2.9% | 2.11% | |
The title ”More data” is shown as default, but you could define you own title (table_in_cell_header) for this included table like this:
Shortcode
[csvtohtml_create source_type="visualizer_plugin" path="csvfiles" source_files="sweden;norway;finland;iceland;denmark" table_in_cell_header="Geographical data" table_in_cell_cols="2,4"
]
| Sweden | 1.6% | 2.2% | 3.2% | 4.5% | 6.9% | |
| Norway | -6.6% | 1.2% | 1.4% | 1.9% | 2.0% | |
| Finland | -16.6% | -14.2% | 10.2% | 11.0% | 13.2% | |
| Iceland | 6.6% | 6.2% | 7.2% | 11.0% | 16.2% | |
| Denmark | -2.6% | 0% | 2.6% | 2.9% | 2.11% | |
It’s possible to add a specific wrapper-class for each table (table_in_cell_wrapperclass) created so it might be easier to customzie javascript/css using that specific element. (Could be used for example hover on and off)
Shortcode
[csvtohtml_create source_type="visualizer_plugin" path="csvfiles" source_files="sweden;norway;finland;iceland;denmark" table_in_cell_header="Geographical data table_in_cell_cols="2,4" table_in_cell_wrapperclass="hovertable"]
| Sweden | 1.6% | 2.2% | 3.2% | 4.5% | 6.9% | |
| Norway | -6.6% | 1.2% | 1.4% | 1.9% | 2.0% | |
| Finland | -16.6% | -14.2% | 10.2% | 11.0% | 13.2% | |
| Iceland | 6.6% | 6.2% | 7.2% | 11.0% | 16.2% | |
| Denmark | -2.6% | 0% | 2.6% | 2.9% | 2.11% | |
