How to I can start data in row 4 excel, my data only fill row 2

rachihi

$(`#table-request`).DataTable({
                            data: myObj,
                            scrollY: 500,
                            scrollCollapse: true,
                            scrollX: true, 
                            dom: 'l, Bfrtip',
                            buttons: [
                                'copyHtml5', {
                                    extend: 'excelHtml5',
                                    text: 'Excel',
                                    filename: 'report CI',
                                    autoFilter: true,
                                    customize: function (xlsx) {
                                        var sheet = xlsx.xl.worksheets['sheet1.xml'];
                                        $('c[r=A1] t', sheet).text('Custom text');    
                                    },
                                }, 'pdfHtml5'
                            ],
                            columns: columns
                        });

colin

There's isn't an option to offset the rows, I'm afraid, so you would need to move each row down manually in the customize function, similar to how you create that custom text.

Colin