Why won't External library sheetjs load in Splunk javascript?

[joshiro]

Hi, we're trying to import sheetjs into a custom SplunkJS script so we can export some results into xlsx.
Tried to add it in the required section at the begining of the script but is not working.

require([
    "splunkjs/mvc",
    "<path to xlsx.full.min.js>",
    "splunkjs/mvc/searchmanager",
    "splunkjs/mvc/simplexml/ready!"
    ], function(
        mvc,
        XLSX,
        SearchManager)
    {
        console.log(XLSX.version);
    }
);

 
Here is the sheetjs documentation: https://github.com/SheetJS/sheetjs
Any help ll be appreciated.

Regards.

Javier.

[fralcalde · Accepted solution]

After several hours of trial and error we managed to get sheetjs to work in a dashboard script with requirejs.

The solution was to set the require.config settings like follows:

require.config({
    paths: {
        'xlsx': '/static/app/my_app/sheetjs/dist/xlsx.full.min'
    }
});

 
And then load it:

require([
    "splunkjs/mvc",
    "splunkjs/mvc/searchmanager",
    "xlsx",
    "splunkjs/mvc/simplexml/ready!"
    ], function(
            mvc,
            SearchManager)
    {
        console.log(XLSX.version);  
    }
);

I am new to requirejs and javascript in general, but this way it worked. If anyone cares to explain why, we thank you.