Versions Compared

Old Version 2

changes.mady.by.user Bob Swift

Saved on

compared with

New Version Current

changes.mady.by.user Bob Swift

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
Csv
rowStylesfont-size: 1.5em; font-style:italic;,, background:lightyellow, background:lightblue,
autoNumbertrue
        Month, Max, Min, Avg
        January,  25.5,  6.3, 15.9
        February, 32.4, 12.8, 22.6
        March,    44.6, 24.5, 34.6
        April,    59.7, 37.1, 48.4
        May,      72.5, 48.7, 60.6
        June,     81.3, 57.9, 69.6
        July,     85.2, 62.8, 74.0
        August,   82.5, 60.7, 71.6
        September,73.7, 51.7, 62.7
        October,  61.1, 40.1, 50.6
        November, 43.6, 27.4, 35.5
        December, 29.9, 13.6, 21.8
Column
No Format
titleWiki markup
{csv:autoNumber=true|rowStyles=font-size: 1.5em; font-style:italic;,, background:lightyellow, background:lightblue,}

        Month, Max, Min, Avg
        January,  25.5,  6.3, 15.9
        February, 32.4, 12.8, 22.6
        March,    44.6, 24.5, 34.6
        April,    59.7, 37.1, 48.4
        May,      72.5, 48.7, 60.6
        June,     81.3, 57.9, 69.6
        July,     85.2, 62.8, 74.0
        August,   82.5, 60.7, 71.6
        September,73.7, 51.7, 62.7
        October,  61.1, 40.1, 50.6
        November, 43.6, 27.4, 35.5
        December, 29.9, 13.6, 21.8
        
{csv}

See the rowStyles parameter on Common table capabilities:  A comma separated list of styles. Each style is made up of one or more properties. The first is applied to all heading rows determined by the heading parameter. The remaining styles are applied to the remaining rows in order with repetition as necessary. Example: , background:lightyellow;, background:lightblue;

 

...


Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

Overview

This page outlines an example demonstrating how to use the CSV macro, which is part of the Advanced Tables for Confluence add-on, to transform CSV data into an attractive Wiki table.

Macro Browser Input

Select this Macro

Macro NameCSV (Comma Separated Values)
Macro Syntax{csv}

Define these Parameters/Values

Output format wiki
Heading rows 1
Footing rows 0
Delimiter that separates columns whitespace
Table width 400px
Table border width 15

Screenshot

Image Added

 

Wiki Markup Input

Code Block
languagetext
linenumberstrue
{csv:output=wiki|width=400px|border=15|delimiter=whitespace}
Month Max Min Average
January 25.5 *6.3* 15.9
February 32.4 12.8 22.6
March 44.6 24.5 34.6
April 59.7 37.1 48.4
May 72.5 48.7 60.6
June 81.3 57.9 69.6
July 85.2 62.8 74
August 82.5 60.7 71.6
September 73.7 51.7 62.7
October 61.1 40.1 50.6
November 43.6 27.4 35.5
December 29.9 13.6 21.8
{csv}

 

Example Result

Csv
border15
outputwiki
highlightColor#fac471
delimiterwhitespace
width400px
Month Max Min Average
January 25.5 *6.3* 15.9
February 32.4 12.8 22.6
March 44.6 24.5 34.6
April 59.7 37.1 48.4
May 72.5 48.7 60.6
June 81.3 57.9 69.6
July 85.2 62.8 74
August 82.5 60.7 71.6
September 73.7 51.7 62.7
October 61.1 40.1 50.6
November 43.6 27.4 35.5
December 29.9 13.6 21.8

 

Other Examples

Visit our full list of product examples for additional inspiration!