Notes

Changes

In New v2.30.5, the output_formatContent callback data parameter now includes the column index and parsed value for the cell.
In v2.29.0, updated internal function parameters to make it easier to output all table data from the server without modifying the current table, or changing the pager size or page. See the modified output_callback code in the Output all data section.
In v2.28.5, triggering of the "outputTable" event multiple times in rapid succession (within 600 milliseconds) will now prevent the opening of multiple popups or cause mutliple downloads.
In v2.28.4,
- Added output_includeHeader option.
- Added output_savePlugin option.
- Prevent javascript error while attempting to update an already open popup window.
In v2.27.0, the output_callback now includes a url parameter.

Older Notes

Requirements

This widget will only work in tablesorter version 2.8+ and jQuery version 1.7+.
~~To download a file with the set filename and extension, the server's Content-disposition needs to be set~~
This widget now uses a method available in modern browsers (IE10+) to download files without the need for server side modifications
Support in older browsers (IE9 and older) have not been throughly tested.

Features & Usage

This widget can output the table data to:
- JSON
- Array of arrays
- Text with any separator (comma, tab, etc).
Rowspan and colspan are supported by this widget. Please take note of additional information in the "Rowspan and colspan" section below.
Working with Excel:
- To save a file for Excel
  - Set the separator to a comma (,).
  - Save the file with a csv extension, then load it into Excel.
  - Or, save the file with a xls extension; but when loading the file in Excel, you will likely see a message stating that the file is corrupt. Continue loading and you will see the expected data placed into each cell.
  - Note including a BOM in the output_encoding option is no longer required!
- To copy the data into Excel
  - Set the separator as a tab (\t).
  - Open the data in a popup window, then copy the contents to the clipboard.
  - Paste from the clipboard directly into a cell in Excel.
This demo uses Bootstrap to create the download button dropdown for each table allowing the user to choose the settings
- Using Bootstrap started out relatively difficult... any click inside would close the dropdown.
- There are likely better alternatives as the download button and popup are all completely customizable.
- The download dropdown code is overly complicated because it is set up for two tables & allows modifying almost all of the options.
- The only thing needed to output the table code (download or open a popup) is to trigger the following event after all of your widget options are set as desired:
```
$table.trigger('outputTable');
```

Known Issues

Some versions of Safari do not fully support direct downloading, nor will you be able to save the file with the set file name; for more details please refer to this issue.

Credit

This widget uses heavily modified code from:
- HTML Table to CSV (License unknown)
- Download-File-JS (Apache v2.0)
- Download demo from ebidel/html5demos
- FileSaver.js (MIT)

Basic Setup

Using the default settings of this widget will:

