How to get "messageTop" to work with excelHtml5

rdm

I need to place a message into the body of an exported excel document and I'm not having any luck. The data table exports just fine, but I don't see the message.

I've tried this.

buttons: [
    {
        extend: 'excelHtml5',
        messageTop:'This is a test'
    }
]

I've also tried this.

buttons: [
    {
        extend: 'excelHtml5',
        exportOptions:
        {
            messageTop: 'Another test' 
        }
    }
]

What am I doing wrong? How to I get message text to appear above the exported table?

kthorngren

Does this example work for you:
https://datatables.net/extensions/buttons/examples/html5/titleMessage.html

Kevin

rdm

@kthorngren -- I've already tried the example from the page you cite. I don't see any message. Even extending 'excel' instead of 'excelHtml5' has the same result. No message.

buttons: [
    {
        extend: 'excelHtml5',
        messageTop:'This is a test'
    }
]

kthorngren

I've already tried the example from the page you cite. I don't see any message.

The example works for me. Maybe try a different browser to test?

What browser are you using?

Kevin

rdm

Let me clarify: when I go to the cited page, I can print from that table and see the message.

However, then I take the same code from that page and apply it to my code, it doesn't work. Neither do I get any console errors.

allan

Make sure you are using Buttons 1.5 or newer for messageTop.

Allan

rdm

@Allan -- How to I tell what version of Buttons I have?

-- Disregard. I found the GitHub package and downloaded the zip file.

Even after replacing all my Buttons js files, I'm still unable to see any messageTop content.

rdm

For good measure, I even made sure the rest of my Data Tables js files were updated. I'm still not seeing messageTop. No console error, Chrome isn't seeing anything it doesn't like.

rdm

Lacking any other option, I shut down my computer and restarted it. Now I'm seeing a the messageTop.

Now it's working, but I find it hard to believe that restarting my computer was the solution.

allan

Sounds like a cache issue. The browser probably had an old version cached and restarting the machine cleared the cache.

Allan

meet2amitsinha

Hi
your code is ok please check your jquery and related .js file version like

https://code.jquery.com/jquery-3.3.1.js
https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js
https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js
https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js
https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js
https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js
https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js
https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js

Use same version its working properly.