Excel data to array

by Ankit Patidar

HTML

<p>Paste excel data here:</p>
<textarea id="pastein" name="excel_data" style="width:250px;height:150px;"></textarea><br>
<input type="button" onclick="javascript:generateTable()" value="Genereate Table"/>
<br><br>
<p>Table data will appear below</p>
<hr>
<div id="excel_table"></div>

JavaScript

function removeExtraTabs(string){
	return string.replace(new RegExp("\t\t", 'g'), "\t");
}

function generateTable(){
  var data = removeExtraTabs($('#pastein').val());
  var rows = data.split("\n");
	var tempObj = "";
  var rowArr = [];
  for(var y in rows){
    rows[y] = removeExtraTabs(rows[y]);
    var cells = rows[y].split("\t");
    for(var x in cells){
      if(cells[x] !== ""){
      	rowArr.push(cells[x]);
      }
    }
  }
  tempObj = rowArr;
  console.warn(tempObj)
}