Export to Excel and CSV file - is not working

Export to Excel and CSV file - is not working

somasowmi@live.comsomasowmi@live.com Posts: 6Questions: 2Answers: 0

I thought of using this ,
But having an issues in formatting when access from Germany machines. All got inserted into one column.

Try CSV and EXCEL from German machines ( IE - excel, All browser - csv)
https://datatables.net/extensions/buttons/examples/initialisation/export

Answers

  • colincolin Posts: 2,386Questions: 0Answers: 427

    Hi @somasowmi@live.com ,

    There really isn't much for us to go on there, I'm afraid. We're happy to take a look, but it would help, as per the forum rules, if you could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

    Cheers,

    Colin

  • somasowmi@live.comsomasowmi@live.com Posts: 6Questions: 2Answers: 0

    Link to a test case showing the problem:

    Try to export CSV and EXCEL from German machines ( IE - excel, All browser - csv) form the below link,
    https://datatables.net/extensions/buttons/examples/initialisation/export

  • colincolin Posts: 2,386Questions: 0Answers: 427

    I don't have a German machine, so if you want us to look at this, please can you provide a test case that we can run with steps on how to reproduce the problem.

  • somasowmi@live.comsomasowmi@live.com Posts: 6Questions: 2Answers: 0

    Sure. It is a common issue to all German clients who is accessing from EUROPE. The** users from Germany are not able get the right format of data when they are using the option export to excel given in this website.**

    I feel test environment from my end is not required as of now as the '''issue is persisting in your actual source still and could be reproduced at any German clients machine'''

    _All the exported data has been dumped into one column instead of separating(,) it to more. _

    Just use the below link from your website given for a demo to test this from any of the Germany base VM or by chaining the cultural settings of your local machine,

    https://datatables.net/extensions/buttons/examples/initialisation/export

    Test steps:
    1. Login to any machine which is having internet connection and German cultural settings
    2. Open the link https://datatables.net/extensions/buttons/examples/initialisation/export
    3. Click the button "CSV" or "excel" given in this link https://datatables.net/forums/uploads/editor/fq/2ldvvdjo1pno.png
    4. Open or Save and Open the exported file
    5. The columns A should not be dumped with all the data instead it should spread to the respective columns as like in the table with headers

    Thank you for your response Colin!

  • allanallan Posts: 48,081Questions: 1Answers: 6,909 Site admin

    I've just changed it on my machine to use Microsoft's German language package and settings:

    The example you link to on this site appears to work just fine.

    How did you configure your own machine to test this?

    Allan

  • somasowmi@live.comsomasowmi@live.com Posts: 6Questions: 2Answers: 0

    Please change the setting like this and try again,

  • allanallan Posts: 48,081Questions: 1Answers: 6,909 Site admin

    Is that Win 7 or 8? I was using 10 before. I've just tried in a Win 8.1 VM and it appears to work just as expected:

    I know that the IE Excel export doesn't work at the moment. That's nothing to do with the localisation of the machine. Its a bug that has been fixed for the next release.

    CSV appears to be just fine though.

    Allan

  • somasowmi@live.comsomasowmi@live.com Posts: 6Questions: 2Answers: 0

    Yes, we are widely using windows 10 and it is latest. It is not working from any of the browser with this above settings(Localization).

    Could you please let me know from which version we could expect this will be working?

  • allanallan Posts: 48,081Questions: 1Answers: 6,909 Site admin

    Thanks - I've just tried changing those specific settings in Win10 and I can indeed see the CSV collapsing down to a single column. Why that is I don't know. I've just run a diff on the DE locale exported file and an EN locale exported file and they are absolutely identical.

    Thus it must be related to how Excel is doing the CSV import for the DE locale. I can't see why that would make any different at all - a CSV file is locale independent.

    I think this is something that would need to be reported to the Excel team.

    Allan

Sign In or Register to comment.