Posts

Showing posts from 2020

Convert Excel data into JSON using JavaScript

Image
This blog explains you how we can convert a JSON  from an uploaded Excel file to the browser.  Please follow the below steps to covert excel to json The first thing is getting the excel file from the user. We can do it using the  <input>  tag in HTML. It shows below. ( <input type=”file” id=”fileUploader” name=”fileUploader” accept=”.xls, .xlsx”/> ) Next we have to define what we are going to do when user upload the file. For that we are going to use the  change  event of the element above.   This is the important part. Now we are going to define what we want to do with the file uploaded. First, we have to read the file uploaded. In here we make an assumption that the user only uploading a one file. Next we are going to read that file data using a  FileReader.  From this FileReader we can read the data in our excel file as a binary string. Then we use  XLSX  which an inbuilt facility of  SheetJS js-xlsx  to convert our binary string into a JSON object. To use