README.md

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

• SheetJS
• xlsx
• Heroku
• SalesforceLabs - ExcelUpload
• Fetch API

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

• Salesforce Extensions Documentation
• Salesforce CLI Setup Guide
• Salesforce DX Developer Guide
• Salesforce CLI Command Reference