[SOLVED] Export as Excel/CSV

help
21

In my download button events I have something like:

    var link = window.document.createElement("a");

    link.setAttribute("href", "data:text/csv;charset=utf-8,%EF%BB%BF" + encodeURI(csv));
    link.setAttribute("download", "export_invoices_" + fileName + ".csv");
    link.click();

the variable csv is comma separate string.

2 Likes
22

I figured out how to achieve this with Papa Parse. Worked so great that I decided to write a tutorial about it. Comes with a repo and an online demo if you want see how it will look. Hope it can help anyone.

4 Likes
23

Parfait.
Nice work.
Nicely explanation

24

I found the easiest fix via BOM; just add the magic at beginning of the string, when creating the buffer for the file export:

let buffer = Buffer('\ufeff'+csvString)

25

Thanks, KENKEN ā€¦ Great.
I can see correct CSV content with format font on Excell

1 Like
26

Did you find a solution? Iā€™m also having trouble with the excel format.