下载文件时设置csv编码

Question

我使用的是react、Paparse和encoding-japanese

使用Paparse，我可以上传CSV并从Shift-JS中解码它。但库不支持相反的操作。

我添加了编码-日语，以便将字符串转换为SHIFT-js并下载它。

下面是我的代码：

    const csv = csvParser.unparse({
        "fields": ["行形式","取引番号","取引日","支払期限","顧客番号","顧客企業名","顧客電話番号","送付先郵便番号","請求書発行日","郵送","メール送付","取引金額","明細","単価","数量","金額","消費税率","税込対象額_10%","税込対象額_8%","税込対象額_経8%","税込対象額_旧8%","税込対象額_非","税込対象額_対象外"],
        "data": [
            ["取引","transaction-20200218-094750_1","2020/02/18","2020/03/31","DP79","Sample1Corp","03-0000-0000","123-4567","2020/02/19","0","1","110","","","","","","110","","","",""]
        ]
    });
    const a = document.createElement("a");
    const sjisArray = Encoding.convert(csv, 'SJIS', 'UTF8');
    console.log(sjisArray)
    a.href = window.URL.createObjectURL(new Blob(['\ufeff'+sjisArray], {type: "text/csv;charset=shift-js"}));
    a.download = "取引サンプル.csv";
    a.click();

它没有抛出错误，但当我在记事本中打开csv文件时，它仍然在UTF8和物料清单中。

我希望它在shift-js中。

我怎样才能做到这一点呢？

Answer 1

您的Encoding库当前返回一个DOMString，因为您传递了这样一个DOMString作为输入。

这意味着您的Blob构造函数将把这个DOMString转换为UTF8，这就是您的文件中的内容: Shift-JIS编码文本的UTF16表示的UTF8版本。

至少可以说，这不是你想要的。

快速浏览一下该库的文档，似乎最好的方法是传递一个要编码的ArrayBuffer版本的文本，这样它就会向您返回一个字节值的数组(类似于Uint8Array，除非它们出于某种原因使用普通的数组...)。

然后，从该字节数组中，您将能够生成一个新的ArrayBuffer，您将能够传递给您的Blob，而无需将其转换回UTF-8。

​

const csv = Papa.unparse({
    "fields": ["行形式","取引番号","取引日","支払期限","顧客番号","顧客企業名","顧客電話番号","送付先郵便番号","請求書発行日","郵送","メール送付","取引金額","明細","単価","数量","金額","消費税率","税込対象額_10%","税込対象額_8%","税込対象額_経8%","税込対象額_旧8%","税込対象額_非","税込対象額_対象外"],
    "data": [
        ["取引","transaction-20200218-094750_1","2020/02/18","2020/03/31","DP79","Sample1Corp","03-0000-0000","123-4567","2020/02/19","0","1","110","","","","","","110","","","",""]
    ]
});
// First convert our DOMString to an ArrayBuffer
const utf8Array = new TextEncoder().encode( csv );
// pass it to Encoding so we get back an Array of bytes
const sjisArray = Encoding.convert(utf8Array, 'SJIS', 'UTF8');
// now we can make our Blob without auto encoding
const blob = new Blob( [ new Uint8Array( sjisArray ) ] );

const a = document.createElement('a');
a.download = 'Shift-JIS.csv';
a.href = URL.createObjectURL( blob );
a.textContent = 'download';
document.body.append( a );
// just to check we encoded it correctly
readAsText( blob, 'Shift-JIS' )
  .then( txt => console.log( 'read back as Shift-JIS:', txt ) );
readAsText( blob, 'utf-8' )
  .then( txt => console.log( 'read back as UTF-8:', txt ) );
  
function readAsText( blob, encoding ) {
  return new Promise( (res, rej) => {
    const reader = new FileReader();
    reader.onerror = rej;
    reader.onload = (evt) => res( reader.result );
    reader.readAsText( blob, encoding );
  } );
}

<script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/5.1.0/papaparse.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/encoding-japanese/1.0.30/encoding.min.js"></script>

​