TypeError: Cannot read properties of undefined (reading 'writeFile') at writeFileAsync (xlsx.mjs:24045:13) #2895

New Issue

githubid0719 · 2023-02-26T14:45:22Z

githubid0719 commented

2023-02-26 14:45:22 +00:00

function downExcel(data, fileName) {
   import('xlsx').then(({writeFile, utils, writeFileAsync}) => {
    const wb = utils.book_new();
    const ws =  utils.json_to_sheet(data,  {skipHeader: false})
    utils.book_append_sheet(wb, ws);
    writeFileAsync(fileName, wb, ()=> {

    });
   }).catch(err=> {
      console.log('err', err)
   })
}

In the browser environment. When I call the writeFileAsync method to realize the asynchronous export of excel, he threw the following exception. Is it that I call incorrectly? How can I use the writeFileAsync method?

![image](uploading ...)

``` function downExcel(data, fileName) { import('xlsx').then(({writeFile, utils, writeFileAsync}) => { const wb = utils.book_new(); const ws = utils.json_to_sheet(data, {skipHeader: false}) utils.book_append_sheet(wb, ws); writeFileAsync(fileName, wb, ()=> { }); }).catch(err=> { console.log('err', err) }) } ``` In the browser environment. When I call the writeFileAsync method to realize the asynchronous export of excel, he threw the following exception. Is it that I call incorrectly? How can I use the writeFileAsync method? ![image](uploading ...)

sheetjs commented

2023-02-27 09:01:03 +00:00

Currently, writeFileAsync is only really relevant for NodeJS, as it uses fs.writeFile rather than fs.writeFileSync.

In the browser, if you want "asynchronous export", use a web worker. Check the worker demo https://docs.sheetjs.com/docs/demos/worker#creating-a-local-file and take a look at the live demo to see how to organize the export (the live demo uses a ReactJS component but the same works with "vanilla JS" or any framework)

Currently, `writeFileAsync` is only really relevant for NodeJS, as it uses `fs.writeFile` rather than `fs.writeFileSync`. In the browser, if you want "asynchronous export", use a web worker. Check the worker demo https://docs.sheetjs.com/docs/demos/worker#creating-a-local-file and take a look at the live demo to see how to organize the export (the live demo uses a ReactJS component but the same works with "vanilla JS" or any framework)

sheetjs closed this issue

2023-02-27 09:01:04 +00:00

Sign in to join this conversation.