javascript - 从 Meteor.js 集合创建 CSV 文件

Question

到目前为止，我已经编写了我的代码，并且可以获得要显示在网页上的所有记录的列表，但是我需要能够将其作为 CSV(逗号分隔值)文件来获取。

现在页面显示如下列表:

Name      Address      Description
Bob       1 street     Journalist
Bill      2 street     Fireman
etc...

无论如何，我可以让 meteor 创建一个 CSV 文件以供下载，而不是显示为带有所有 HTML 标记的网页？

Answer 1

基于 How to serve a file using iron router or meteor itself?

HTML:

<template name="blah">
  <a href="{{pathFor 'csv'}}">Download the CSV</a>
</template>

JS:

// An example collection
var DummyData = new Mongo.Collection("dummyData");

// create some sample data
if (Meteor.isServer) {
  Meteor.startup(function() {
    var dummyDataCursor = DummyData.find();
    if (dummyDataCursor.count() === 0) {
      for(var i=1; i<=100; i++) {
        DummyData.insert({Name: "Name" + i,Address: "Address" + i, Description:"Description" + i});
      }
    }
  });
}

Router.route('/csv', {
  where: 'server',
  action: function () {
    var filename = 'meteor_dummydata.csv';
    var fileData = "";

    var headers = {
      'Content-type': 'text/csv',
      'Content-Disposition': "attachment; filename=" + filename
    };
    var records = DummyData.find();
    // build a CSV string. Oversimplified. You'd have to escape quotes and commas.
    records.forEach(function(rec) {
      fileData += rec.Name + "," + rec.Address + "," + rec.Description + "\r\n";
    });
    this.response.writeHead(200, headers);
    return this.response.end(fileData);
  }
});