Get data into Excel Export

sjw01

I have tried a few ways to achieve this but DataTables kills me at every turn.

I have data in a child row which are notes - could be one note, could be 20 separate notes.

I want to export with excel when the [button] is clicked.

DataTables says - this can't be done.
So I opted for a workaround:
Generate a unique link and wrap that around a field - When exported, the user can click the link which opens a custom page which lists all the notes - This can't be done...

I'm running out of solutions here - DataTables is cutting me off at every pass...

Are there any solutions bar loading in paragraphs of data into the main table row?

colin

Hi @sjw01 ,

This thread should help, it's asking the same thing.

Cheers,

Colin

sjw01

So I guess that means NO, not without completely rebuilding the export feature?

kthorngren

I have data in a child row which are notes

Are you ajax loading this data for each child row or is it attached as part of the original data in each row?

If its already part of the original data you can place it into a hidden column and export the hidden column along with the other columns.

Kevin