Download Excel file using jquery ajax

Question

Hi i want to download XLX file using spring mvc ajax call.Below is my ajax call to server.

 $.ajax({
    type : 'GET',
    url : 'downloadExcel',
    beforeSend : function() {
        startPreloader();
    },
     complete: function(){
         stopPreloader();
     },
    success : function(response){
        console.log(response);
            var blob = new Blob([response], { type: 'application/vnd.ms-excel' });
            var downloadUrl = URL.createObjectURL(blob);
            var a = document.createElement("a");
            a.href = downloadUrl;
            a.download = "downloadFile.xlsx";
            document.body.appendChild(a);
            a.click();
    }
});

Here is my server code

@RequestMapping(value = "/downloadExcel", method = RequestMethod.GET)
    @ResponseBody
    public List<LicenceType> downloadExcel() {
        return licenceTypeService.findAllLicenceType();
    }

My code actually download the excel file, but on the excel sheet it showing like [Object][Object]

Answer 1

I know it's been almost a year but it worked for me with this:

var blob = new Blob([response], { type: 'data:application/vnd.ms-excel' });