how to convert blob data to downloadable excel/CSV file in react js

Question

i am getting a blob from the Get API with response shown here logic to create file like so after getting the response.

const url = URL.createObjectURL(new Blob([result], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }))
      const link = document.createElement('a');
      link.href = url;
      link.innerText = 'Open the array URL';
      link.setAttribute('download', 'myExcel.xlsx');
      link.click();

its creating corrupted excel file.

Answer 1

create headers like this

const headers = {Accept: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",};

and the your request in axios

Axios.get("my-api/stream", { responseType: 'blob',headers });

Answer 2

I think you should try to use FileSaver package.

Answer 3

You can use like this:

saveAs(new Blob([result], {type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'}), 'myExcel.xlsx');