Just Calling .Quit() will not remove the Application from memory. It is very important to close the objects after you are done with your coding. This ensures that all objects are released properly and nothing remains in the memory. See this example Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 ‘~~> Define your Excel Objects Dim … Read more
Below Function converts the Excel sheet (XLSX format) data to JSON. you can add promise to the function. <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> <script> var ExcelToJSON = function() { this.parseExcel = function(file) { var reader = new FileReader(); reader.onload = function(e) { var data = e.target.result; var workbook = XLSX.read(data, { type: ‘binary’ }); workbook.SheetNames.forEach(function(sheetName) { … Read more