Output csv to a popup window.
Only include the last header row (if there are more than one rows).
Only include filtered rows (all rows will be included, even if the filter widget isn't being used).
Will only output the table cell text (ignoring any HTML).

Of course, all of the above behavior can be modified using the options.
This is an example of how to setup a table using only the default settings:

HTML

<button class="download">Get CSV</button>
<table class="tablesorter">
    <!-- .... -->
</table>

Script

$(function () {
    var $table = $('table');

    $('.download').click(function() {
        // tell the output widget do it's thing
        $table.trigger('outputTable');
    });

    $table.tablesorter({
        theme: 'blue',
        widgets: ['zebra', 'output']
    });
});

Modification of the .htaccess is no longer required

.htaccess

The Content-disposition headers may need to be set in order to make downloads work properly in IE. So .htaccess can look like:

<FilesMatch "\.(?i:csv|txt)$">
      ForceType application/octet-stream
      Header set Content-Disposition attachment
  </FilesMatch>

Setup Example (php)

Basic Example

Thanks to TheSin- for sharing this setup which includes the necessary php to allow file download with the proper filename and extension (original Gist)

	<?php
	// Make sure we dont' time out, this is optional
	@set_time_limit(10000);

	$filename = "output.csv";
	if (!empty($_POST['filename']) )
	$filename = $_POST['filename'] ;

	// NO CACHE
	header("Pragma: public");
	header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

	// Set headers (force save as dialog)
	header("Content-type: text/csv; charset=utf-8");
	header("Content-disposition: attachment; filename='" . $filename . "'");

	echo $_POST['data'];
	?>

view raw csv.php hosted with ❤ by GitHub

	<form id="csvForm" method="post" action="csv.php" style="display: none;">
	<input type="hidden" name="filename" />
	<input type="hidden" name="data" />
	</form>
	<h4>Table showing filter & pager support</h4>
	<div class="btn-group">
	<button type="button" class="btn btn-default reset">Reset</button> <!-- targeted by the "filter_reset" option -->

	<!-- Split button -->
	<div class="btn-group">
	<button type="button" class="btn btn-default download">Download</button>
	<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
	<span class="caret"></span>
	<span class="sr-only">Toggle Dropdown</span>
	</button>
	<ul class="dropdown-menu" role="menu">
	<li><h5><strong>Output options</strong></h5></li>
	<li>
	<label>Separator: <input class="output-separator-input" type="text" size="2" value=","></label>
	<button type="button" class="output-separator btn btn-default btn-xs active" title="comma">,</button>
	<button type="button" class="output-separator btn btn-default btn-xs" title="semi-colon">;</button>
	<button type="button" class="output-separator btn btn-default btn-xs" title="tab"> </button>
	<button type="button" class="output-separator btn btn-default btn-xs" title="space"> </button>
	<button type="button" class="output-separator btn btn-default btn-xs" title="output JSON">json</button>
	<button type="button" class="output-separator btn btn-default btn-xs" title="output Array (see note)">array</button>
	</li>
	<li>
	<div class="btn-group output-filter-all" data-toggle="buttons" title="Output only filtered, visible or all rows">
	<label class="btn btn-default btn-sm active">
	<input type="radio" name="getrows1" class="output-filter" checked="checked"> Filtered
	</label>
	<label class="btn btn-default btn-sm">
	<input type="radio" name="getrows1" class="output-visible"> Visible
	</label>
	<label class="btn btn-default btn-sm">
	<input type="radio" name="getrows1" class="output-all"> All
	</label>
	</div>
	</li>
	<li class="divider"></li>
	<li>
	<label>Replace quotes: <input class="output-replacequotes" type="text" size="2" value="'"></label>
	<button type="button" class="output-quotes btn btn-default btn-xs active" title="single quote">'</button>
	<button type="button" class="output-quotes btn btn-default btn-xs" title="left double quote">“</button>
	<button type="button" class="output-quotes btn btn-default btn-xs" title="escaped quote">\"</button>
	</li>
	<li><label title="Remove extra white space from each cell">Trim spaces: <input class="output-trim" type="checkbox" checked=""></label></li>
	<li><label title="Include HTML from cells in output">Include HTML: <input class="output-html" type="checkbox"></label></li>
	<li><label title="Wrap all values in quotes">Wrap in Quotes: <input class="output-wrap" type="checkbox"></label></li>
	</ul>
	</div>
	</div>

	<div class="ts-pager form-horizontal">
	<button type="button" class="btn btn-default btn-sm first"><i class="icon-step-backward glyphicon glyphicon-step-backward"></i></button>
	<button type="button" class="btn btn-default btn-sm prev"><i class="icon-arrow-left glyphicon glyphicon-backward"></i></button>
	<span class="pagedisplay"></span> <!-- this can be any element, including an input -->
	<button type="button" class="btn btn-default btn-sm next"><i class="icon-arrow-right glyphicon glyphicon-forward"></i></button>
	<button type="button" class="btn btn-default btn-sm last"><i class="icon-step-forward glyphicon glyphicon-step-forward"></i></button>
	<select class="pagesize form-control btn-sm" title="Select page size">
	<option selected="selected" value="5">5</option>
	<option value="10">10</option>
	</select>
	<select class="gotoPage form-control btn-sm" title="Select page number"></select>
	</div>

	<table id="table" class="tablesorter">
	<thead>
	<tr>
	<th>Rank</th>
	<th data-name="First">First Name</th>
	<th data-name="Last">Last Name</th>
	<th>Age</th>
	<th>Total</th>
	<th>Discount</th>
	<th>Date</th>
	</tr>
	</thead>
	<tbody>
	<tr><td>1</td><td>Philip Aaron Wong</td><td>Johnson Sr Esq</td><td>25</td><td>$5.95</td><td>22%</td><td>Jun 26, 2004 7:22 AM</td></tr>
	<tr><td>11</td><td>Aaron</td><td>"doc" Hibert</td><td>12</td><td>$2.99</td><td>5%</td><td>Aug 21, 2009 12:21 PM</td></tr>
	<tr><td>12</td><td>Brandon Clark</td><td>Henry Jr</td><td>51</td><td>$42.29</td><td>18%</td><td>Oct 13, 2000 1:15 PM</td></tr>
	<tr><td>111</td><td>Peter</td><td>Parker</td><td>28</td><td>$9.99</td><td>20%</td><td>Jul 6, 2006 8:14 AM</td></tr>
	<tr><td>21</td><td><span class="red">John</span></td><td> "Robin"<br> Hood </td><td>33</td><td>$19.99</td><td>25%</td><td>Dec 10, 2002 5:14 AM</td></tr>
	<tr><td>013</td><td>Clark</td><td>"Old man" Kent Sr.</td><td>18</td><td>$15.89</td><td>44%</td><td>Jan 12, 2003 11:14 AM</td></tr>
	<tr><td>005</td><td>Bruce</td><td>Almighty <span class="red">Esq</span></td><td>45</td><td>$153.19</td><td>44%</td><td>Jan 18, 2021 9:12 AM</td></tr>
	<tr><td>10</td><td>Alex</td><td>Dumass</td><td>13</td><td>$5.29</td><td>4%</td><td>Jan 8, 2012 5:11 PM</td></tr>
	<tr><td>16</td><td>Jim</td><td>"Jimmy" Franco</td><td>24</td><td><span class="red">-$14.19</span></td><td>24%</td><td>Jan 14, 2004 11:23 AM</td></tr>
	<tr><td>166</td><td>Bruce Lee</td><td>Evans</td><td>22</td><td>$13.19</td><td>11%</td><td>Jan 18, 2007 9:12 AM</td></tr>
	<tr><td>100</td><td>Brenda Dexter</td><td>McMasters</td><td>18</td><td>$55.20</td><td>15%</td><td>Feb 12, 2010 7:23 PM</td></tr>
	<tr><td>55</td><td>Dennis</td><td><span class="red">"Charley"</span> Bronson</td><td>65</td><td>$123.00</td><td>32%</td><td>Jan 20, 2001 1:12 PM</td></tr>
	<tr><td>9</td><td>Martha</td><td>delFuego</td><td>25</td><td>$22.09</td><td>12%</td><td>Jun 11, 2011 10:55 AM</td></tr>
	</tbody>
	</table>

view raw example.html hosted with ❤ by GitHub

	$(function() {

	// call the tablesorter plugin
	$('#table').tablesorter({
	theme: 'bootstrap',
	widthFixed : true,
	headerTemplate : '{content} {icon}',
	widgets: ["zebra", "filter", "uitheme", "output"],
	widgetOptions : {
	output_separator : ',', // ',' 'json', 'array' or separator (e.g. ',')
	output_dataAttrib : 'data-name', // data-attribute containing alternate cell text
	output_headerRows : true, // output all header rows (multiple rows)
	output_delivery : 'd', // (p)opup, (d)ownload
	output_saveRows : 'f', // (a)ll, (f)iltered or (v)isible
	output_replaceQuote : '\u201c;', // change quote to left double quote
	output_includeHTML : true, // output includes all cell HTML (except the header cells)
	output_trimSpaces : false, // remove extra white-space characters from beginning & end
	output_wrapQuotes : false, // wrap every cell output in quotes
	output_saveFileName : 'output.csv',
	// callback executed when processing completes
	// return true to continue download/output
	// return false to stop delivery & do something else with the data
	output_callback : function(c, data) {
	$('#csvForm input[name=filename]').val($('.output-filename').val());
	$('#csvForm input[name=data]').val(data);
	$('#csvForm').submit();

	return false;
	},
	output_encoding : ''

	}
	});

	$('#table').tablesorterPager({
	container: $(".ts-pager"),
	output: '{startRow} - {endRow} / {filteredRows} ({totalRows})',
	size: 5
	});

	$('.dropdown-toggle').click(function(e){
	// this is needed because clicking inside the dropdown will close
	// the menu with only bootstrap controlling it.
	$('.dropdown-menu').toggle();
	return false;
	});
	// make separator & replace quotes buttons update the value
	$('.output-separator').click(function(){
	$('.output-separator').removeClass('active');
	var txt = $(this).addClass('active').html()
	$('.output-separator-input').val( txt );
	$('.output-filename').val(function(i, v){
	// change filename extension based on separator
	var filetype = (txt === 'json' \|\| txt === 'array') ? 'js' :
	txt === ',' ? 'csv' : 'txt';
	return v.replace(/\.\w+$/, '.' + filetype);
	});
	return false;
	});
	$('.output-quotes').click(function(){
	$('.output-quotes').removeClass('active');
	$('.output-replacequotes').val( $(this).addClass('active').text() );
	return false;
	});

	// clicking the download button; all you really need is to
	// trigger an "output" event on the table
	$('.download').click(function(){
	var $table = $('#table'),
	wo = $table[0].config.widgetOptions,
	saved = $('.output-filter-all :checked').attr('class');
	wo.output_separator = $('.output-separator-input').val();
	wo.output_saveRows = saved === "output-filter" ? 'f' : saved === 'output-visible' ? 'v' : 'a';
	wo.output_replaceQuote = $('.output-replacequotes').val();
	wo.output_trimSpaces = $('.output-trim').is(':checked');
	wo.output_includeHTML = $('.output-html').is(':checked');
	wo.output_wrapQuotes = $('.output-wrap').is(':checked');
	wo.output_headerRows = $('.output-headers').is(':checked');
	wo.output_saveFileName = $('.output-filename').val();
	$table.trigger('outputTable');
	return false;
	});

	// add tooltip
	$('.dropdown-menu [title]').tipsy({ gravity: 's' });

	});

	});

