Excel Export is working in Chrome but not in IE 11

Excel Export is working in Chrome but not in IE 11

v3nkyv3nky 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

Answers

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    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

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0

    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.

  • kthorngrenkthorngren Posts: 20,141Questions: 26Answers: 4,736

    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

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0

    Thanks but I have been using bootstrap 3.. Will your changes works for bootstrap 3 as well ?

  • kthorngrenkthorngren Posts: 20,141Questions: 26Answers: 4,736

    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

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0

    I tried example as mentioned below but did not work.

    http://live.datatables.net/kumutace/10/edit

  • kthorngrenkthorngren Posts: 20,141Questions: 26Answers: 4,736
    Answer ✓

    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

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0
    edited March 2020

    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 .

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    Thanks for the test case, but there are very few records there. Can you link to a page that demonstrates the issue, please.

    Colin

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0

    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.

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0

    @colin Could you please check and advise why the process is taking more time in IE11?

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    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

  • v3nkyv3nky Posts: 46Questions: 11Answers: 0

    okay thank you for feedback Colin. is there any option to set serverSide to true based on browser usage ?

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    It's an initialisation option, so you could perform that check and then decide which way to go.

    Colin

This discussion has been closed.