TableTools Excel - skip if display:none;

shaneisme

I've got a table that allows users to hide columns (using DataTables built-in functions) and hide rows (using a simple jQuery).

I'm currently using "mColumns": "visible" to only send the visible columns to the CSV, is there also a way to do this if it detects css or inline styles (essentially something like "mRows": "visible")?

Current version: http://promos.asus.com/us/z87/comparison/branch.1.4.0.asp

allan

Sorry to say, no. Column and row visibility in DataTables is entirely done by removing elements from the DOM and the plug-ins reflect this. Manually setting display:none is not something that is supported in DataTables.

Allan

shaneisme

Is there a plug-in that can be used to show/hide rows like there is for columns?

I've been digging and I'm afraid I can't find it :(

allan

That's because there isn't one. Rows are shown / hidden in DataTables by filtering.

Allan

shaneisme

OK - thanks anyway.