DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
Examples
Manual
Reference
Extensions
Plug-ins
Blog
Forums
Discussions
Sign In
Support
FAQs
Download
Purchase
≡
Show site navigation
Invisible Columns and Export to Excel
Invisible Columns and Export to Excel
chinedu
Posts: 3
Questions: 0
Answers: 0
June 2013
edited June 2013
in
General
I have a invisible columns showing up in Excel export.
I want to keep the columns hidden in the export to Excel also. How do I make the export "export" only the columns that are visible on the screen?
Please help!!!
Replies
chinedu
Posts: 3
Questions: 0
Answers: 0
June 2013
Please someone help me out here. Am I missing something?
Is the export to excel designed to export hidden columns? If so, how do I turn it off
jgcaudet
Posts: 82
Questions: 7
Answers: 0
July 2013
You can say to tabletools in mColumns parameter which columns you want to export
http://datatables.net/extras/tabletools/button_options
chinedu
Posts: 3
Questions: 0
Answers: 0
July 2013
Thank you so much.
I knew it had to be something very simple.
This discussion has been closed.
Sign In
·
Register
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Quick Links
Categories
Recent Discussions
Unanswered
Categories
75.1K
All Categories
57
Priority support
24.7K
Free community support
1K
General
14
Announcements
2.6K
DataTables
134
DataTables 2
1.3K
DataTables 1.10
93
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.3K
Editor
2.8K
Extensions
20
AutoFill
314
Buttons
34
ColReorder
4
ColumnControl
34
DateTime
68
FixedColumns
51
FixedHeader
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
168
SearchBuilder
201
SearchPanes
108
Select
27
StateRestore
221
Bug reports
68
Feature requests
101
Plug-ins
11
Blog
74
Web-site
Replies
Is the export to excel designed to export hidden columns? If so, how do I turn it off
http://datatables.net/extras/tabletools/button_options
I knew it had to be something very simple.