Exporting using different column?

jean

Hi,

I am trying to resolve a simple problem: I was to display in the firstname lastname and email in the same table cell in the browser, but would like to be able to split those in three column when exported.

Is there a way to do that? Ultimately I could use three hidden columns but I was thinking someone have a better idea ;)

thanks
j

allan

TableTools (which I presume you are using?) have two configuration options for manipulating the data that is being exported:

http://datatables.net/extras/tabletools/button_options#mColumns
http://datatables.net/extras/tabletools/button_options#fnCellRender

The rendering method might be what you want?

Allan

jean

Thanks for the hint, Allan.

Because I have no way to explode the cell firstname lastname email (multiple firstname or last name), I will still need to create three hidden columns.
Using mColumns I can indeed hide the visible columns and export instead the three hidden one.
That create some traffic overhead as I will be sending firstname/lastname/email twice but that's fine.