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!
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]));
});
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With