Excel

AdamV

Hi

I am using the excel export plugin, and the client request the headers & data of the exported Excel file to start at row 5 (!). Is there any way to (easily) achieve this? A solution which could be somewhat inline with the 'Attempt' below using newliners in the messageTop attribute:

 buttons: [
                  {
                     extend: 'excel',
                     title: 'some title',
                     messageTop: ' \n \n \n \n ',
                     ....
                   }
          ]

Kind regards
Adam V

allan

You mean bump from row 1 to row 5 leaving 5 blank rows?

I think the only way to do that would be to use the customize callback and change the row attributes (r) in the sheet. This example doesn't show exactly that, but it shows how to use customize to mess around with the generated XML.

Allan