Replies

• vinitsharma Posts: 23Questions: 0Answers: 0

  August 2012

  I did got a solution for getting the current datatables data like the current page data and that too excluding the hidden columns data through this.fnGetTableData(oConfig). But this data is in the form of a large string. How can I get this data in some particular array elements separated manner or in a manner through which i can saggregate each particular cells data of the datatable? Please tell.
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  August 2012

  > is there some method of datatables through which I can send an array generated in javascript to the server side code i.e. vb code?
  
  Use fnGetData and then a jQuery Ajax request with the data.
  
  Allan
• vinitsharma Posts: 23Questions: 0Answers: 0

  August 2012

  Many thanx for your reply Allan. I need to trigger the click event of the Export to Excel button. In the aButtons[] array where I have defined the two buttons for 'Excel' and 'PDF', I tried removing the code(function) written inside the "fnClick": property of datatable and posted my own code inside it. But still my code isnt showing any effect while undoing and pasting the old code does gets executed. So how can I catch the click event of the Export To Excel button? I did tried this with jQuery click() event but that didn't worked too. So is there any way of catching the click event of the "Export To Excel" button. Do I need to remove some properties defined with this button ? Kindly tell.
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  August 2012

  Using fnClick should do:
  
  [code]
  oTableTools: {
  aButtons: [
  {
  sExtends: "text",
  fnClick: function ( button, conf ) {
  var data = datatable.fnGetData();
  // ...
  }
  ]
  }
  [/code]