Performing operations on excel sheets in a web application is a very common thing. There may be some scenarios where you want to upload excel sheets and get JSON structured data in return to perform operations of your choice. I’ve recently created a plugin using SheetJs library.
Give it a try – Convert Excel to JSON
All you have to do is upload your excel sheet, give the worksheet number and taddaaa, its done. At this moment, you can’t generate JSON for multiple worksheets in a single go. You have to do this one by one. On successful operation, the returned JSON data will contain columns as key and rows as their values.
Give it a try, if you face any issues, do let me know in the comment section. The source code is available on GitHub under MIT license.
