Unable to export the table with 2 tbody to excel

harender_24

I have a dynamic table with multiple tbody. I am using DataTable Library Everything is working fine but when i try to export the table in Excel, it only extract the first tbody. How can we extract all tbody content?

colin

Hi @harender_24 ,

Yep, the table should only have a single tbody - see here.

Cheers,

Colin

harender_24

Ok but what if we have multiple tbody. Can we use export all tbody content?

tangerine

You cannot use multiple tbody tags. It isn't valid HTML.

colin

Hi @tangerine / @harender_24 ,

It is valid HTML to have two <tbody> elements - see here. The issue is just that DataTables doesn't support it.

Cheers,

Colin

tangerine

My apologies - thanks, Colin.

harender_24

Ok. Thank you Colin

allan

I had planned to use multiple tbody elements to do grouping at some point, but that wouldn't allow for RowGroup's multiple level of grouping ability. So I think its unlikely we'll ever support multiple tbody elements in a DataTable unless someone can present a good reason to do so (other than that its valid HTML).

Allan