Angular2 download excel file

In short, the OP mistake was using responseType as a header. Instead one should use it in get options second argument, type: RequestOptionsArgs. Thank you all for your contribution. ContentDispositionHeaderValue "attachment" ; response. OK; return response;. I have to include FileSaver and it shows the icon to download or save the file. My backend is in spring. The idea of using simple xhr instead of angular's http helped me solve the issue.

Thank you guys. Hi All, I have been trying to download excel in IE 11 using angular and simple java script xhr request but am getting the file as corrupted only in IE 11 or Microsoft Edge. Chrome and Mozilla works fine. Any help would be appreciable. Researched on IE settings and also tried downloading excel from third party site in IE which works fine.

Below is the code snippet i have been using. Hi All I am able to figure out the issue and resolve it. In my Java service I have added content-length as response header which resolved the issue. Thanks for the nice article. AulonaBinaj In yours service remove this headers headers. It should resolve your issue and Filesaver should save your file.

And Response you attached is correct only. Add content-length header from ur business returning the response. Regards Soma. I tried this, also, I add FileSaver. AulonaBinaj I think your question is a different context.

My original file is. Yes this is a problem, I change it to test. This issue has been automatically locked due to inactivity. Please file a new issue if you are encountering a similar or related problem. Read more about our automatic conversation locking policy. Skip to content. Star New issue. Jump to bottom. Copy link. OK; response. GetBuffer ; response. Thanks… I will try to figure out something.

I was also considering looking for some public API like federal gov statistics or similar that returns a spreadsheet, but all I could find so far returns JSON. Here are both methods. Open, FileAccess. GetBuffer ; httpResponseMessage. Add "x-filename", fileName ; httpResponseMessage.

Length; httpResponseMessage. I have simply this:. Sounds like this was a support request that got resolved so closing. StigNorland mentioned this issue Mar 17, I struggled with this for hours and nothing worked except adding the one line above: this. I am a relatively new developer. OK; return response; I appreciate any input to make this work in IE Cheers Soma.

Thank you very much for your help!!!! Cosolidate the code as below and this code is working good for me. Add "SearchReport" ; ws. ToDataTable students. ToList , true, TableStyles. GetProperties BindingFlags. Public BindingFlags. Add prop. Hello, I have the problem when I download the file. Connect and share knowledge within a single location that is structured and easy to search. I am learning Angular 2 and I am trying to Download the Excel file in angular 2 by fetching customer data from sql server tables using web api.

After searching in google i found some code but using that code i am able to download but it does not contain the proper data and file name is also having some guid format. Also look at this post angular2 file downlaod. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to download Excel file in angular 2 Ask Question. Asked 4 years, 2 months ago. Active 3 years, 5 months ago. Viewed 10k times. GetRemindersData Flag. Saravanan Sachi 2, 5 5 gold badges 30 30 silver badges 38 38 bronze badges. You can create the excel file file on the front from the data you display. Look at the answer here to see how it's done.

After following above reference i am having error like 'coudld not find a declaration file for module 'xlsx'. I have an Angular demo app implementing xlsx here. Clone it and see how it works. Thanks for sharing the link.

Actually i am not using angualr cli project but even though i tried based on your code and i encounter an error like 'Could not find a declaration file for module xlsx' — user Again thanks for sharing the link and in code works in angular cli project. Add a comment.