ahgood · August 31, 2016 02:24 · ahgood · Aug 30, 2016
diff --git a/HTML5ParseXLS.html b/HTML5ParseXLS.html
 <!DOCTYPE html>
 <html lang="en">
 <head>
 	<meta charset="UTF-8">
 	<title>Drag &amp; Drop Upload and Parse Spreadsheet(xls, xlsx)</title>
 </head>
 <body>

 <style>
 #dropZone {
 	width:  400px;
 	height: 100px;
 	background-color: #eee;
 	border: 1px solid #ccc;
 	margin-bottom: 20px;
 	padding: 10px;
 }
 </style>

 <div id="dropZone" ondrop="drop_handler(event)" ondragover="dragover_handler(event)">Drop Zone</div>

 <script src="dist/xlsx.core.min.js"></script>
 <script>
 var workbook;

 function dragover_handler(e) {
 e.preventDefault();
 e.dataTransfer.dropEffect = "move"
 }

 function drop_handler(e) {
 	e.preventDefault();
 	var files = e.dataTransfer.files;
 	var i,f;
 	for (i = 0, f = files[i]; i != files.length; ++i) {
 	  var reader = new FileReader();
 	  var name = f.name;
 	  reader.onload = function(e) {
 	    var data = e.target.result;
 	    workbook = XLSX.read(data, {type: 'binary'});
 	    var worksheet = workbook.Sheets[workbook.SheetNames[0]];
 	    //Get the value of A1 cell
 	    console.log(worksheet['A1'].v);
 	  };
 	  reader.readAsBinaryString(f);
 	}
 }
 </script>

 </body>
 </html>
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>Drag & Drop Upload and Parse Spreadsheet(xls, xlsx)</title>
	</head>
	<body>

	<style>
	#dropZone {
	width: 400px;
	height: 100px;
	background-color: #eee;
	border: 1px solid #ccc;
	margin-bottom: 20px;
	padding: 10px;
	}
	</style>

	<div id="dropZone" ondrop="drop_handler(event)" ondragover="dragover_handler(event)">Drop Zone</div>

	<script src="dist/xlsx.core.min.js"></script>
	<script>
	var workbook;

	function dragover_handler(e) {
	e.preventDefault();
	e.dataTransfer.dropEffect = "move"
	}

	function drop_handler(e) {
	e.preventDefault();
	var files = e.dataTransfer.files;
	var i,f;
	for (i = 0, f = files[i]; i != files.length; ++i) {
	var reader = new FileReader();
	var name = f.name;
	reader.onload = function(e) {
	var data = e.target.result;
	workbook = XLSX.read(data, {type: 'binary'});
	var worksheet = workbook.Sheets[workbook.SheetNames[0]];
	//Get the value of A1 cell
	console.log(worksheet['A1'].v);
	};
	reader.readAsBinaryString(f);
	}
	}
	</script>

	</body>
	</html>