xls String to Array in JavaScript

Question

String.prototype.splitCSV = function(sep) {
  for (var foo = this.split(sep = sep || ","), x = foo.length - 1, tl; x >= 0; x--) {
    if (foo[x].replace(/"\s+$/, '"').charAt(foo[x].length - 1) == '"') {
      if ((tl = foo[x].replace(/^\s+"/, '"')).length > 1 && tl.charAt(0) == '"') {
        foo[x] = foo[x].replace(/^\s*"|"\s*$/g, '').replace(/""/g, '"');
      } else if (x) {
        foo.splice(x - 1, 2, [foo[x - 1], foo[x]].join(sep));
      } else foo = foo.shift().split(sep).concat(foo);
    } else foo[x].replace(/""/g, '"');
  } return foo;
};

this code is convert csv string to array. my question is that how to convert xls and tsv string to array?

you need to append the javascript tag to this, also put it in proper code segments — Fallenreaper
– Fallenreaper, Commented Jan 15, 2014 at 19:11

agershun · Accepted Answer · 2014-12-21 07:37:29Z

1

You can look at Alasql's CSV parser, which can convert CSV and TSV strings to array:

CSV and TSV parsers code (sorry, I cannot put all code her because of size)

Or you can use Alasql to load data from CSV, TSV, XLS, or XLSX files directly to JavaScript:

alasql('SELECT * FROM XLSX("mydata.xlsx")',[], function(res){ 
    // do something
});

alasql('SELECT * FROM TSV("mydata.tsv", {headers:true})',[], function(res){ 
    // do something
});

answered Dec 21, 2014 at 7:37

agershun

4,10742 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

xls String to Array in JavaScript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related