js导出table为csv文件

最新推荐文章于 2025-05-11 11:21:57 发布

PHPerJiang

最新推荐文章于 2025-05-11 11:21:57 发布

阅读量1.6k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： HTML+CSS+JS 文章标签： table导出

本文链接：https://blog.youkuaiyun.com/qq_36558538/article/details/89093299

HTML+CSS+JS 专栏收录该内容

11 篇文章

订阅专栏

本文介绍了一种使用JavaScript将HTML表格内容转换并导出为CSV文件的方法。通过定义特定的函数，可以轻松地将网页上的表格数据下载为CSV格式，方便进行后续的数据处理或存档。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

html

<a onclick="exportTableToCSV(this, $('#tb'), 'Lanmu_feed_count.csv')"><input type="submit" value="导出"></a>


//xportTableToCSV(当前按钮对象, table表格id, 文件名)

javascript

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
        }
    }