Component, which allows you to import excel (.xlsx) documents and get their content in lightning component. Based on the XLSX.js library.

Use it, when you need your user to import .xlsx files and use its content in you lightning component and/or apex class.

To use this component, simply include it in your markup and handle the import event.

<aura:component>
    ...
    <c:ExcelImport onImport="{!c.myImportHandlingFunction}"/>
    ...
</aura:component>

ExcelImport renders into a file lightning:input component with additional handling for Excel table files.

onImport event is a component-level event, which has this attributes:

To handle onImport event and get the parsed table object simply use event parameters:

{
    ...
    myImportHandlingFunction: function(component, event, helper) {
        let eventType = event.getParam("type");
        if (eventType === "SUCCESS") {
            console.log(event.getParam("fileName"));
            console.log(event.getParam("table"));
        }
        if (eventType === "ERROR") {
            console.log(event.getParam("message"));
        }
    }
    ...
})

• Make input support any type of file, processing tables only
• Improve error handling
• (?) change some of the attributes

MIT