TableTools export to Excel includes all rows, not filtered ones

hermes980

Hi all,

When exporting to Excel, tabletools exports all rows, even ones that are currently filtered out. I am using mColumns but that only affects the columns that I hide/show. How can I ensure that only the filtered rows are exported to Excel?

Thanks,

K.

hermes980

I have the print button enable and it grabs on the filtered rows.

hermes980

Good news. I was able to get it working by an undocumented option as stated here:

http://datatables.net/forums/discussion/20224/tabletools-2-2-0-export-not-filtered

                "oSelectorOpts": {
                    "filter": "applied"
                },