Get data into Excel Export

Get data into Excel Export

sjw01sjw01 Posts: 45Questions: 21Answers: 1

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?

Answers

  • colincolin Posts: 5,549Questions: 0Answers: 970

    Hi @sjw01 ,

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

    Cheers,

    Colin

  • sjw01sjw01 Posts: 45Questions: 21Answers: 1
    edited January 17

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

  • kthorngrenkthorngren Posts: 6,084Questions: 21Answers: 1,347

    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

Sign In or Register to comment.