kaminskypavel/export-html-table-to-csv.js

## export-html-table-to-csv.js
// based on table2CSV (https://github.com/rubo77/table2CSV) and https://gist.github.com/adilapapaya/9787842
// paste in console.

(function () {
	jQuery.fn.table2CSV = function (options) {
		var options = jQuery.extend({
				separator: ',',
				header: [],
				headerSelector: 'th',
				columnSelector: 'td',
				delivery: 'popup', // popup, value, download
				filename: 'export.csv', // filename to download
				transform_gt_lt: true // make &gt; and &lt; to > and <
			},
				options);

		var csvData = [];
		var headerArr = [];
		var el = this;

		//header
		var numCols = options.header.length;
		var tmpRow = []; // construct header avalible array

		if (numCols > 0) {
			for (var i = 0; i < numCols; i++) {
				tmpRow[tmpRow.length] = formatData(options.header[i]);
			}
		} else {
			$(el).filter(':visible').find(options.headerSelector).each(function () {
				if ($(this).css('display') != 'none')
					tmpRow[tmpRow.length] = formatData($(this).html());
			});
		}

		row2CSV(tmpRow);

		// actual data
		$(el).find('tr').each(function () {
			var tmpRow = [];
			$(this).filter(':visible').find(options.columnSelector).each(function () {
				if ($(this).css('display') != 'none')
					tmpRow[tmpRow.length] = formatData($(this).html());
			});
			row2CSV(tmpRow);
		});
		if (options.delivery == 'popup') {
			var mydata = csvData.join('\n');
			if (options.transform_gt_lt) {
				mydata = sinri_recover_gt_and_lt(mydata);
			}
			return popup(mydata);
		} else if (options.delivery == 'download') {
			var mydata = csvData.join('\n');
			if (options.transform_gt_lt) {
				mydata = sinri_recover_gt_and_lt(mydata);
			}
			var url = 'data:text/csv;charset=utf8,' + encodeURIComponent(mydata);
			window.open(url);
			return true;
		} else {
			var mydata = csvData.join('\n');
			if (options.transform_gt_lt) {
				mydata = sinri_recover_gt_and_lt(mydata);
			}
			return mydata;
		}

		function sinri_recover_gt_and_lt(input) {
			var regexp = new RegExp(/&gt;/g);
			var input = input.replace(regexp, '>');
			var regexp = new RegExp(/&lt;/g);
			var input = input.replace(regexp, '<');
			return input;
		}

		function row2CSV(tmpRow) {
			var tmp = tmpRow.join('') // to remove any blank rows
				// alert(tmp);
				if (tmpRow.length > 0 && tmp != '') {
					var mystr = tmpRow.join(options.separator);
					csvData[csvData.length] = mystr;
				}
		}
		function formatData(input) {
			// replace " with “
			var regexp = new RegExp(/["]/g);
			var output = input.replace(regexp, "“");
			//HTML
			var regexp = new RegExp(/\<[^\<]+\>/g);
			var output = output.replace(regexp, "");
			output = output.replace(/&nbsp;/gi, ' '); //replace &nbsp;
			if (output == "")
				return '';
			return '"' + output.trim() + '"';
		}
		function popup(data) {
			var generator = window.open('', 'csv', 'height=400,width=600');
			generator.document.write('<html><head><title>CSV</title>');
			generator.document.write('</head><body >');
			generator.document.write('<textArea cols=70 rows=15 wrap="off" >');
			generator.document.write(data);
			generator.document.write('</textArea>');
			generator.document.write('</body></html>');
			generator.document.close();
			return true;
		}
	};


	    $('table').each(function () {
        var $table = $(this);

        var $button = $("<button type='button'>");
        $button.text("Export to spreadsheet");
        $button.insertAfter($table);

        $button.click(function () {
            var csv = $table.table2CSV({
                delivery: 'value'
            });

		   window.location.href = 'data:text/csv;charset=UTF-8,'
            + encodeURIComponent(csv);
        });
    });
})();
	// based on table2CSV (https://github.com/rubo77/table2CSV) and https://gist.github.com/adilapapaya/9787842
	// paste in console.

	(function () {
	jQuery.fn.table2CSV = function (options) {
	var options = jQuery.extend({
	separator: ',',
	header: [],
	headerSelector: 'th',
	columnSelector: 'td',
	delivery: 'popup', // popup, value, download
	filename: 'export.csv', // filename to download
	transform_gt_lt: true // make > and < to > and <
	},
	options);

	var csvData = [];
	var headerArr = [];
	var el = this;

	//header
	var numCols = options.header.length;
	var tmpRow = []; // construct header avalible array

	if (numCols > 0) {
	for (var i = 0; i < numCols; i++) {
	tmpRow[tmpRow.length] = formatData(options.header[i]);
	}
	} else {
	$(el).filter(':visible').find(options.headerSelector).each(function () {
	if ($(this).css('display') != 'none')
	tmpRow[tmpRow.length] = formatData($(this).html());
	});
	}

	row2CSV(tmpRow);

	// actual data
	$(el).find('tr').each(function () {
	var tmpRow = [];
	$(this).filter(':visible').find(options.columnSelector).each(function () {
	if ($(this).css('display') != 'none')
	tmpRow[tmpRow.length] = formatData($(this).html());
	});
	row2CSV(tmpRow);
	});
	if (options.delivery == 'popup') {
	var mydata = csvData.join('\n');
	if (options.transform_gt_lt) {
	mydata = sinri_recover_gt_and_lt(mydata);
	}
	return popup(mydata);
	} else if (options.delivery == 'download') {
	var mydata = csvData.join('\n');
	if (options.transform_gt_lt) {
	mydata = sinri_recover_gt_and_lt(mydata);
	}
	var url = 'data:text/csv;charset=utf8,' + encodeURIComponent(mydata);
	window.open(url);
	return true;
	} else {
	var mydata = csvData.join('\n');
	if (options.transform_gt_lt) {
	mydata = sinri_recover_gt_and_lt(mydata);
	}
	return mydata;
	}

	function sinri_recover_gt_and_lt(input) {
	var regexp = new RegExp(/>/g);
	var input = input.replace(regexp, '>');
	var regexp = new RegExp(/</g);
	var input = input.replace(regexp, '<');
	return input;
	}

	function row2CSV(tmpRow) {
	var tmp = tmpRow.join('') // to remove any blank rows
	// alert(tmp);
	if (tmpRow.length > 0 && tmp != '') {
	var mystr = tmpRow.join(options.separator);
	csvData[csvData.length] = mystr;
	}
	}
	function formatData(input) {
	// replace " with “
	var regexp = new RegExp(/["]/g);
	var output = input.replace(regexp, "“");
	//HTML
	var regexp = new RegExp(/\<[^\<]+\>/g);
	var output = output.replace(regexp, "");
	output = output.replace(/ /gi, ' '); //replace
	if (output == "")
	return '';
	return '"' + output.trim() + '"';
	}
	function popup(data) {
	var generator = window.open('', 'csv', 'height=400,width=600');
	generator.document.write('<html><head><title>CSV</title>');
	generator.document.write('</head><body >');
	generator.document.write('<textArea cols=70 rows=15 wrap="off" >');
	generator.document.write(data);
	generator.document.write('</textArea>');
	generator.document.write('</body></html>');
	generator.document.close();
	return true;
	}
	};


	$('table').each(function () {
	var $table = $(this);

	var $button = $("<button type='button'>");
	$button.text("Export to spreadsheet");
	$button.insertAfter($table);

	$button.click(function () {
	var csv = $table.table2CSV({
	delivery: 'value'
	});

	window.location.href = 'data:text/csv;charset=UTF-8,'
	+ encodeURIComponent(csv);
	});
	});
	})();