Questions tagged [tabletools]

TableTools is a plug-in for the DataTables HTML table enhancer, which adds a highly customisable button toolbar to a DataTable.

TableTools is a plug-in for the DataTables HTML table enhancer, which adds a highly customisable button toolbar to a DataTable.

Key features include:

  • Copy to clipboard
  • Save table data as CSV, XLS or PDF files
  • Print view for clean printing
  • Row selection options
  • Easy use predefined buttons
  • Simple customization of buttons
  • Well defined API for advanced control

Initialising TableTools with DataTables:

/*
 * Example initialisation
 */
$(document).ready( function () {
    $('#example').dataTable( {
        "sDom": 'T<"clear">lfrtip',
        "oTableTools": {
            "sSwfPath": "/swf/copy_csv_xls_pdf.swf"
        }
    } );
} );
173 questions
8
votes
2 answers

Export value with Linebreaks into single cell in Excel. jQuery Datatables

I am successfully exporting HTML tables from a web application to excel using jQuery DataTables. However one particular column has values containg line breaks and tabs. I have managed to display the data correctly on the HTML table by replacing new…
psycho
  • 1,539
  • 4
  • 20
  • 36
8
votes
10 answers

Datatables / TableTools: format data as text when exporting to Excel

I am using the Datatables TableTools plugin in order to provide an Export to Excel option for a table on my page. In general everything works as intended. My only issue is that I would need all the data resp. the columns in the resulting Excel…
user2571510
  • 11,167
  • 39
  • 92
  • 138
8
votes
4 answers

Jquery - DataTables [tableTools]: export only visible rows

I just started out using jQuery DataTables. using the tableTools of DataTables, is it possible to only export visible rows instead of all the rows? If for example the pagination was set to 10 I would expect only 10 rows to be exported. The same goes…
Tony Clifton
  • 703
  • 3
  • 14
  • 27
7
votes
1 answer

Export all table data using jquery dataTables TableTools

I am doing server side processing using jquery datatable.My datatable code is as below: $('#DataGrid').dataTable({ destroy: true, "processing": true, searching: false, serverSide: true, "scrollX": true, "bLengthChange":…
sajju217
  • 447
  • 3
  • 7
  • 19
7
votes
1 answer

Use TableTools for DataTables in R Shiny for renderDataTable

For this question, I am using the R Shiny tutorial example found here: http://rstudio.github.io/shiny/tutorial/#datatables Running the code on this tutorial renders the application at the following…
Jonathan Charlton
  • 1,975
  • 6
  • 23
  • 30
7
votes
2 answers

How to display Datatable tabletools (copy, csv, excel, pdf, save) in ruby on rails

I am using Datatable in my ruby on rails application. I follow the same one which is here.. https://github.com/rweng/jquery-datatables-rails And My datatable sorting and searching working properly. But I can't see my table tool option (eg - copy,…
Maruthi042
  • 145
  • 1
  • 5
  • 16
6
votes
3 answers

Export data from datatable with select element exports each option from the select element

I am try to add export buttons to my datatable, my table include select boxes inside, the problem is - it export all the options values included in the select box... A am using ajax to get results from the server then manipulate different data…
benjah
  • 613
  • 7
  • 29
6
votes
5 answers

Datatables TableTools multiple tables on the same page

I am having problems with multiple instances of DataTables and TableTools on the same page. The DataTables are working fine, but when using TableTools only the first table is working fully with the buttons. All buttons are appearing fine on all…
Codded
  • 1,256
  • 14
  • 42
  • 74
6
votes
2 answers

How to use a link in TableTools instead of flash buttons

I'm trying to find a way to change the buttons on TableTools. I'd like to use my own customized links instead of the flash buttons. Is there a way I can do that? Any good resource teaching me how to make that modification and still able to use the…
rogcg
  • 10,451
  • 20
  • 91
  • 133
5
votes
1 answer

Enabling custom button (disabled by default) when row is selected

I have a DataTable displaying data for Branches with two custom buttons defined: Add and Update. They are initialized at the top of the Javascript section var buttons; var tblBranch; $.fn.dataTable.ext.buttons.add = { className:…
Alycus
  • 221
  • 1
  • 4
  • 15
5
votes
3 answers

jQuery dataTables - TableTools not working

I'm using http://datatables.net/extensions/tabletools/ in my local-host ( wamp server ). It's working fine, but when I put the same code on my online server, it isn't working. I am using all latest version of datatables tableTools: { …
user3209031
  • 837
  • 1
  • 14
  • 38
5
votes
1 answer

how to disable a DataTables/TableTools button

I'm using DataTable 1.10 and TableTools 2.2.1. Given the following snipped I would like to disable/enable the edit-button. var myTable = $("#myTable ").DataTable({ tableTools : { "aButtons" : [ { "sExtends" : "text", …
thowa
  • 590
  • 1
  • 8
  • 29
5
votes
3 answers

Datatables TableTools - Is it possible to only include the visible columns when saving CSV?

I did some tests using the TableTools plugin for Datatables on saving CSV. I noticed that it saves everything. It does not care if you filtered the rows nor if you hide some columns. Is there a way to only save the data from visible columns?
developarvin
  • 4,940
  • 12
  • 54
  • 100
4
votes
4 answers

Can't get DataTables TableTools to display

Dunno what I'm doing wrong here. I have DataTables in the directory: MainFolder/common/js/DataTable-1.8.2/jquery.dataTables.min.js and am including it like so: I've…
earachefl
  • 1,880
  • 7
  • 31
  • 55
4
votes
1 answer

Datatable unable to export updated checkbox values in excel as 0 or 1, alway showing the initially checked values only

Trying to download Datatables, able to get 0 or 1 values for checkboxes (for one of the column fields "Verified") initially, but when I am toggling the checkbox and exporting as excel, unable to retrieve the latest check box values. Initially I…
1
2 3
11 12