Excel
Excel
AdamV
Posts: 7Questions: 3Answers: 0
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
This discussion has been closed.
Answers
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
customizecallback and change the row attributes (r) in the sheet. This example doesn't show exactly that, but it shows how to usecustomizeto mess around with the generated XML.Allan