Hide a column before excel export

Hide a column before excel export

doug_hale_jrdoug_hale_jr Posts: 22Questions: 0Answers: 0
edited October 2010 in TableTools
Hi all,

[code]
$("div.TableTools").mouseenter(function() {
oTable1.fnSetColumnVis( 3, false );
});

$("div.TableTools").mouseleave(function() {
oTable1.fnSetColumnVis( 3, true );
});
[/code]
I tried using Jonas solution above to hide a column before exporting to excel but it does not appear to work. No errors were reported but the undesirable column still appeared in the export. Does anyone know how to hide a column before exporting using the Tabletools?

Modifying the tabletools core files may not be an option for me since I use tabletools functionality in many of my pages and would not want to affect them adversely.

Thanks
This discussion has been closed.