How to export Excel data excluding hidden rows.

jhjh

Hi all, I hid the row value while using the data table.
When I output the Excel file, the hidden row value is also output, but if I hide the row, can I know how to hide the data in Excel?

You can't see the button in Codepen, but please check rowCallback.
codepen: https://codepen.io/jhjh00020/pen/eYGZLLq

colin

You can use rows in exportOptions as a function, to determine what rows will be exported - something like this,

Colin

jhjh

Thank you always. Have a happy day.