StackAsk is a community where developers ask questions, share answers and learn from each others real-world experience, so every solved problem helps the next person who runs into it.
<span><<span>script</span> <span>src</span>=<span>"https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"</span>></span><span></span><span></<span>script</span>></span> <span><<span>script</span> <span>src</span>=<span>"https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"</span>></span><span></span><span></<span>script</span>></span> <span><<span>script</span>></span><span> <span>var</span> ExcelToJSON = <span><span>function</span>(<span></span>) </span>{ <span>this</span>.parseExcel = <span><span>function</span>(<span>file</span>) </span>{ <span>var</span> reader = <span>new</span> FileReader(); reader.onload = <span><span>function</span>(<span>e</span>) </span>{ <span>var</span> data = e.target.result; <span>var</span> workbook = XLSX.read(data, { <span>type</span>: <span>'binary'</span> }); workbook.SheetNames.forEach(<span><span>function</span>(<span>sheetName</span>) </span>{ <span>// Here is your object</span> <span>var</span> XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]); <span>var</span> json_object = <span>JSON</span>.stringify(XL_row_object); <span>console</span>.log(json_object); }) }; reader.onerror = <span><span>function</span>(<span>ex</span>) </span>{ <span>console</span>.log(ex); }; reader.readAsBinaryString(file); }; }; </span><span></<span>script</span>></span>
2.2K Point(s)
1.2K Point(s)
313 Point(s)
178 Point(s)
138 Point(s)
Input your email to receive reset password link, or if you remember your password, you can click