Javascript到csv导出编码问题 [英] Javascript to csv export encoding issue

问题描述

我需要导出javascript数组到excel文件，并下载它我在这里代码。 data是一个javascript对象数组。

I need to export javascript array to excel file and download it I'm doing it in this code. data is a javascript object array.

var csvContent = "data:text/csv;charset=utf-8,";
data.forEach(function(dataMember, index)
{
    dataString = dataMember.join(",");
    csvContent += index < data.length ? dataString+ "\n" : dataString;
}); 

var encodedUri = encodeURI(csvContent);
var link = document.createElement("a");
link.setAttribute("href", encodedUri);
link.setAttribute("download", "upload_data" + (new Date()).getTime() + ".csv");
link.click();

所有这些东西都可以正常工作，直到我有具有非英文字符的字符串属性，如西班牙语，阿拉伯语或希伯来语。如何使用所有非ASCII值导出？

All this stuff works fine till I have string properties that have non-english characters, like spanish, arabic or hebrew. How can I make an export with all this non-ASCII values?

推荐答案

您应该在开始时添加UTF-8 BOM ，如：

You should add the UTF-8 BOM at the start of the text, like:

var csvContent = "data:text/csv;charset=utf-8,%EF%BB%BF";

它适用于Excel 2013。

It worked for me with Excel 2013.

演示小提琴

Demo Fiddle

这篇关于Javascript到csv导出编码问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！