Posts

Showing posts from May, 2019

How To Read Excel Sheet Data In JavaScript

Upload Excel File(XLSX or XLS) Then Open Your Console To See Result . ------------------------Source Code-------------------------- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"></script> <input type="file" id="my_file_input" /> <div id='my_file_output'></div> <script> var oFileIn; $(function() {     oFileIn = document.getElementById('my_file_input');     if(oFileIn.addEventListener) {         oFileIn.addEventListener('change', filePicked, false);     } }); function filePicked(oEvent) {     // Get The File From The Input     var oFile = oEvent.target.files[0];     var sFilename = oFile.name;     // Create A File Reader HTML5