Question

50

Downloading a Dynamic CSV in Internet Explorer

rated 0 times [ 54] [ 4] / answers: 1 / hits: 16744 / 10 Years ago, tue, december 2, 2014, 12:00:00

The following code works in both FireFox and Chrome, but not IE. Essentially, I have a JSON object which gets converted into an array and then to a csv format, when I click the button in FF or Chrome the file gets downloaded or the Save As window opens, but in IE a new tab opens up. In a perfect world IE would not exists, but in the real world we have to make it work, lol.

$(#csvbtn).click(function(e){

    e.preventDefault();

    var  json_obj= JSON.parse(result);

    var csv = JSON2CSV(json_obj);

    window.open(data:text/csv;charset=utf-8, + escape(csv));

});

BTW, I am using IE 11 in windows 8 to test this, if that makes a difference.

Thanks all!

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

alli

Add To Favorites

Follow

Total Points: 409

Total Questions: 101

Total Answers: 105

Location: The Bahamas

Member since Tue, Apr 27, 2021

3 Years ago

alli questions

1 How do I add types to a Vite library build?

Sat, Apr 23, 22, 00:00, 2 Years ago

1 Discord.js Bot giveaway command : embedSent.reactions.get is not a function

Fri, May 29, 20, 00:00, 4 Years ago

1 Applying multiple filters to a table reactjs

Mon, May 18, 20, 00:00, 4 Years ago

1 Framer-motion, delay rotateY while animating x

Tue, Mar 24, 20, 00:00, 4 Years ago

1 Questions about useCallback hook and anonymous function

Fri, Jan 24, 20, 00:00, 4 Years ago

View All

answered 10 Years ago alanisannettep · Accepted Answer

This is my solution in case someone else is looking for a solution. now it works with FF, Chrome , and IE

var csv = JSON2CSV(json_obj);            

var blob = new Blob([csv],{type: text/csv;charset=utf-8;});



if (navigator.msSaveBlob) { // IE 10+

navigator.msSaveBlob(blob, csvname.csv)

    } else {

        var link = document.createElement(a);

        if (link.download !== undefined) { // feature detection

            // Browsers that support HTML5 download attribute

            var url = URL.createObjectURL(blob);

            link.setAttribute(href, url);

            link.setAttribute(download, csvname.csv);

            link.style = visibility:hidden;

            document.body.appendChild(link);

            link.click();

            document.body.removeChild(link);

        }           

    }

Now I just need to figure out if there is a way to have the save as screen pop up instead of automatically saving the file. If anybody knows the answer to that please share. For now my users will have to use this functionality.

Thanks all for all the great answers, you guys are awesome.