Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Displaying CSV Headers using PapaParse Plugin

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,
  complete: 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!

like image 858
VIDesignz Avatar asked Oct 27 '14 21:10

VIDesignz


1 Answers

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]));
});
like image 73
VIDesignz Avatar answered Nov 16 '22 12:11

VIDesignz