I am trying to import an Excel file from static resources. But it's not working. The same method is working for JS files. Note the excel file is in xlsm format. Please help.


import { LightningElement, wire } from 'lwc';
import { loadScript } from "lightning/platformResourceLoader";
import workbook from "@salesforce/resourceUrl/xlsx";
import excelTemplate from "@salesforce/resourceUrl/ExcelTemplate";
import getaccounts from '@salesforce/apex/AccountController.getAccountLists';
import CV from '@salesforce/apex/ContentVersionController.getContentVersion';

export default class SheetJSLearning extends LightningElement {

    librariesLoaded = false;
    accountdata = [];

    connectedCallback() {
        if (this.librariesLoaded) return;
        this.librariesLoaded = true;

        Promise.all([loadScript(this, workbook + "/xlsx/xlsx.full.min.js")])
            .then(() => {
                this.XLSX = window.XLSX;
            .catch(error => {

    async handleClick() {

        try {

            // sfdxfox code
            let response = await fetch(excelTemplate);
            let excelTemplateData = await response.blob();
            // sfdxfox code

            let returnVal = await CV();
            let accdata = await getaccounts();

            //In the below line, replaced returnVal with excelTemplateData
            var wb = this.XLSX.read(returnVal, { type: 'base64', WTF: true, bookVBA: true, cellStyles: true });

            var ws = wb.Sheets[wb.SheetNames[0]];

            XLSX.utils.sheet_add_aoa(ws, accdata.map(obj => [obj.Id, obj.Name, obj.CleanStatus, '=' + obj.Name]), { origin: "A2" });

            this.XLSX.writeFile(wb, "myFile.xlsm");

        } catch (err) {



enter image description here

1 Answer 1


First of all, to load the entire file, you just use the resourceUrl without anything beyond the path. Secondly, you can only load JavaScript files with loadScript. If you want to use the file for other purposes, just fetch it:

async myMethod() {
  let response = await fetch(excelTemplate);
  let excelTemplateData = await response.blob();

Note that xlsx files are ZIP files, so you'll need a method to decompress the file before you can use it programmatically. If you just want to have the user download the file, you can use the excelTemplateData as a createObjectURL parameter, then use it as the src of an a tag to download the contents.

  • @sfdxfox - Thank you for the explanation. I now understand we cannot import excel files using loadscript. However, in my usecase, using fetch method its not working. I am trying to read the file using SheetJS external library. let response = await fetch(excelTemplate); let excelTemplateData = await response.blob(); var wb = this.XLSX.read(excelTemplateData, { type: 'base64', WTF: false, bookVBA: true, cellStyles: true }); Mar 22 at 6:10
  • @PraveenBehera Do you have any error messages or anything? How far have you gotten? How are you loading SheetJS? What is XLSX being loaded from?
    – sfdcfox
    Mar 22 at 6:14
  • @sfdxfox - I have added the full JS code so that you can see it. Currently I am reading the file from the VersionData field of ContentVersion Object which works fine. But I want to read it from Static resource. Mar 22 at 7:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .