Heading and styles for Excel or PDF

[BBBhatt]

How can we set Heading for either Excel of PDF which will be displayed on top of the document..

And how to add Styles for specific Rows / Columns line with Datatables grouping, we Add Bold attributes for Grouped Rows.

[hhurz]

• When the docType is 'pdf', you could modify the behavior of the jspdf-autotable functionality.
  Specifically, assign a custom function to the onBeforeAutotable callback of the tableExport configuration.
  This callback is triggered before the table is rendered in the PDF.
  Inside this function, the doc object (representing the PDF document) can be accessed via the options parameter.
  The heading text is added to the PDF by setting the font size and positioning the text slightly above the table
  using the provided margins. Example:

function setDocumentHeading(docType, headingText) {
  if (docType === 'pdf') {
    defaults.jspdf.autotable.tableExport.onBeforeAutotable = function (table, columns, rows, options) {
      const doc = options.doc;
      doc.setFontSize(16);
      doc.text(headingText, options.margins.left, options.margins.top - 10);
    };
  }
}

• For Excel see How to add fields at the beginning or end in a table export to Excel. #375

• Regarding adding styles:

// Extend the tableExport plugin to handle grouped rows
(function ($) {
  $.fn.tableExport = function (options) {
    const defaults = {
      ...existingDefaults, // Keep existing defaults
      onCellData: function ($cell, rowIndex, colIndex, cellText, cellType) {
        // Check if the row is a grouped row (e.g., based on a class or content)
        if ($cell.hasClass('grouped-row')) {
          // Apply bold style for grouped rows
          return '<b>' + cellText + '</b>';
        }
        return cellText;
      }
    };

    // Merge user options with defaults
    options = $.extend(true, {}, defaults, options);

    // Call the original tableExport logic
    return this.each(function () {
      // Existing tableExport logic...
    });
  };
})(jQuery);

// Example usage with DataTables and grouped rows
$(document).ready(function () {
  const table = $('#example').DataTable({
    rowGroup: {
      dataSrc: 'groupColumnName' // Replace with the column name used for grouping
    }
  });

  // Add a class to grouped rows for easier detection
  table.on('draw', function () {
    $('#example tbody tr.group').addClass('grouped-row');
  });

  // Export the table with bold styles for grouped rows
  $('#exportButton').on('click', function () {
    $('#example').tableExport({
      type: 'pdf',
      fileName: 'GroupedTableExport'
    });
  });
});