table to excel onclick

Question

Im working on IE9, and I have the following code to download a html table as an excel spreadsheet:

<a id="toExcel" onclick="window.open('data:application/vnd.ms-excel,' + document.getElementById('resultsTable').outerHTML.replace(/ /g, '%20'));e.preventDefault();" href="javascript:void(0);">Excel</a>

This works in other browsers such as chrome, but not in IE9. It just opens up a new tab with the code in the url bar.

How do I get this to work in IE9?

I have tried putting the onclick event in another element such as a button it didnt work.

With datatables the library it seems it is adding a lot of other stuff to the table, i only want this feature.

Footnote for bounty:

Must work on IE9.
Please do not suggest https://datatables.net. For internal reason we cannot use this suggestion.
Am happy to vere from my what we have already tried (see code snippet earlier) as long as it works
Must download as xlsx and must open properly on excel 2010.
The project is using Sharepoint 2013 and a custom js/jquery webpart. We have dynamically generated a html table and need to be able to export to excel as above.

Thanks for any help

Side note: better replace that a tag with a button (button or input type="button" for correct semantics. — MarioDS
– MarioDS, Commented Jun 9, 2014 at 11:26
Have you thought about generating the Excel file on the server side? Depending on your server side technology, there may be a good library for generating Excel files. — mason
– mason, Commented Jun 11, 2014 at 15:13
@RSM: Can you go for server side solution? That will always work for all browsers. There are many APIs for excel generation for each language. — Chankey Pathak
– Chankey Pathak, Commented Jun 11, 2014 at 15:55

Community · Accepted Answer · 2017-05-23 12:21:26Z

1

+150

As already mentioned a serverside implementation would be much better. Create an AJAX call to your controller with the appropriate id's included(needed to query your data) and send it back to the browser. If this is not possible in your situation please take a look at following post:

How to change "comma" separator to something else in blob csv?

I could copy my own answer but that doesn't make sense ;)

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Jun 17, 2014 at 10:18

GuyT

4,4562 gold badges20 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chankey Pathak · Accepted Answer · 2014-06-09 11:36:22Z

0

Not exactly the solution of your problem but I also worked on "HTML table to Excel" report generation, I tried quite same code as yours, I also made this: http://jsfiddle.net/chankeypathak/7cwZ9/ but I kept facing issues like the fiddle I linked, there you see I used window.btoa method which I came to know later that it's not supported by IE9 or less. So I ended up using Datatables' TableTools plugin. There are a lot of options, export to CVS, Excel, PDF, copy to clipboard etc.

answered Jun 9, 2014 at 11:36

Chankey Pathak

21.8k12 gold badges88 silver badges137 bronze badges

2 Comments

AeroX Over a year ago

You might be able to get this to work by using David Chambers' window.btoa and window.atob polyfill

Chankey Pathak Over a year ago

@AeroX: That's nice, however at that time I ended up generating it from server side.

Collectives™ on Stack Overflow

table to excel onclick

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related