Export To Excel...Excel file cells width modification

mrumarasghar

Have you guys introduced that features in new version of Datatables?

I am curious to know about it. I am exporting Excel but its giving too much more space than the data length or the required space for data.

Here is an image attached with please look at it and let me know.
http://imgur.com/a/91hyv

thanks

allan

If you link to the page that shows the issue, I'd be happy to take a look. I don't know why it is making the cells to wide.

Allan

mrumarasghar

I have got it resolved because I was using DataTables filter (select input) which was also incuded in the export feature so I discard the filter data just before export via exportOptions. Now its working fine.

mrumarasghar

I get it working it by doing this.
{
extend: 'excelHtml5',

                        exportOptions: {
                            format:{
                                footer: function( data, row, column, node ){
                                    return "";
                                }
                            }
                        },

}