如何使用javascript从* .CSV文件读取数据？ [英] How to read data From *.CSV file using javascript?

问题描述

我的csv数据如下所示：

My csv data looks like this:

heading1，heading2，heading3，heading4，heading5，value1_1，value2_1，value3_1，value4_1， value5_1，value1_2，value2_2，value3_2，value4_2，value5_2 ....

heading1,heading2,heading3,heading4,heading5,value1_1,value2_1,value3_1,value4_1,value5_1,value1_2,value2_2,value3_2,value4_2,value5_2....

如何读取此数据并转换为类似的数组这使用Javascript？：

How do you read this data and convert to an array like this using Javascript?:

[heading1：value1_1，heading2：value2_1，heading3：value3_1，heading4
：value4_1，heading5： value5_1]，[heading1：value1_2，
heading2：value2_2，heading3：value3_2，heading4：value4_2，heading5
：value5_2] ....

[heading1:value1_1 , heading2:value2_1, heading3 : value3_1, heading4 : value4_1, heading5 : value5_1 ],[heading1:value1_2 , heading2:value2_2, heading3 : value3_2, heading4 : value4_2, heading5 : value5_2 ]....

我试过这段代码但没有运气！：

I've tried this code but no luck!:

<script type="text/javascript">
    var allText =[];
    var allTextLines = [];
    var Lines = [];

    var txtFile = new XMLHttpRequest();
    txtFile.open("GET", "file://d:/data.txt", true);
    txtFile.onreadystatechange = function()
    {
        allText = txtFile.responseText;
        allTextLines = allText.split(/\r\n|\n/);
    };

    document.write(allTextLines);<br>
    document.write(allText);<br>
    document.write(txtFile);<br>
</script>

推荐答案

注意：我炮制在我被提醒有关CSV文件中可能出现的所有特殊情况（如转义引号）之前，此解决方案。我想给那些想要快速和肮脏的东西的人留下我的答案，但为了准确，我建议 Evan的回答。

NOTE: I concocted this solution before I was reminded about all the "special cases" that can occur in a valid CSV file, like escaped quotes. I'm leaving my answer for those who want something quick and dirty, but I recommend Evan's answer for accuracy.

当您的 data.txt 文件是一个长字符串时，此代码将起作用逗号分隔的条目，没有换行符：

This code will work when your data.txt file is one long string of comma-separated entries, with no newlines:

data.txt：

 heading1,heading2,heading3,heading4,heading5,value1_1,...,value5_2

javascript ：

javascript:

$(document).ready(function() {
    $.ajax({
        type: "GET",
        url: "data.txt",
        dataType: "text",
        success: function(data) {processData(data);}
     });
});

function processData(allText) {
    var record_num = 5;  // or however many elements there are in each row
    var allTextLines = allText.split(/\r\n|\n/);
    var entries = allTextLines[0].split(',');
    var lines = [];

    var headings = entries.splice(0,record_num);
    while (entries.length>0) {
        var tarr = [];
        for (var j=0; j<record_num; j++) {
            tarr.push(headings[j]+":"+entries.shift());
        }
        lines.push(tarr);
    }
    // alert(lines);
}

以下代码适用于真正的CSV文件，每个文件之间有换行符记录集：

The following code will work on a "true" CSV file with linebreaks between each set of records:

data.txt：

heading1,heading2,heading3,heading4,heading5
value1_1,value2_1,value3_1,value4_1,value5_1
value1_2,value2_2,value3_2,value4_2,value5_2

javascript：

javascript:

$(document).ready(function() {
    $.ajax({
        type: "GET",
        url: "data.txt",
        dataType: "text",
        success: function(data) {processData(data);}
     });
});

function processData(allText) {
    var allTextLines = allText.split(/\r\n|\n/);
    var headers = allTextLines[0].split(',');
    var lines = [];

    for (var i=1; i<allTextLines.length; i++) {
        var data = allTextLines[i].split(',');
        if (data.length == headers.length) {

            var tarr = [];
            for (var j=0; j<headers.length; j++) {
                tarr.push(headers[j]+":"+data[j]);
            }
            lines.push(tarr);
        }
    }
    // alert(lines);
}

http://jsfiddle.net/mblase75/dcqxr/

这篇关于如何使用javascript从* .CSV文件读取数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！