/excel-file-upload-lwc

Read & Parse Excel documents with sheetjs and LWC natively or send to an Heroku app for parsing.

Primary LanguageJavaScript

Excel File Upload

Sample application for uploading and parsing Excel documents using "sheetjs" natively with LWC and an alternative solution using Heroku App for nodejs/express based parsing.

Note - You need to update any Heroku URLS to match your own Heroku Apps i.e. https://radiant-hamlet-82916.herokuapp.com

Resources

excelToJsonStatic LWC

Simple LWC with file upload which uses "sheetjs" static resource for parsng (based on ExcelUpload repo). Parses uploaded excel document and returns JSON.

excelToJson LWC

Simple LWC with file upload and send to Heroku App based on Fetch API. POST to endpont on Heroku for parsing and returns JSON response.

testHeroku LWC

Simple LWC for testing callout to Heroku using Fetch API.

Read All About It