How client download excel file implement

[nvcken]

My server code
var file = fs.readFileSync('./res_report/output/out.xlsx', 'binary');
res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
res.setHeader('Content-Disposition', "attachment; filename=" + "out.xlsx")
res.end(file, 'binary');
How client javascript download excel file

[functionscope]

try

window.open(replaceWithYourUrl);

On Mon, Sep 29, 2014 at 4:49 AM, nvcken [email protected] wrote:

My server code
var file = fs.readFileSync('./res_report/output/out.xlsx', 'binary');
res.setHeader('Content-Type',
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
res.setHeader('Content-Disposition', "attachment; filename=" + "out.xlsx")
res.end(file, 'binary');
How client javascript download excel file

—
Reply to this email directly or view it on GitHub
#20.

[nvcken]

@functionscope
var file = fs.readFileSync('./res_report/output/out.xlsx', 'binary');
res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
res.setHeader('Content-Disposition', "attachment; filename=" + "out.xlsx")
res.end(file, 'binary');
client I use POST method request to server and server response by above server code
My client code angularjs
$http.post('/abc/excel', post).success(function(data){
var blob = new Blob([data], {
type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
});
var objectUrl = URL.createObjectURL(blob);
window.open(objectUrl);
})
.error(function( data){
})

but not work, file open corrupt. What I am wrong

[nvcken]

If I do the same with csv file it work

[functionscope]

check out this link

http://stackoverflow.com/questions/22447952/angularjs-http-post-convert-binary-to-excel-file-and-download

On Sep 29, 2014 7:57 AM, "nvcken" [email protected] wrote:

If I do the same with csv file it work

—
Reply to this email directly or view it on GitHub.

[rajan-g]

Hi, Me also meet this issue after spent long time I found solution, It is working for me.
setup's
1.convert your file as base64 string and send as response
EXAMPLE:
var result = nodeExcel.execute(conf);
return res.status(200).send(new Buffer(result.toString(), 'binary').toString('base64'));
2.client side decodebase64 string, make as blob and create url from blob
EXAMPLE:
var contentType = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
var sliceSize = sliceSize || 512;

                var byteCharacters = atob(data);
                var byteArrays = [];

                for (var offset = 0; offset < byteCharacters.length; offset += sliceSize) {
                  var slice = byteCharacters.slice(offset, offset + sliceSize);

                  var byteNumbers = new Array(slice.length);
                  for (var i = 0; i < slice.length; i++) {
                    byteNumbers[i] = slice.charCodeAt(i);
                  }
                  var byteArray = new Uint8Array(byteNumbers);

                  byteArrays.push(byteArray);
                }
                var blob = new Blob(byteArrays, {type: contentType});
                var blobUrl = URL.createObjectURL(blob);
                window.location = blobUrl;

Enjoy