Replies

• bandito Posts: 2Questions: 0Answers: 0

  February 2014

  same problem
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  February 2014

  You can use the oSelectorOpts ( http://datatables.net/extras/tabletools/button_options#oSelectorOpts ) option to tell TableTools to export only filtered rows, the current page, etc.
  
  Allan
• bsawyer Posts: 2Questions: 0Answers: 0

  February 2014

  Thanks Allan. That worked great.
• hermes980 Posts: 41Questions: 13Answers: 0

  May 2014

  It doesn't seem to be an option in the latest version. How can I only export filtered rows?
• fabianopall Posts: 7Questions: 1Answers: 0

  June 2014

  I agree.. any other side solution? I am just try to find a way to do it.. no luck yet
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  June 2014

  Ooops - it is there in the code, just not in the documentation... I'll correct that just now, but for the moment, use the legacy documentation: http://legacy.datatables.net/extras/tabletools/button_options#oSelectorOpts .

  Allan
• mttgne Posts: 4Questions: 1Answers: 0

  June 2014

  Using oSelectorOpts does not work for me. Still esporting all rows
• Revolt Posts: 2Questions: 1Answers: 0

  June 2014

  Doesn't work for me either when exporting to pdf. For clipboard, csv and xls export it works. I'm using this configuration:

  var tableToolsButtonsOptions = {
      bSelectedOnly: true,
      oSelectorOpts: {
          filter: "applied"
      }
  }, tableTools: {
      aButtons: [$.extend({
              sExtends: "copy",
              sButtonText: "Copy to clipboard"
          }, tableToolsButtonsOptions), {
              sExtends: "collection",
              sButtonText: "Export",
              aButtons: [
                  $.extend({
                      sExtends: "csv"
                  }, tableToolsButtonsOptions),
                  $.extend({
                      sExtends: "xls"
                  }, tableToolsButtonsOptions),
                  $.extend({
                      sExtends: "pdf",
                      sPdfOrientation: "landscape",
                      sPdfSize: "A3"
                  }, tableToolsButtonsOptions)
              ]
          }
      ]
  }
  
• csgjbeck Posts: 8Questions: 2Answers: 1

  June 2014 edited June 2014

  Here are the oSelectorOpts possible options:

  http://datatables.net/docs/DataTables/1.9.4/#$