javascript - Displaying CSV Headers using PapaParse Plugin - Stack Overflow

admin管理员组

文章数量:1344219

I am using the PapaParse plugin for csv files. I have this function below that creates a table to display the CSV results.

function handleFileSelect(evt) {
var file = evt.target.files[0];

Papa.parse(file, {
  header: true,
  dynamicTyping: true,
  plete: function(results) {

    $.each(results.data, function(i, el) {
        var row = $("<tr/>");
        row.append($("<td/>").text(i));
        $.each(el, function(j, cell) {
                row.append($("<td/>").text(cell));
        });
        $("#results tbody").append(row);
    });


  }
  });

}

Even with header:true set, I can not seem to get the headers to show up in the table but the rest displays perfectly.

And to be honest, I found this script online and am having trouble even understanding how it is working.

Any ideas? Thank you in advance!

I am using the PapaParse plugin for csv files. I have this function below that creates a table to display the CSV results.

function handleFileSelect(evt) {
var file = evt.target.files[0];

Papa.parse(file, {
  header: true,
  dynamicTyping: true,
  plete: function(results) {

    $.each(results.data, function(i, el) {
        var row = $("<tr/>");
        row.append($("<td/>").text(i));
        $.each(el, function(j, cell) {
                row.append($("<td/>").text(cell));
        });
        $("#results tbody").append(row);
    });


  }
  });

}

Even with header:true set, I can not seem to get the headers to show up in the table but the rest displays perfectly.

And to be honest, I found this script online and am having trouble even understanding how it is working.

Any ideas? Thank you in advance!

• javascript
• jquery
• json
• csv
• papaparse

Share Improve this question Follow asked Oct 27, 2014 at 21:50 VIDesignzVIDesignz 4,78333 gold badges3030 silver badges3838 bronze badges 1

• 1 Enabling header row support simply keys data on every row by the field name. Without header row, the data is returned as an array of arrays, so you would access values numerically. With header row, though, data is an array of objects, and the first row is consumed as the header row, not as part of the data. – Matt Commented Oct 28, 2014 at 4:30

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 8

Well, I figured it out...

The header titles were contained within a different object. results.meta['fields']

This is how I am printing the results from papa parse.

$.each(results.meta['fields'], function(i) {
    $("#headers").append($("<td/>").text(results.meta['fields'][i]));
});

try using header:false, it'll display the header as array.

本文标签： javascriptDisplaying CSV Headers using PapaParse PluginStack Overflow