How to remove the blank row on the 3rd line of the export to excel?
How to remove the blank row on the 3rd line of the export to excel?
htimmins
Posts: 3Questions: 1Answers: 0
I need to remove the blank 3rd row on the export as it blocks my users using Excel filters without deleting that row.
This question has an accepted answers - jump to answer
Answers
Post a test case please. Normally there is no blank row.
https://editor.datatables.net/examples/extensions/exportButtons
Alternatively check your HTML. Maybe you have an empty <th> or <tr> in there?!
@rf1234 Hi, you are right, I have a filterRow on the top of each column.
I have tried to use this:
exportOptions: {
columns: exportedColumns,
rows: ":not('#filterRow')"
}
But the "not" selector isn't working. Do you have any ideas?
See this example for how to remove header rows from the export.
Kevin
@kthorngren Brilliant, thank you