Answers

• rf1234 Posts: 2,955Questions: 87Answers: 416

  October 2022

  You should create the Excel on the server would be me advice. This would also allow you to customize it a lot easier using tools like PHP Spreadsheet for example.
• allan Posts: 63,281Questions: 1Answers: 10,425 Site admin

  October 2022

  Just to add to that, this is the piece of code that finalizes the Excel export. As you'll be able to see there, there is no option to get the generated file as a blob.

  You could if you wanted add that ability there, and then post the generated file to the server to have it e-mail the attachment out. But as usual I'd totally agree with @rf1234 and say it might be easier to just do this all server-side. Use the buttons.exportData() method to get the data to export and send that to the server.

  Allan
• zbjs4mo Posts: 2Questions: 1Answers: 0

  October 2022

  I changed my code and now has a function in controller that create excel and attach it to email and send. here is what controller should get
  public IActionResult SendEmail(System.Data.DataTable dt)

  my problem now is just to get the data from datatable buttons and send to this controller here is my code:

      $('#example-table').DataTable({
          dom: 'Blfrtip',
  
          buttons: [
              {
                  extend: 'excelHtml5',
                  title: 'Data',
                  text: 'Export To Excel',
                  exportOptions: {
                      format: {
                          body: function (inner, rowidx, colidx, node) {
                              if ($(node).children("input").length > 0) {
                                  return $(node).children("input").first().val();
                              } else {
                                  return inner;
                              }
                          }
                      }
  
  
                  },
                  action: function (e, dt, node, config) {
                      //var myList = dt.buttons.exportData(config.exportOptions);
                      var myList = $('#example-table').DataTable();
  
                      jQuery.ajax({
                          type: 'POST',
                          url: "/R/SendEmail",
                          data: dt,
                          contenttype: "application/json; charset=utf-8",
                          datatype: "json",
                          cache: false,
                          contentType: false,
                          processData: false
  
                      });
  
                  }
  
              }
  
          ]
  
• allan Posts: 63,281Questions: 1Answers: 10,425 Site admin

  October 2022

  var myList = dt.buttons.exportData(config.exportOptions);
  

  looks correct to me. Then sent that as the data.

  Allan