我正在使用Papa Parse JavaScript库将JSON对象数组转换为CSV。有没有一种方法可以以某种方式排列CSV列。

例如我得到的列为:

OrderStatus,canOp,OpDesc,ID,OrderNumber,FinishTime,UOM,StartTime

但希望安排为:

ID,OrderNumber,OrderStatus,StartTime,FinishTime,canOp,OpDesc,UOM

之所以无法获得CSV,是因为JSON数据如下所示:

json = [
{
    OrderStatus: "Good",
    canOp:"True",
    OpDesc:"Good to go",
    ID:"100",
    OrderNumber:"1000101",
    FinishTime:"20:50",
    UOM:"K",
    StartTime:"18:10"
},
...
]

谢谢

最佳答案

Papa Parse允许在unparse()函数中指定字段的顺序:

var csv = Papa.unparse({
  fields: ["ID", "OrderNumber", "OrderStatus", "StartTime", "FinishTime", "canOp", "OpDesc", "UOM"],
  data: [{
      OrderStatus: "Good",
      canOp: "True",
      OpDesc: "Good to go",
      ID: "100",
      OrderNumber: "1000101",
      FinishTime: "20:50",
      UOM: "K",
      StartTime: "18:10"
    },
    // ...
  ]
});

console.log(csv);
<script src="https://unpkg.com/papaparse@4.6.3/papaparse.min.js"></script>
<h3>See your dev console for the results</h3>

07-28 01:28
查看更多