view raw script.js hosted with ❤ by GitHub

Output all data

This code example can be used in v2.29.0+ to load in all data to output it directly. It will not manipulate the data currently in the table.

	output_callback : function(c, data, url) {
	var filename = $('#A3opts .output-filename').val();
	var newURL = url.replace(/page=[0-9]+/, 'page=0').replace(/size=[0-9]+/, 'size=10000000');
	if (c.originalSettings.widgetOptions.output_saveFileName == 'dynamic')
	filename = $('" . $this->table . "').find('caption').text().replace(/\s/g, '_') + '.csv';
	$('#csvForm #filename', top.$('#toolbar').contents()).val(filename);

	// remove filters for all rows
	if (c.widgetOptions.output_saveRows == 'a')
	newURL = newURL.replace(/&fcol(\[[0-9]+\])?=.+/g, '') + '&fcol';

	$.ajax({
	url: newURL
	}).done(function(data) {
	if (!data) {
	alert('Request had too much data, try to filter out some results and only export visible rows');
	console.log('Ajax must have timed out, results too large!');
	return false;
	}

	try {
	data = $.parseJSON(data);
	} catch(e) {
	alert('Something went wrong!');
	console.log('Ajax did not return proper JSON');
	console.log(e);
	return false;
	}

	var rows = c.widgetOptions.pager_ajaxProcessing(data, c.table);
	data = $.tablesorter.output.process(c, c.widgetOptions, rows['rows'], true);
	$('#csvForm #data', top.$('#toolbar').contents()).val(data);
	setTimeout(function() {
	$('#csvForm', top.$('#toolbar').contents()).submit();
	setTimeout(function() {
	$('#csvForm #filename', top.$('#toolbar').contents()).val('');
	$('#csvForm #data', top.$('#toolbar').contents()).val('');
	}, 250);
	}, 250);
	});
	} else {
	$('#csvForm #data', top.$('#toolbar').contents()).val(data);
	setTimeout(function() {
	$('#csvForm', top.$('#toolbar').contents()).submit();
	setTimeout(function() {
	$('#csvForm #filename', top.$('#toolbar').contents()).val('');
	$('#csvForm #data', top.$('#toolbar').contents()).val('');
	}, 250);
	}, 250);
	}

	return false;
	}

view raw output_callback.param.js hosted with ❤ by GitHub

Rowspan and colspan

Options

Output widget default options (added inside of tablesorter `widgetOptions`)

TIP! Click on the link in the option column to reveal full details (or toggle|show|hide all) or double click to update the browser location.

