Tables on wiki pages

You can use wiki markup to organize information in tables on a wiki page.

Note: These tools are for use only when you are editing a wiki page in text mode. If you try to use them in WYSIWYG mode, they are displayed just the way you typed them in, which is not what you want.
Syntax Effect Details
[{Table <table-parameters>
                    
|| Table Header Example || More... 
| Table Data Example | More...
}]
Inserts a table on the wiki page. See this page for the markup for table elements.
  • rowNumber: <integer> Row number starts counting at this value; default = 0 (used in conjunction with '#' syntax)
  • style: <css-style> Add formatting to the table, e.g. style:'border=2px solid black;'
  • dataStyle: <css-style> Format all data cells (prefixed by single pipe signs '|')
  • headerStyle: <css-style> Format all header cells (prefixed by double pipe signs '||')
  • evenRowStyle: <css-style> Format the even rows, e.g. evenRowStyle='background: #ffff00;'
  • oddRowStyle: <css-style> Format the odd rows, e.g. oddRowStyle='color: red;'
||head1||head2
Creates a table column with header text "head1" in the first cell and "head2" in the second cell.
|col1|col2
Creates a table row containing the text "col1" in the first cell and "col2" in the second cell.
|<
Collapses a cell with the previous cell so it spans multiple columns. http://www.ecyrd.com/JSPWiki/wiki/TablePlugin
||<
Collapses a header cell with the previous header cell so it spans multiple columns. http://www.ecyrd.com/JSPWiki/wiki/TablePlugin
|^ 
Collapses a cell with the cell above so that it spans multiple rows. http://www.ecyrd.com/JSPWiki/wiki/TablePlugin
||^ Collapses a header cell with the header cell above so that it spans multiple rows. http://www.ecyrd.com/JSPWiki/wiki/TablePlugin
|( <css-style> ) 
Inside a table cell, adds specific formatting to a cell. http://www.ecyrd.com/JSPWiki/wiki/TablePlugin
#
Inside a table cell, displays the current row number with auto row numbering. http://www.ecyrd.com/JSPWiki/wiki/TablePlugin
[{INSERT ExcelToHTMLPlugin 
src='WikiPage\somesheet.xls'}] 
or 
[{INSERT ExcelToHTMLPlugin 
border='1' 
src='\\the_server\somesheet.xls'}] 
Reads a Microsoft Excel file that is attached to a wiki page, and displays it as an HTML table.

Parameters:

  • src: If the Excel file is attached to the current wiki page, this is the attachment file name. If it is attached to some other wiki page, this is the URL of the attachment.
  • srcsheet: Sheet name
  • height: height attribute for the html table
  • width: width attribute for the html table
  • border: border attribute for the html table
  • cellpadding: cellpadding attribute for the html table
  • cellspacing: cellspacing attribute for the html table
  • background: background attribute for the html table. Attachment file name is accepted as value
  • backgroundcolor: backgroundcolor attribute for the html table
  • keepformat: Formating specified in the excel sheet is applied for the html table. Note: The complete formating from excel sheet is not applied to the html table, for example, font, font size, etc are not applied and background color, foreground color, etc are applied. yes/no is accepted as value
  • headercolor: Foreground color for the header (eg: #dcdcdc)
  • headerbackgroundcolor: Background color for the header (eg: #adadad)
  • evenrowcolor: Foreground color for the even rows (eg: #adadad)
  • evenrowbackgroundcolor: Background color for the even rows (eg: #adadad)
  • oddrowcolor: Foreground color for the odd rows (eg: #adadad)
  • oddrowbackgroundcolor: Background color for the odd rows (eg: #adadad)
  • tableclass: Style class name for the HTML table
  • headerclass: Style class name for header
  • evenrowclass: Style class name for the even rows
  • oddrowclass: Style class name for the even rows
  • stylesheet: Stylesheet for the table. Attachment file name is accepted as value

See http://www.ecyrd.com/JSPWiki/wiki/ExcelToHTMLPlugin

[{TableOfContents }]\\
                    
Creates a table of contents consisting of the header text on the page.