Excel export and Child Rows
Excel export and Child Rows
![mpoirier101](https://secure.gravatar.com/avatar/d4e0ff81e828d8f088424f01755cbad9/?default=https%3A%2F%2Fvanillicon.com%2Fd4e0ff81e828d8f088424f01755cbad9_200.png&rating=g&size=120)
Does the ExcelHtml5 functionality can export Child Rows ?
This question has an accepted answers - jump to answer
This discussion has been closed.
Does the ExcelHtml5 functionality can export Child Rows ?
This question has an accepted answers - jump to answer
Answers
Yes. It can also export hidden columns. And you can exclude columns from the export.
Hi @mpoirier101 ,
No, sorry, it doesn't, I think @rf1234 must've misread that one. See this thread here.
Cheers,
Colin
Hmmm depends on what we mean by child rows ... I have child rows whenever the responsive extension puts columns into a child row to make things fit like in here:
![](https://datatables.net/forums/uploads/editor/zi/d1vex3jhvspb.png)
All of the columns in the child row show up in my Excel export without any problem. So what am I missing here?
Interesting. I didn't know Responsive would do that.
Certainly the "usual" master/detail scenario doesn't export the detail (https://datatables.net/examples/api/row_details.html).
Thanks, tangerine. I wasn't aware of that. I let the Responsive extension take care of child rows and don't create them manually. If you order your colums by significance / importance this works fine. Even if your application isn't meant to be "really" responsive because people will only use it with a wide screen. In that case the Responsive extension still puts into child rows what doesn't fit on the screen ... My clients love it![:smiley: :smiley:](https://datatables.net/forums/resources/emoji/smiley.png)
That's a good tip, @rf1234 , a nice way of getting that extra detail out!