Hide a column before excel export

doug_hale_jr

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