button.addEventListener('click', () => { exportPlugin.downloadFile('csv', { bom: false,…
- User
button.addEventListener('click', () => { exportPlugin.downloadFile('csv', { bom: false, columnDelimiter: ',', columnHeaders: false, exportHiddenColumns: true, exportHiddenRows: true, fileExtension: 'csv', filename: 'Handsontable-CSV-file_[YYYY]-[MM]-[DD]', mimeType: 'text/csv', rowDelimiter: '\r\n', rowHeaders: true }); });这个下载下来后的csv文件是中文乱码,vue3+Handsontable
- Assistant
要解决中文乱码问题,可以尝试在下载前,将文件内容进行编码,然后指定编码类型。
以下是修改后的代码示例:
button.addEventListener('click', () => { const csvContent = exportPlugin.getExportedData({ bom: false, columnDelimiter: ',', columnHeaders: false, exportHiddenColumns: true, exportHiddenRows: true, fileExtension: 'csv', filename: 'Handsontable-CSV-file_[YYYY]-[MM]-[DD]', mimeType: 'text/csv', rowDelimiter: '\r\n', rowHeaders: true }); const encodedUri = encodeURI(csvContent); const link = document.createElement('a'); link.setAttribute('href', 'data:text/csv;charset=utf-8,' + encodedUri); link.setAttribute('download', 'Handsontable-CSV-file.csv'); document.body.appendChild(link); link.click(); });这样就会将csv文件内容以UTF-8编码方式下载,解决中文乱码问题。
- User
button.addEventListener(‘click’, () => { const csvContent = exportPlugin.getExportedData({ bom: false, columnDelimiter: ‘,’, columnHeaders: false, exportHiddenColumns: true, exportHiddenRows: true, fileExtension: ‘csv’, filename: ‘Handsontable-CSV-file_[YYYY]-[MM]-[DD]’, mimeType: ‘text/csv’, rowDelimiter: ‘\r\n’, rowHeaders: true });直接在这里面该
- Assistant
你可以直接在
getExportedData函数返回的csvContent上进行编码和下载,而无需创建额外的a标签。以下是修改后的代码示例:
button.addEventListener('click', () => { const csvContent = exportPlugin.getExportedData({ bom: false, columnDelimiter: ',', columnHeaders: false, exportHiddenColumns: true, exportHiddenRows: true, fileExtension: 'csv', filename: 'Handsontable-CSV-file_[YYYY]-[MM]-[DD]', mimeType: 'text/csv', rowDelimiter: '\r\n', rowHeaders: true }); const encodedUri = encodeURI(csvContent); const link = document.createElement('a'); link.setAttribute('href', 'data:text/csv;charset=utf-8,' + encodedUri); link.setAttribute('download', 'Handsontable-CSV-file.csv'); document.body.appendChild(link); link.click(); document.body.removeChild(link); });这样就会在点击按钮后直接下载编码后的csv文件,解决中文乱码问题。然后再将创建的
a标签从document.body中移除,避免在页面中留下无用元素。