Excel Export is working in Chrome but not in IE 11
Excel Export is working in Chrome but not in IE 11
v3nky
Posts: 46Questions: 11Answers: 0
I have created live example http://live.datatables.net/kumutace/4/edit . Excel export in this live example is not working in IE 11 instead it is working in Chrome. Could you please advise what is going wrong here ?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
You're using old versions of the products. I've updated your sources here to the most recent and everything is working as expected.
Colin
Thanks for feedback Colin. I have tried the new versions however when I switch the columns, the background color of ColVIS has been changing it's background color from blue to white where as I am expecting it is in white background and it is not same as before colreorder.
I remembered a question like this previously and found one of your old threads. I took a look at Colin's example and see the blue. If you want to change the styling then you can inspect the page to see what is being applied. I added a CSS to the example to override the default styling and it seems to work, ie, provide white background with black text:
http://live.datatables.net/kumutace/8/edit
Kevin
Thanks but I have been using bootstrap 3.. Will your changes works for bootstrap 3 as well ?
Without trying it (either me or you) I'm not sure. Did you try it? You can update the example to use Bootstrap 3 or update your page to use the CSS.
Kevin
I tried example as mentioned below but did not work.
http://live.datatables.net/kumutace/10/edit
Did you try inspecting the dropdown to see what CSS is applied? Take a look and then copy that CSS to the style section and update as you like. Does that work?
Kevin
I have modified the CSS as advised by Kevin and it worked perfectly now. However I have some performance issue while exporting the huge number of records as excel.
For Example record count of 1084 is taking some time to get exported in 1 minute. but the record count of 6000 records taking ages and the whole browser gets stuck and do not respond . At the end there was no export getting generated .
Please advise what can be done here . you can use my live example http://live.datatables.net/kumutace/10/edit and try to generate 6000 records and try to export excel .
Thanks for the test case, but there are very few records there. Can you link to a page that demonstrates the issue, please.
Colin
I have created new example. http://live.datatables.net/zolagafo/1/edit and this works perfectly in Chrome in 10 seconds. However our end users uses Internet explorer and in IE 11, this process is taking ages and not getting extracted.
@colin Could you please check and advise why the process is taking more time in IE11?
It would just be because of the volume of data involved. You've got 42 columns, and 6,500 rows, and IE11 just can't cope I'm afraid. IE11 is even struggling to load the data and process the data - reordering the table doesn't even respond. Microsoft stopped supporting it and moved to Edge because of these kind of limitations.
It would be worth considering your implementation, may be use
serverSide, there's a few threads on this forum that discusses how to generate exports from there, such as this one here.Colin
okay thank you for feedback Colin. is there any option to set serverSide to true based on browser usage ?
It's an initialisation option, so you could perform that check and then decide which way to go.
Colin