htmlTable2Spreadsheet

html-table-to-spreadsheet.js

/**
 * Convert an html table to a spreadsheet and download it
 * 
 * @param {String} selector - Selector of table
 * @param {String} format - xls or csv
 * 
 * Usage 
 * htmlTable2Spreadsheet('.table', 'xls').download()
 */

class htmlTable2Spreadsheet {
	constructor(selector = 'table', format = 'xls') {
		this.selector = selector
		this.format = format
		this.content = '';
		this._make()
	}

	_make() {
		const divider = this.format == 'csv' ? ',' : ';'
		const element = document.querySelector(this.selector)

		element.querySelectorAll('tr').forEach(row =>
			this.content += [...row.querySelectorAll('td, th')].map(td => 
				td.innerHTML.trim()
			).join(divider) + '\n'
		)
		return this
	}

	download() {
		window.open('data:text/csv;charset=utf-8,' + escape(this.content))
	}
}