Add extra sheet with preset data Excel export

Add extra sheet with preset data Excel export

boomstamboomstam Posts: 2Questions: 1Answers: 0

Hello all,

I am making use of the DataTables in my ASP.NET Core application. When I export to excel now it just generates the HTML table which is present on the page I'm exporting from. But now I need to add a extra sheet with preset data.
The data which need to be added to the extra sheet contains about 50 rows with all sort of values.

What would be the best practice for this? I already read that I need to make use of the customize function but I have a hard time understanding it.

Answers

  • colincolin Posts: 15,118Questions: 1Answers: 2,583

    Hi @boomstam ,

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

    Cheers,

    Colin

  • boomstamboomstam Posts: 2Questions: 1Answers: 0
    edited June 2019

    @colin I literally tried the whole day to fix it, but it won't parse right no matter what. It is because my table uses vertical header (can't change that, as it is a must)

    I also tried using this method: https://codepen.io/RedJokingInn/pen/pVKWjz
    Where I replaced the XML in the example for my own XML. Also doesn't work and leaves me with a blank sheet.

    I am really distraught atm and I have no idea how I am going to fix this. If anyone has a idea, please tell me!

  • minhalminhal Posts: 76Questions: 12Answers: 0

    Hi @boomstam ,

    I am facing the same issue, are you able to tackle that? If so can you please share your example that would be great.

    Thanks

This discussion has been closed.