Are hidden columns supposed to be included in Excel export?
Are hidden columns supposed to be included in Excel export?
Per this discussion: https://datatables.net/forums/discussion/comment/142777/#Comment_142777
It sounds like any columns that are currently "hidden", due to the Responsive extension showing them in a child row -- that they should still be included when you do an Excel export. And, it seems like I remember seeing that being the case in the past (though, that probably doesn't mean anything! )
However, that is not what I'm experiencing. The few tables that we use Responsive with -- when the screen is wide, all columns are included in the Excel export. But when the screen is narrow, the "collapsed in child row" columns are not exported. Is this the expected behavior? And if not, could there be something I'm doing wrong or need to set?
Answers
This test case shows that columns hidden by Responsive are exported by default:
https://live.datatables.net/guniqawo/1/edit
Possibly you are using a
column-selector
with the export buttons that doesn't export hidden columns. See this example.If this doesn't help please post a link to your page or a test case replicating the issue so we can help debug.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case
Kevin
OK, thanks. Will figure it out. Just wanted to make sure I wasn't under the wrong impression before I delved in further.