How to Excel export as pure CSV

Scyzor

I have created Excel button as follows:

                        "buttons": [
                            {
                                extend: 'excel',
                                text: '<img src="images/assets/CSV.png">',
                                filename: 'Logs',
                                extension: '.csv',
                                exportOptions: {
                                    stripHtml: false,
                                    modifier: {
                                        page: 'current'
                                    }
                                }
                            }
                        ],

but it will save file format as XLS/XML not CSV and when user will try to open in Excel will throw a security error.

kthorngren

There is a builtin button type for CSV along with others:
https://datatables.net/extensions/buttons/built-in

Change your button type from excel to csv.

Kevin

Scyzor

Found that https://datatables.net/reference/button/csvHtml5 No clue why Excel method says

Create and save an Excel CSV file that contains the data from the table.

which is misleading