Read Excel file via Apex/JS then display it in a Datatable
I am new to Salesforce development world so please bear with me. my client wants to upload an excel file (filled with existing contact records), read the data using apex/js, then display it in a datatable either via flow or LWC. I don’t know how I can parse that excel data into Json or string. My company is not allowing me to download or install any node js or sheet library. I tried creating an LWC component that can upload file and read the excel file (I used a script then import it as a static resource), but I am not sure if it working. Please help. See code below: