Unable to download the .xls file from chrome browser using jquery

Question

Able to download the file .xls in Firefox browser using below script code.

window.open(/api/v1/test/id);

Able to download pdf,image extensions like jpg,jpeg etc.. Unable to download the .xls file in chrome browser using above script.

Please help to resolve this issue.

http://stackoverflow.com/questions/4144062/display-xls-file-data-in-a-browser-as-a-web-content — Johnny Mopp, Aug 24 '15 at 13:00
Please check in your machine whether default zip format is used? . Using in windows or linux env? — javapointdotcom, Aug 24 '15 at 13:11
working on linux env. Where I have to check zip format is used as default? — newtonash, Aug 24 '15 at 13:13
Using window.open(url) for opening the .xls file in new window. — newtonash, Aug 24 '15 at 13:25

score 0 · Answer 1 · answered Aug 24 '15 at 15:45

Make sure that you set the Content-Type correctly at the server side.

For example, in Node for Excel 2007 and above .xlsx files

response.writeHead(200, {"Content-Type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});

Chrome is probably interpreting your content as application/zip

response.writeHead(200, {"Content-Type": "application/zip"});

Here is an example of an xlsx being served up in Chrome when accessing localhost:1215

  var http = require("http");
  fileSystem = require('fs'),
  path = require('path');
  var server = http.createServer(function(request, response) {

  var filePath = path.join(__dirname, '1775IronHorse.xlsx');
  var stat = fileSystem.statSync(filePath);
  response.writeHead(200, { "Content-Type": "application/vnd.openxmlformats-    officedocument.spreadsheetml.sheet",
                            'Content-Length': stat.size
                            });
  var readStream = fileSystem.createReadStream(filePath);
  readStream.pipe(response);
});

server.listen(1215);
console.log("Server is listening");

The file downloads correctly as an xlsx.

When I remove the Content-Type Header the file is interpreted as zip file by Chrome. Therefore, the solution is to add the Content-Type Header.

Source

Unable to download the .xls file from chrome browser using jquery

1 Answers1