js页面数据导出

function exportTableToCSV(filename) {
    const csv = [];
    const rows = document.querySelectorAll('table tr');
    
    for (let i = 0; i < rows.length; i++) {
        const row = [], cols = rows[i].querySelectorAll('td, th');
        for (let j = 0; j < cols.length; j++) {
            let data = cols[j].innerText.replace(/"/g, '""'); // 转义双引号
            if (data.search(/("|,|\n)/g) >= 0) {
                data = `"${data}"`; // 用双引号包裹包含逗号、换行或双引号的单元格
            }
            row.push(data);
        }
        csv.push(row.join(','));
    }
    
    const csvFile = new Blob([csv.join('\n')], { type: 'text/csv;charset=utf-8;' });
    const downloadLink = document.createElement('a');
    downloadLink.download = filename;
    downloadLink.href = URL.createObjectURL(csvFile);
    downloadLink.style.display = 'none';
    document.body.appendChild(downloadLink);
    downloadLink.click();
    document.body.removeChild(downloadLink);
}

// 使用示例
document.getElementById('exportButton').addEventListener('click', function() {
    exportTableToCSV('table-data.csv');
});