Export javascript data to CSV file without server interaction -


if on nodejs server, write header, set mime type, , send it:

res.header("content-disposition", "attachment;filename="+name+".csv");  res.type("text/csv"); res.send(200, csvstring);

and because of headers, browser create download named csv file.

when useful data generated in browser, 1 solution getting in csv file use ajax, upload server, (perhaps optionally save there) , server send these headers become csv download @ browser.

however, 100% browser solution not involve ping-pong server.

so occurred me 1 open new window , try set header meta tag equivalent.

but doesn't work me in recent chrome.

i new window, , contains csvstring, not act download.

i guess expected either download in bottom tab or blank new window download in bottom tab.

i'm wondering if meta tags correct or if other tags needed.

is there way make work without punting server?

jsfiddle creating csv in browser (not working - outputs window no download)

var = [['n','sqrt(n)']];  // initialize array of rows header row 1st item for(var j=1;j<10;++j){ a.push([j, math.sqrt(j)]) } var csvrows = []; for(var i=0,l=a.length; i<l; ++i){     csvrows.push(a[i].join(','));   // unquoted csv row } var csvstring = csvrows.join("\n"); console.log(csvstring); var csvwin = window.open("","",""); csvwin.document.write('<meta name="content-type" content="text/csv">'); csvwin.document.write('<meta name="content-disposition" content="attachment;  filename=data.csv">  '); csvwin.document.write(csvstring);

there's html5 download attribute :

this attribute, if present, indicates author intends hyperlink used downloading resource when user clicks on link prompted save local file.

if attribute has value, value used pre-filled file name in save prompt opens when user clicks on link. 

var = [['n','sqrt(n)']];  for(var j=1; j<10; ++j){      a.push([j, math.sqrt(j)]); }  var csvrows = [];  for(var i=0, l=a.length; i<l; ++i){     csvrows.push(a[i].join(',')); }  var csvstring = csvrows.join("%0a"); var         = document.createelement('a'); a.href        = 'data:attachment/csv,' +  encodeuricomponent(csvstring); a.target      = '_blank'; a.download    = 'myfile.csv';  document.body.appendchild(a); a.click();

fiddle

tested in chrome , firefox, works fine in newest versions (as of july 2013).
works in opera well, not set filename (as of july 2013).
not seem work in ie9 (big suprise) (as of july 2013).

an overview on browsers support download attribute can found here
non-supporting browsers, 1 has set appropriate headers on serverside.

apparently there a hack ie10 , ie11, doesn't support download attribute (edge however). 

var = [['n','sqrt(n)']];  for(var j=1; j<10; ++j){      a.push([j, math.sqrt(j)]); }  var csvrows = [];  for(var i=0, l=a.length; i<l; ++i){     csvrows.push(a[i].join(',')); }  var csvstring = csvrows.join("%0a");  if (window.navigator.mssaveoropenblob) {     var blob = new blob([csvstring]);     window.navigator.mssaveoropenblob(blob, 'myfile.csv'); } else {     var         = document.createelement('a');     a.href        = 'data:attachment/csv,' +  encodeuricomponent(csvstring);     a.target      = '_blank';     a.download    = 'myfile.csv';     document.body.appendchild(a);     a.click(); }

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more