Export rowGroup to excel

Lucaslopez12

Hi.

I Have the following table and use rowGroup for quantities but when i want to export to excel it does not export the grouped data.

My code and example:

  var TableServicios = $('#TableServicios').DataTable( {
    responsive: false,
    lengthChange: false,
    "paging": false,
    autoWidth: false,
    searching: true,
    fixedHeader: true,
    "scrollX": true,
    buttons: [{
        extend: "excel",
        title: '',
        filename: 'Venta Servicios Adicionales',
        exportOptions: { orthogonal: 'export' }
    }],
    language: {
        "url": "//cdn.datatables.net/plug-ins/1.10.24/i18n/Spanish.json"
    },
    columns: [
        { "data": "Articulo" },
        {
            "data": "CantidadTotal", sType: "numeric"
        },
        {
            "data": "Monto", sType: "numeric", render: function (data, type, row) {
                return type === 'export' ?
                    data.replaceAll(/[$ |.]/g, '').replace(',', '.') :
                    data;
            }
        },
        // ...allColumnsServices
    ],
    rowsGroup: [0, 1, 2]
  } );

I read that rowGroup is currently supported export options of the Buttons extension but i wanted to know if there is any solution for this today.

Thanks

Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide

kthorngren

You are using the rowsGroup plugin which is developed by a third party. I believe this is the link to the library:
https://github.com/ashl1/datatables-rowsgroup

This is different then the Datatables RowGroup extension. The rowsGroup plugin manipulates the HTML display directly and Datatables doesn't know about the changes. You can create a custom function to export the rows in the way you want. This thread shows an example of exporting the Datatables rowGroup. You will need to make some changes since you will need to group the rows before exporting them.

Kevin

Lucaslopez12

Any example? I dont understand

kthorngren

Sorry there is not a specific example for what you want. I updated the example I linked to which simply exports all the rows:
http://live.datatables.net/fezituro/1/edit

It uses this statement to get all the rows:

var rowData = dt.rows( selectorModifier ).data().toArray();

It calls a blank function called groupRows() which still needs written. Currently it just returns the rowData passed into the function

Then it calls updateSheet1() to export the rowData rows to the excel sheet.

All you should have to do is write the code for the groupRows() function to group the rows accordingly. There is nothing Datatables specific you will need in this function. Its just a Javascript exercise to loop through the original array passed in to build. new array with the grouped rows.

Kevin