topic Re: External library sheetjs wont load in Splunk javascript in Splunk Dev

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

joshiro — Thu, 07 Jul 2022 02:53:43 GMT

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.

Re: External library sheetjs wont load in Splunk javascript

fralcalde — Wed, 12 Jan 2022 14:10:31 GMT

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.