html table导出csv,js导出table为csv文件

function exportTableToCSV(me, $table, filename) {

var $headers = $table.find('tr:has(th)'), $rows = $table.find('tr:has(td)')

// Temporary delimiter characters unlikely to be typed by keyboard

// This is to avoid accidentally splitting the actual contents

, tmpColDelim = String.fromCharCode(11) // vertical tab character

, tmpRowDelim = String.fromCharCode(0) // null character

// actual delimiter characters for CSV format

, colDelim = '","', rowDelim = '"\r\n"';

// Grab text from table into CSV formatted string

var csv = '"';

csv += formatRows($headers.map(grabRow));

csv += rowDelim;

csv += formatRows($rows.map(grabRow)) + '"';

// Data URI

var csvData = 'data:application/csv;charset=utf-8,\ufeff' + encodeURIComponent(csv);

$(me)

.attr({

'download': filename,

'href': csvData

//,'target' : '_blank' //if you want it to open in a new window

});

//------------------------------------------------------------

// Helper Functions

//------------------------------------------------------------

// Format the output so it has the appropriate delimiters

function formatRows(rows) {

return rows.get().join(tmpRowDelim)

.split(tmpRowDelim).join(rowDelim)

.split(tmpColDelim).join(colDelim);

}

// Grab and format a row from the table

function grabRow(i, row) {

var $row = $(row);

//for some reason $cols = $row.find('td') || $row.find('th') won't work...

var $cols = $row.find('td');

if (!$cols.length) $cols = $row.find('th');

return $cols.map(grabCol)

.get().join(tmpColDelim);

}

// Grab and format a column from the table

function grabCol(j, col) {

var $col = $(col), $text = $col.text();

return $text.replace('"', '""'); // escape double quotes

}

}