Datatables export Excel

Question

I'm exporting the datatables in csv. And when I open the file with excel, I've got problem with big numbers (around 20 digits). I also have problem with the special characters. I guess it's a formatting problem. But I don't know How to correct the problem.

The code in my Js file:

dom: 'Bfrtip',
    buttons: [
        {
            extend: 'csv',
            text: 'csv',
            fieldSeparator: ';' // with ';' we can export the file in csv and each column is in one column. Without ';' everything is in one column
        },
        'pdf',
        'print'
    ]

An image of the problem: 

Thanks for your help.

Answer 1

Follow the following steps :

1. Add Interop References. First we need to add a reference for Microsoft.office.interop.Excel as in the following:
2. Create a DataTable dynamically.
3. Class file for generating Excel. ...
4. Creation of Excel objects. ...
5. Initialization of Excel objects. ...
6. Writing to Excel file. ...
7. Working with range and formatting Excel cells. ...
8. Coloring cells.