This demo uses SheetJS with HTML, Javascript to implement the below functionality
-
Phase 1
- Import existing Excel sheet
- Update its cell values using values entered in HTML input form fields
- Export (Download) the modified Excel sheet
-
Phase 2
- Import the Excel sheet (existing sheet or modified and downloaded from previous step)
- Fetch specific cell values from Excel sheet and list it in the HTML table fields.
Screenshot 1 (landing page) Screenshot 2 (Changed input fields, updated cell values of excel sheet, downloaded updated sheet, uploaded the modified excel sheet to output)