Option	Default	Description
output_separator	`','`	This option allows you to set the output as JSON, Array, or change the separator between cell data with text output: When the output is created, and it this option doesn't match either `"json"` or `"array"`, each block of table cell data will be separated by this setting. This is the result with this option set to `","` and with the table filtered with Rank : Rank,First,Last,Age,Total,Discount,Date 111,Peter,Parker,28,$9.99,20%,"Jul 6, 2006 8:14 AM" 166,Bruce Lee,Evans,22,$13.19,11%,"Jan 18, 2007 9:12 AM" When this option is set to `"array"`, this will be the resulting output: [ [ "Rank", "First", "Last", "Age", "Total", "Discount", "Date" ], [ "111", "Peter", "Parker", "28", "$9.99", "20%", "Jul 6, 2006 8:14 AM" ], [ "166", "Bruce Lee", "Evans", "22", "$13.19", "11%", "Jan 18, 2007 9:12 AM" ], ] Note this requires `JSON.stringify`, or the result will be a flattened array. And when this option is set to `"json"`, the resulting output will be a valid JSON format: [ { "Rank" : "111", "First": "Peter", "Last": "Parker", "Age": "28", "Total": "$9.99", "Discount": "20%", "Date": "Jul 6, 2006 8:14 AM" }, { "Rank": "166", "First": "Bruce Lee", "Last": "Evans", "Age": "22", "Total": "$13.19", "Discount": "11%", "Date": "Jan 18, 2007 9:12 AM" } ] Note this also requires `JSON.stringify`, or the result will show `[ [object Object], ... ]` in the output.
output_ignoreColumns	`[ ]`	Add the zero-based column index to this array to ignore specific columns (v2.17.0) For example, to use this option to hide the first column, set it as follows: output_ignoreColumns : [ 0 ] Note This option will work properly with tables that contain rowspans & colspans.
output_hiddenColumns	`false`	Include hidden columns (using `display: none`) in the output (v2.22.0).
output_includeFooter	`false`	Change this option to `true` to include the `<tfoot>` rows in the output (v2.21.0)
output_includeHeader	`true`	Change this option to `false` to not include any rows from the `<thead>` in the output (v2.28.4)
output_headerRows	`false`	Setting this option to `true` will include all header rows while processing a JSON output. If this option is set to `false`, only the last row of the table header will be used as a key names for the tbody values; this does assume that the last table row in the header contains all of the header cell names & does not contain any `colspan`.
output_dataAttrib	`'data-name'`	This option allows you to override any table cell (`thead` or `tbody`) text with the contents of this data-attribute (v2.22.2) In the below example, the header text is obtained from this set data-attribute. If the data-attribute doesn't exist, then the header name is obtained from the actual header text. The data-attribute can be an empty string (v2.22.2). <thead> <tr> <th>Rank</th> <th data-name="First">First Name</th> <th data-name="Last">Last Name</th> <th>Age</th> <th>Total</th> <th>Discount</th> <th>Date</th> </tr> </thead> Notice in this output that the "First" and "Last" columns match the contents of the `data-name` attribute and not the header text: Rank,First,Last,Age,Total,Discount,Date * NOTE * The core plugin uses the `data-text` attribute for text extraction. If you want to use the same data for both, make the data-attributes match!
output_delivery	`'popup'`	Change this option to either `'popup'` or `'download'` to set the destination of the output. When setting this option, only the first letter is required (`'p'` or `'d'`) : output_delivery : 'p'
output_saveRows	`'filtered'`	Change this option to either `'filtered'`, `'visible'`, `'all'`, a jQuery filter selector (v2.25.1) to set to match rows to be added to the output, or a jQuery filter callback function (v2.25.2). `'filtered'` - output rows that have not been filtered by the filter widget (i.e. rows that do not have the "filtered" class applied; this class name is set by the `filter_filteredRow` widget option). `'visible'` - only output rows that are currently visible; rows hidden by pagination will not be included. jQuery filter selector - output all rows that match the jQuery filter (use a string; not a jQuery object). For example, `'.checked'`, `'.checked:visible'` or `:not(.checked)` can be used; these examples match the class set by the checkbox parser `table.config.checkboxClass` class setting. For reference, internally, the rows are filtered using this setting: `$rows.filter( wo.output_saveRows )`. Instead of checking to see if `output_saveRows` works as a filter, the option is checked to see if it starts with any of the following characters before it is used as a filter: `'.'` (class selector) `'#'` (id selector) `':'` (filter selectors, e.g. `':visible'` or `':not()'`) `[` (start of an attribute selector) `'all'` - output all rows even if they are hidden. When the pager `removeRows` option is `true`, rows not visible do not exist in the DOM and therefore will not be included. `function` - (v2.25.2) Include a filter function to test each row and return a boolean value; `true` to include the row, and `false` to exclude. For example: output_saveRows: function(index, element) { // "this" is the same as "element" // only include the row if the select element's value is set to "include". return $(this).find('select').val() === 'include'; } Even if this option is set to `'filtered'` and the filter widget is not being used, all of the rows will be added to the output. NOTE When setting this option, Only the first letter is required for filtered (`'f'`) or visible (`'v'`) rows. output_saveRows : 'f' If using a jQuery selector, it won't be recognized as a selector unless one of the characters (`.#:[`) is at the start of the string; if your filter is not working, or uses a charater not listed, then use the callback function, or you can contact me for support. If no matches are found, all rows will be sent to the output.
output_duplicateSpans	`true`	When `true`, colspan & rowspan content is duplicated in the output By default, any tbody cells that are included in the colspan or rowspan will have the cell's content duplicated in the output. When set to `false`, the cells within the colspan or rowspan will be empty. Here is an example of the second table output with this option set to `false`: line,values,values,values line,value1,value2,value3 1,1.1,1.2,1.3 ,1.4,1.5, 2,2.1,2.2,2.3 ,2.4,2.5, 3,3.1,3.2,3.3 ,3.4,3.5, 4,4.1,,4.2 ,,,4.3 This option does not affect thead cells, they will always have duplicated content.
output_replaceQuote	`'\u201c;'`	When a table cell contains a quote, it needs to be modified to differentiate it from cell content that is wrapped in quotes. Quotes are necessary to maintain the integrity of the output data when any cell content contains either the separator or carriage returns. In order to do this, this widget replaces any quotes within cell content with this character. By default, this replacement character is a left double quote (`“`, shown as it's unicode equivalent `'\u201c;'`). output_replaceQuote : '\u201c;' // left double quote In the demo below, additional examples of a single quote (`'`) and escaped double quote (`\"`) are added as selectable buttons. Rank,First,Last,Age,Total,Discount,Date 1,Philip Aaron Wong,Johnson Sr Esq,25,$5.95,22%,"Jun 26, 2004 7:22 AM" 21,John,“Robin“\n\tHood,33,$19.99,25%,"Dec 10, 2002 5:14 AM" 013,Clark,“Old man“ Kent Sr.,18,$15.89,44%,"Jan 12, 2003 11:14 AM" 16,Jim,“Jimmy“ Franco,24,-$14.19,24%,"Jan 14, 2004 11:23 AM" 55,Dennis,“Charley“ Bronson,65,$123.00,32%,"Jan 20, 2001 1:12 PM"
output_includeHTML	`false`	This option, if `true` tells the widget to include any HTML within the table cells. Only cells within the table body will include HTML. The table header has a lot of extra markup for the sorting arrows, so it is automatically stripped of HTML.
output_trimSpaces	`true`	This option, if `true` tells the widget to remove any leading and trailing (white)space characters Leading and trailing whitespace characters include newlines, spaces, non-breaking spaces and tabs. Any of these whitespace characters in the middle of the table cell will always be preserved. NOTE carriage returns in the middle of the table cell content will be stripped out if this option is set to `true`.
output_wrapQuotes	`false`	This option, if `true` wrap the output of all table cell content in quotes. This is the output of the widget when the age column is filtered for results in the range . "Rank","First","Last","Age","Total","Discount","Date" "1","Philip Aaron Wong","Johnson Sr Esq","25","$5.95","22%","Jun 26, 2004 7:22 AM" "111","Peter","Parker","28","$9.99","20%","Jul 6, 2006 8:14 AM" "21","John","'Robin'\n\tHood","33","$19.99","25%","Dec 10, 2002 5:14 AM" "9","Martha","delFuego","25","$22.09","12%","Jun 11, 2011 10:55 AM" Notice that every block of data is wrapped in a quote. When this option is `false`, only blocks that contain a newline or separator (comma, by default) will be wrapped in quotes. Here is the same data set without this option set: Rank,First,Last,Age,Total,Discount,Date 1,Philip Aaron Wong,Johnson Sr Esq,25,$5.95,22%,"Jun 26, 2004 7:22 AM" 111,Peter,Parker,28,$9.99,20%,"Jul 6, 2006 8:14 AM" 21,John,'Robin'\n\tHood,33,$19.99,25%,"Dec 10, 2002 5:14 AM" 9,Martha,delFuego,25,$22.09,12%,"Jun 11, 2011 10:55 AM" Only the dates, which contain commas, are wrapped in quotes.
output_popupStyle	`'width=500,height=300'`	If the data is sent to a popup window, the features set by this option are applied (do not include any spaces). Set the desired popup window features within this string. For a full list of features, please refer to the Mozilla Developer Network: Window.open documentation page (look for `strWindowFeatures` parameters). The `<textarea>` within the popup window is set with 100% width and height.
output_saveFileName	`'mytable.csv'`	When downloading, this option sets the filename of the output.
output_formatContent	null	This callback is executed after the content of a table cell has been processed (v2.22.4; Updated 2.30.5). Default setting & how to use this option: output_formatContent : function( c, wo, data ) { // data.isHeader (boolean) = true if processing a header cell // data.$cell = jQuery object of the cell currently being processed // data.content = processed cell content (spaces trimmed, quotes added/replaced, etc) // data.columnIndex = column in which the cell is contained (added v2.30.5) // data.parsed = cell content parsed by the associated column parser (added v2.30.5) // ********** // use data.$cell.html() to get the original cell content return data.content .replace(/fred/ig, '') // because we don't like fred // because HTML is being processed, you might want to also replace HTML codes .replace(/&/g, '&') // convert '&' → '&' } If you want to replace all HTML codes, check out the he library; then you can use this code (Fred would be happy): output_formatContent : function( c, wo, data ) { // replace all HTML shortcut codes // (e.g. 'foo © bar ≠ baz 𝌆 qux' → 'foo © bar ≠ baz 𝌆 qux' ) return he.decode( data.content ); }
output_callback	{see description}	Return `true` or modified data in this callback to continue the download or open the popup (v2.25.1). In v2.27.0, a url parameter was added to the callback. In v2.25.1, this callback can return modified data for output. As of v2.17.0 (v2.27.0) , the callback function was modified to pass ~~two~~ three parameters: `config` - the `table.config` settings. `data` - the output data as a string `url` - the url of the current page (including filters, sort, etc), if the pager widget/addon is being used. You can get the same value by using `config.pager.ajaxObject.url`; this parameter was added for convenience. The value will be `null` if the pager is not being used. Default setting: function(config, data, url) { // return data.replace( /Mary Smith/g, 'Mary Smith-Jones' ); // v2.25.1+ return true; } After table processing has completed, this callback function is exectued. If `true` is not returned, the processed data will not open a popup, nor download the data. output_callback : function(config, data, url) { // send output to the console only console.log(data); return false; } If you are using the pager and want to provide the entire table in the output, use this callback as follows: function(config, data, url) { // This is only an example, but you could set it up so that a "&csv=1" // parameter in the url to signal the server to provide the csv for the // entire table using the current filters, sort, etc. if (url) { return $.getJSON(url + "&csv=1") .done(function(data) { return data.csv; }) .fail(function() { alert('no go on CSV'); return false; }); } return true; }
output_callbackJSON	{see description}	JSON callback executed when a colspan is encountered in the header. Default setting & how to use this option: output_callbackJSON : function($cell, txt, cellIndex) { return txt + '(' + (cellIndex + col) + ')'; } For more details on why this option is necessary, see the "Rowspan and colspan" section above.
output_encoding	{see description}	Default encoding setting (2.16.4; 2.17.5) As of 2.17.5, this option no longer needs to be modified to specifically make this widget download files that will work in Excel. The method used to download has been completely changed. The downloads still need an encoding setting, but this option is now set to a default of output_encoding : 'data:application/octet-stream;charset=utf8,' Note The trailing comma is important! The information below is no longer relavant: With the default settings (utf-8 no BOM), Excel does not properly encode accented characters unless the csv file is imported. Depending on the characters used, there are various methods which will allow proper encoding, but no one method is ideal. So this option can be set to allow the user to try different encodings. Set it as follows: // output data type (with BOM or Windows-1252 is needed for excel) // NO BOM : 'data:text/csv;charset=utf8,' // With BOM : 'data:text/csv;charset=utf8,%EF%BB%BF' // WIN 1252 : 'data:text/csv;charset=windows-1252,' // ANSI (subset of ISO-8859-1) output_encoding : 'data:text/csv;charset=utf8,'
output_savePlugin	`null`	Override internal save file code and use an external plugin (v2.28.4) You can use a plugin such as FileSaver.js instead of the simplified, and possibly out-of-date internal method. Use this option as follows: output_savePlugin: function(config, widgetOptions, data) { var blob = new Blob([data], {type: widgetOptions.output_encoding}); saveAs(blob, widgetOptions.output_saveFileName); }

Option	Default	Description

Note If you need to change the carriage return and/or the tab replacement strings, modify them as follows (changed in v2.21.2):

// these are the default settings
$.tablesorter.output.replaceCR = '\x0d\x0a';
$.tablesorter.output.replaceTab = '\x09';

Demo

Search in the Discount column

Table showing filter & pager support

Rank	First Name	Last Name	Age	Total	Discount	Date

Rank	First Name	Last Name	Age	Total	Discount	Date
1	Philip Aaron Wong	Johnson Sr Esq	25	$5.95	22%	Jun 26, 2004 7:22 AM
11	Aaron	"doc" Hibert	12	$2.99	5%	Aug 21, 2009 12:21 PM
12	Brandon Clark	Henry Jr	51	$42.29	18%	Oct 13, 2000 1:15 PM
111	Peter	Parker	28	$9.99	20%	Jul 6, 2006 8:14 AM
21	John	"Robin" Hood	33	$19.99	25%	Dec 10, 2002 5:14 AM
013	Clark	"Old man" Kent Sr.	18	$15.89	44%	Jan 12, 2003 11:14 AM
005	Bruce	Almighty Esq	45	$153.19	44%	Jan 18, 2021 9:12 AM
10	Alex	Dumass	13	$5.29	4%	Jan 8, 2012 5:11 PM
16	Jim	"Jimmy" Franco	24	-$14.19	24%	Jan 14, 2004 11:23 AM
166	Bruce Lee	Evans	22	$13.19	11%	Jan 18, 2007 9:12 AM
100	Brenda Dexter	McMasters	18	$55.20	15%	Feb 12, 2010 7:23 PM
55	Dennis	"Charley" Bronson	65	$123.00	32%	Jan 20, 2001 1:12 PM
9	Martha	delFuego	25	$22.09	12%	Jun 11, 2011 10:55 AM

Table showing output widget rowspan & colspan support

line	values
line	value1	value2	value3

1	1.1	1.2	1.3
1	1.4	1.5
2	2.1	2.2	2.3
2	2.4	2.5
3	3.1	3.2	3.3
3	3.4	3.5
4	4.1		4.2
4	4.1		4.3

Page Header

<!-- Tablesorter: required -->
<link href="css/theme.bootstrap.css" rel="stylesheet">
<script src="js/jquery-latest.min.js"></script>
<script src="js/jquery.tablesorter.js"></script>
<script src="js/jquery.tablesorter.widgets.js"></script>
<!-- pager -->
<link href="css/jquery.tablesorter.pager.css" rel="stylesheet">
<script src="js/jquery.tablesorter.pager.js"></script>
<!-- Ouput widget -->
<script src="js/parsers/parser-input-select.js"></script>
<script src="js/widgets/widget-ouput.js"></script>

CSS

table.tablesorter tbody tr.odd.checked td {
  background: #8080c0;
  color: #fff;
}
table.tablesorter tbody tr.even.checked td {
  background: #a0a0e0;
  color: #fff;
}

Script

$(function() {

  $('.group1 table').tablesorter({
    theme: 'bootstrap',
    checkboxClass : 'checked', // default setting
    widthFixed : true,
    headerTemplate : '{content} {icon}',
    widgets: ["zebra", "filter", "uitheme", "output"],
    widgetOptions : {
      filter_filteredRow   : 'filtered',
      filter_reset         : '.group1 .reset',

      output_separator     : ',',         // ',' 'json', 'array' or separator (e.g. ';')
      output_ignoreColumns : [0],         // columns to ignore [0, 1,... ] (zero-based index)
      output_hiddenColumns : false,       // include hidden columns in the output
      output_includeFooter : true,        // include footer rows in the output
      output_includeHeader : true,        // include header rows in the output
      output_headerRows    : false,       // output all header rows (if multiple rows)
      output_dataAttrib    : 'data-name', // data-attribute containing alternate cell text
      output_delivery      : 'p',         // (p)opup, (d)ownload
      output_saveRows      : 'f',         // (a)ll, (v)isible, (f)iltered, jQuery filter selector (string only) or filter function
      output_duplicateSpans: true,        // duplicate output data in tbody colspan/rowspan
      output_replaceQuote  : '\u201c;',   // change quote to left double quote
      output_includeHTML   : true,        // output includes all cell HTML (except the header cells)
      output_trimSpaces    : false,       // remove extra white-space characters from beginning & end
      output_wrapQuotes    : false,       // wrap every cell output in quotes
      output_popupStyle    : 'width=580,height=310',
      output_saveFileName  : 'mytable.csv',
      // callback executed after the content of the table has been processed
      output_formatContent : function(config, widgetOptions, data) {
        // data.isHeader (boolean) = true if processing a header cell
        // data.$cell = jQuery object of the cell currently being processed
        // data.content = processed cell content (spaces trimmed, quotes added/replaced, etc)
        // data.columnIndex = column in which the cell is contained
        // data.parsed = cell content parsed by the associated column parser
        return data.content;
      },
      // callback executed when processing completes
      output_callback      : function(config, data, url) {
        // return false to stop delivery & do something else with the data
        // return true OR modified data (v2.25.1) to continue download/output
        return true;
      },
      // callbackJSON used when outputting JSON & any header cells has a colspan - unique names required
      output_callbackJSON  : function($cell, txt, cellIndex) {
        return txt + '(' + cellIndex + ')';
      },
      // the need to modify this for Excel no longer exists
      output_encoding      : 'data:application/octet-stream;charset=utf8,',
      // override internal save file code and use an external plugin such as
      // https://github.com/eligrey/FileSaver.js
      output_savePlugin    : null /* function(config, widgetOptions, data) {
        var blob = new Blob([data], {type: widgetOptions.output_encoding});
        saveAs(blob, widgetOptions.output_saveFileName);
      } */
    }
  }).tablesorterPager({
    container: $('.ts-pager'),
    output: '{startRow} - {endRow} / {filteredRows} ({totalRows})',
    size: 5
  });

  $('.group2 table').tablesorter({
    theme: 'bootstrap',
    widthFixed : true,
    headerTemplate : '{content} {icon}',
    widgets: ["zebra", "filter", "uitheme", "output"],
    widgetOptions : {
      filter_filteredRow   : 'filtered',
      filter_reset         : '.group2 .reset',
      output_headerRows    : true,        // output all header rows (multiple rows)
      output_popupStyle    : 'width=580,height=310',
      output_saveFileName  : 'mytable.csv'
    }
  });

  // set up download buttons for two table groups
  var demos = ['.group1', '.group2'];

  $.each(demos, function(groupIndex) {
    var $this = $(demos[groupIndex]);

    $this.find('.dropdown-toggle').click(function(e) {
      // this is needed because clicking inside the dropdown will close
      // the menu with only bootstrap controlling it.
      $this.find('.dropdown-menu').toggle();
      return false;
    });
    // make separator & replace quotes buttons update the value
    $this.find('.output-separator').click(function() {
      $this.find('.output-separator').removeClass('active');
      var txt = $(this).addClass('active').html();
      $this.find('.output-separator-input').val( txt );
      $this.find('.output-filename').val(function(i, v) {
        // change filename extension based on separator
        var filetype = (txt === 'json' || txt === 'array') ? 'js' :
          txt === ',' ? 'csv' : 'txt';
        return v.replace(/\.\w+$/, '.' + filetype);
      });
      return false;
    });
    $this.find('.output-quotes').click(function() {
      $this.find('.output-quotes').removeClass('active');
      $this.find('.output-replacequotes').val( $(this).addClass('active').text() );
      return false;
    });
    // header/footer toggle buttons
    $this.find('.output-header, .output-footer').click(function() {
      $(this).toggleClass('active');
    });
    // clicking the download button; all you really need is to
    // trigger an "output" event on the table
    $this.find('.download').click(function() {
      var typ,
        $table = $this.find('table'),
        wo = $table[0].config.widgetOptions,
        val = $this.find('.output-filter-all :checked').attr('class');
      wo.output_saveRows     = val === 'output-filter' ? 'f' :
        val === 'output-visible' ? 'v' :
        // checked class name, see table.config.checkboxClass
        val === 'output-selected' ? '.checked' :
        val === 'output-sel-vis' ? '.checked:visible' :
        'a';
      val = $this.find('.output-download-popup :checked').attr('class');
      wo.output_delivery     = val === 'output-download' ? 'd' : 'p';
      wo.output_separator    = $this.find('.output-separator-input').val();
      wo.output_replaceQuote = $this.find('.output-replacequotes').val();
      wo.output_trimSpaces   = $this.find('.output-trim').is(':checked');
      wo.output_includeHTML  = $this.find('.output-html').is(':checked');
      wo.output_wrapQuotes   = $this.find('.output-wrap').is(':checked');
      wo.output_saveFileName = $this.find('.output-filename').val();

      // first example buttons, second has radio buttons
      if (groupIndex === 0) {
        wo.output_includeHeader = $this.find('button.output-header').is(".active");
      } else {
        wo.output_includeHeader = !$this.find('.output-no-header').is(':checked');
        wo.output_headerRows = $this.find('.output-headers').is(':checked');
      }
      // footer not included in second example
      wo.output_includeFooter = $this.find('.output-footer').is(".active");

      $table.trigger('outputTable');
      return false;
    });

    // add tooltip
    $this.find('.dropdown-menu [title]').tipsy({ gravity: 's' });

  });

});

HTML

<div class="group1">
  <h4>Table showing filter & pager support</h4>
  <div class="btn-group">
    <button type="button" class="btn btn-default reset">Reset</button> <!-- targeted by the "filter_reset" option -->

    <!-- Split button -->
    <div class="btn-group">
      <button type="button" class="btn btn-default download">Output</button>
      <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
        <span class="caret"></span>
        <span class="sr-only">Toggle Dropdown</span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li><h5><strong>Output options</strong></h5></li>
        <li>
          <label>Separator: <input class="output-separator-input" type="text" size="2" value=","></label>
          <button type="button" class="output-separator btn btn-default btn-xs active" title="comma">,</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="semi-colon">;</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="tab">⇥</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="space">␣</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="output JSON">json</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="output Array (see note)">array</button>
        </li>
        <li>
          <label>Send to:</label>
          <div class="btn-group output-download-popup" data-toggle="buttons" title="Download file or open in Popup window">
            <label class="btn btn-default btn-sm active">
              <input type="radio" name="delivery1" class="output-popup" checked=""> Popup
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="delivery1" class="output-download"> Download
            </label>
          </div>
        </li>
        <li>
          <label>Include:</label>
          <div class="btn-group output-filter-all" data-toggle="buttons" title="Output only filtered, visible, selected, selected+visible or all rows">
            <label class="btn btn-default btn-sm active">
              <input type="radio" name="getrows1" class="output-filter" checked="checked"> Filtered
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="getrows1" class="output-visible"> Visible
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="getrows1" class="output-selected"> Selected
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="getrows1" class="output-sel-vis"> Sel+Vis
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="getrows1" class="output-all"> All
            </label>
          </div>
        </li>
        <li>
          <button class="output-header btn btn-default btn-sm active" title="Include table header">Header</button>
          <button class="output-footer btn btn-default btn-sm active" title="Include table footer">Footer</button>
        </li>
        <li class="divider"></li>
        <li>
          <label>Replace quotes: <input class="output-replacequotes" type="text" size="2" value="'"></label>
          <button type="button" class="output-quotes btn btn-default btn-xs active" title="single quote">'</button>
          <button type="button" class="output-quotes btn btn-default btn-xs" title="left double quote">“</button>
          <button type="button" class="output-quotes btn btn-default btn-xs" title="escaped quote">\"</button>
        </li>
        <li><label title="Remove extra white space from each cell">Trim spaces: <input class="output-trim" type="checkbox" checked=""></label></li>
        <li><label title="Include HTML from cells in output">Include HTML: <input class="output-html" type="checkbox"></label></li>
        <li><label title="Wrap all values in quotes">Wrap in Quotes: <input class="output-wrap" type="checkbox"></label></li>
        <li><label title="Choose a download filename">Filename: <input class="output-filename" type="text" size="15" value="mytable.csv"></label></li>
      </ul>
    </div>
  </div>

  <div class="ts-pager form-horizontal">
    <button type="button" class="btn btn-default btn-sm first"><i class="glyphicon glyphicon-step-backward"></i></button>
    <button type="button" class="btn btn-default btn-sm prev"><i class="glyphicon glyphicon-backward"></i></button>
    <span class="pagedisplay"></span> <!-- this can be any element, including an input -->
    <button type="button" class="btn btn-default btn-sm next"><i class="glyphicon glyphicon-forward"></i></button>
    <button type="button" class="btn btn-default btn-sm last"><i class="glyphicon glyphicon-step-forward"></i></button>
    <select class="pagesize form-control btn-sm" title="Select page size">
      <option selected="selected" value="5">5</option>
      <option value="10">10</option>
    </select>
    <select class="gotoPage form-control btn-sm" title="Select page number"></select>
  </div>

  <table id="table" class="tablesorter">
    <thead>
      <tr>
        <th class="sorter-checkbox filter-false"> </th>
        <th>Rank</th>
        <th data-name="First">First Name</th>
        <th data-name="Last">Last Name</th>
        <th>Age</th>
        <th>Total</th>
        <th>Discount</th>
        <th>Date</th>
      </tr>
    </thead>
    <tfoot>
      <tr>
        <th></th>
        <th>Rank</th>
        <th data-name="First & middle">First Name</th>
        <th data-name="Last & Title">Last Name</th>
        <th>Age</th>
        <th>Total</th>
        <th>Discount</th>
        <th>Date</th>
      </tr>
    </tfoot>
    <tbody>
      <tr><td><input type="checkbox"></td><td>1</td><td>Philip Aaron Wong</td><td>Johnson Sr Esq</td><td>25</td><td>$5.95</td><td>22%</td><td>Jun 26, 2004 7:22 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>11</td><td>Aaron</td><td>"doc" Hibert</td><td>12</td><td>$2.99</td><td>5%</td><td>Aug 21, 2009 12:21 PM</td></tr>
      <tr><td><input type="checkbox"></td><td>12</td><td>Brandon Clark</td><td>Henry Jr</td><td>51</td><td>$42.29</td><td>18%</td><td>Oct 13, 2000 1:15 PM</td></tr>
      <tr><td><input type="checkbox"></td><td>111</td><td>Peter</td><td>Parker</td><td>28</td><td>$9.99</td><td>20%</td><td>Jul 6, 2006 8:14 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>21</td><td><span class="red">John</span></td><td>        "Robin"<br>  Hood          </td><td>33</td><td>$19.99</td><td>25%</td><td>Dec 10, 2002 5:14 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>013</td><td>Clark</td><td>"Old man" Kent Sr.</td><td>18</td><td>$15.89</td><td>44%</td><td>Jan 12, 2003 11:14 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>005</td><td>Bruce</td><td>Almighty <span class="red">Esq</span></td><td>45</td><td>$153.19</td><td>44%</td><td>Jan 18, 2021 9:12 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>10</td><td>Alex</td><td>Dumass</td><td>13</td><td>$5.29</td><td>4%</td><td>Jan 8, 2012 5:11 PM</td></tr>
      <tr><td><input type="checkbox"></td><td>16</td><td>Jim</td><td>"Jimmy" Franco</td><td>24</td><td><span class="red">-$14.19</span></td><td>24%</td><td>Jan 14, 2004 11:23 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>166</td><td>Bruce Lee</td><td>Evans</td><td>22</td><td>$13.19</td><td>11%</td><td>Jan 18, 2007 9:12 AM</td></tr>
      <tr><td><input type="checkbox"></td><td>100</td><td>Brenda Dexter</td><td>McMasters</td><td>18</td><td>$55.20</td><td>15%</td><td>Feb 12, 2010 7:23 PM</td></tr>
      <tr><td><input type="checkbox"></td><td>55</td><td>Dennis</td><td><span class="red">"Charley"</span> Bronson</td><td>65</td><td>$123.00</td><td>32%</td><td>Jan 20, 2001 1:12 PM</td></tr>
      <tr><td><input type="checkbox"></td><td>9</td><td>Martha</td><td>delFuego</td><td>25</td><td>$22.09</td><td>12%</td><td>Jun 11, 2011 10:55 AM</td></tr>
    </tbody>
  </table>
</div>

<div class="group2">
  <h4>Table showing output widget rowspan & colspan support</h4>
  <div class="btn-group">
    <button type="button" class="btn btn-default reset">Reset</button> <!-- targeted by the "filter_reset" option -->

    <!-- Split button -->
    <div class="btn-group">
      <button type="button" class="btn btn-default download">Output</button>
      <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
        <span class="caret"></span>
        <span class="sr-only">Toggle Dropdown</span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li><h5><strong>Output options</strong></h5></li>
        <li>
          <label>Separator: <input class="output-separator-input" type="text" size="2" value=","></label>
          <button type="button" class="output-separator btn btn-default btn-xs active" title="comma">,</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="semi-colon">;</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="tab">⇥</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="space">␣</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="output JSON">json</button>
          <button type="button" class="output-separator btn btn-default btn-xs" title="output Array (see note)">array</button>
        </li>
        <li>
          <label>Send to:</label>
          <div class="btn-group output-download-popup" data-toggle="buttons" title="Download file or open in Popup window">
            <label class="btn btn-default btn-sm active">
              <input type="radio" name="delivery2" class="output-popup" checked=""> Popup
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="delivery2" class="output-download"> Download
            </label>
          </div>
        </li>
        <li>
          <label>Include:</label>
          <div class="btn-group output-filter-all" data-toggle="buttons" title="Output only filtered, visible or all rows">
            <label class="btn btn-default btn-sm active">
              <input type="radio" name="getrows2" class="output-filter" checked=""> Filtered
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="getrows2" class="output-visible"> Visible
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="getrows2" class="output-all"> All
            </label>
          </div>
        </li>
        <li>
          <label>Header:</label>
          <div class="btn-group output-includes" data-toggle="buttons" title="Include no, single (last row), or all table headers">
            <label class="btn btn-default btn-sm">
              <input type="radio" name="headers" class="output-no-header"> None
            </label>
            <label class="btn btn-default btn-sm">
              <input type="radio" name="headers"> Single
            </label>
            <label class="btn btn-default btn-sm active">
              <input type="radio" name="headers" class="output-headers" checked=""> All
            </label>
          </div>
        </li>
        <li class="divider"></li>
        <li>
          <label>Replace quotes: <input class="output-replacequotes" type="text" size="2" value="'"></label>
          <button type="button" class="output-quotes btn btn-default btn-xs active" title="single quote">'</button>
          <button type="button" class="output-quotes btn btn-default btn-xs" title="left double quote">“</button>
          <button type="button" class="output-quotes btn btn-default btn-xs" title="escaped quote">\"</button>
        </li>
        <li><label title="Remove extra white space from each cell">Trim spaces: <input class="output-trim" type="checkbox" checked=""></label></li>
        <li><label title="Include HTML from cells in output">Include HTML: <input class="output-html" type="checkbox"></label></li>
        <li><label title="Wrap all values in quotes">Wrap in Quotes: <input class="output-wrap" type="checkbox"></label></li>
        <li><label title="Choose a download filename">Filename: <input class="output-filename" type="text" size="15" value="mytable.csv"></label></li>
      </ul>
    </div>

  </div>

  <table id="table2">
    <thead>
      <tr>
        <th rowspan="2">line</th>
        <th colspan="3">values</th>
      </tr>
      <tr>
        <th>value1</th>
        <th>value2</th>
        <th>value3</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td rowspan="2">1</td>
        <td>1.1</td>
        <td>1.2</td>
        <td><span class="red">1.3</span></td>
      </tr>
      <tr class="tablesorter-childRow">
        <td>1.4</td>
        <td colspan="2">1.5</td>
      </tr>
      <tr>
        <td rowspan="2">2</td>
        <td>2.1</td>
        <td><span class="red">2.2</span></td>
        <td>2.3</td>
      </tr>
      <tr class="tablesorter-childRow">
        <td>2.4</td>
        <td colspan="2">2.5</td>
      </tr>
      <tr>
        <td rowspan="2">3</td>
        <td>3.1</td>
        <td>3.2</td>
        <td>3.3</td>
      </tr>
      <tr class="tablesorter-childRow">
        <td>3.4</td>
        <td colspan="2"><span class="red">3.5</span></td>
      </tr>
      <tr>
        <td rowspan="2">4</td>
        <td rowspan="2" colspan="2"><span class="red">4.1</span></td>
        <td>4.2</td>
      </tr>
      <tr class="tablesorter-childRow">
        <td>4.3</td>
      </tr>
    </tbody>
  </table>
</div>

tablesorter

Output Widget

Flexible client-side table sorting

Notes

Changes

Older Notes

Requirements

Features & Usage

Known Issues

Credit

Basic Setup

HTML

Script

.htaccess

Setup Example (php)

Basic Example

Output all data

Rowspan and colspan

Options

Output widget default options (added inside of tablesorter `widgetOptions`)

Demo

Table showing filter & pager support

Table showing output widget rowspan & colspan support

Page Header

CSS

Script

HTML