Can't download excel file from api - xlsx/csv

Question

I return workbook as arraybuffer from api then trying to download on react side with blob.

It downloads file but csv file has bunch of numbers not the proper data.

Current Output

{ type: 'Buffer', data: [67,40,3,10....] }

-from api

  ....
 return await workbook.csv.writeBuffer()

-react side

const handleDownload = async() => {
    const response= await userHelper.getExcel()

    saveAs(new Blob([response?.data], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }), 'deneme.csv');
  }

Add `'Content-Type', 'text/csv'` to the header. Maybe it helps. — J.F., Jan 10 '23 at 14:49
You can modify the question title also, if you want to download CSV, not XLS/XLSX file. That way it can be easy for others to find this. — LucianDex, Jan 10 '23 at 14:59
it still downloads xlsx / csv file but content are just numbers ... — Fatih Can, Jan 10 '23 at 15:12
I tried convert to base64 on server. Now it returns random chars not the proper data :) — Fatih Can, Jan 10 '23 at 15:33

score 0 · Answer 1 · answered Jan 10 '23 at 15:36

Your response like ArrayBuffer, so please add responseType to config:

axios.get(
    "http://localhost:5000/folder.zip", //hosted with server
    { responseType: 'arraybuffer' }))
.then(res => {
      const file = new Blob([res], { type: 'text/csv' }
      let url = URL.createObjectURL(file);
      let a = document.createElement('a');
      a.href = url;
      a.download = 'deneme.csv';
      a.click();
      window.URL.revokeObjectURL(url);
});

Hope that it helps

Can't download excel file from api - xlsx/csv

1 Answers1