javascript - Tabulator: Download Error - No such download type found

Question

Would like to ask for some help I am currently using Tabulator (4.9) along with Vue. I am having trouble downloading/exporting my data to Excel. I have already included SheetJS on my project as stated from Tabulator's page.

The following gives me an error that the XLSX is not defined:

import 'xlsx/dist/xlsx.full.min.js'
this.tabulator.download('xlsx', 'data.xlsx')

But once I include the XLSX, then it tells me "Download Error - No such download type found":

import XLSX from 'xlsx/dist/xlsx.full.min.js'
this.tabulator.download(XLSX, 'data.xlsx')

Would really like to know if I am missing something.

Thanks.

question from:https://stackoverflow.com/questions/65883023/tabulator-download-error-no-such-download-type-found

Answer 1

Your first approach is correct, you should be calling the download function and passing in the xlsx string

this.tabulator.download('xlsx', 'data.xlsx');

The issue is that Tabulator is expecting to find the XLSX object on the window object (or global object if this is a node project) as that is where the library is put when pulled in from the CDN.

So in you case your import should be:

import XLSX from 'xlsx/dist/xlsx.full.min.js';
window.XLSX = XLSX;