mais sa ne marche pas.
TableTools uses a Flash SWF file to provide the ability to copy text to the system clipboard and save files locally. TableTools must be able to load the SWF file in order to provide these facilities. If you aren't using the same directory structure as the TableTools package, you will need to set this parameter.
Note that TableTools ships with two different SWF files - the only difference between them is that one of them provides the ability to save PDF files while the other doesn't. The trade off is that the PDF capable file is significantly larger in size (56K v 2K).
"sSwfPath": "tableTools/media/swf/copy_csv_xls_pdf.swf",
$('#example').dataTable( { "sDom": 'T<"clear">lfrtip', "oTableTools": { "sSwfPath": "http://datatables.net/release-datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf", "aButtons": [ "copy", "csv", "xls", { "sExtends": "pdf", "sPdfOrientation": "landscape", "sPdfMessage": "Your custom message would go here." }, "print"] }, } );
"sSwfPath": "tableTools/media/swf/copy_csv_xls_pdf.swf",rien ne se pas , et quand je rajoute :
"sDom": 'T<"clear">lfrtip',a la place de :
"sDom": '<"clear"><"H"Tflr>t<"F"ip>',je perd le coter graphique et les boutons disparaisse.
<title>Test activation des bouttons</title> <head> <meta http-equiv="content-type" content="text/php; charset=ISO-8859-1" /> <link rel="stylesheet" href="CSS/Style_DataTables_CSS.css"/> <link rel="stylesheet" href="CSS/jquery-ui-1.10.4.custom.css"/> <link rel="stylesheet" href="CSS/dataTables.tableTools.css"/> <script type="text/javascript" src="JS/JS_JQuery_1_11_0_C.js"></script> <script type="text/javascript" src="JS/jquery.dataTables.min.js"></script> <script type="text/javascript" src="JS/dataTables.tableTools.min.js" ></script> <script type="text/javascript" charset="utf-8"> $(document).ready(function() { $('#example').dataTable({ "bJQueryUI": true, "sPaginationType": "full_numbers", "sDom": '<"clear"><"H"Tflr>t<"F"ip>', "oTableTools":{"sSwfPath": "/swf/copy_csv_xls_pdf.swf", "aButtons": ["copy","print",{"sExtends":"collection","sButtonText": "Save","aButtons":[ "csv", "pdf" ]}]}, "oLanguage": { "sUrl": "js/fr_FR.txt" } }); }); </script> </head> <body background="IMAGES/fond_Gris.jpg"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="display" id="example"> <thead> <tr> <th bgcolor="#F0FFFF" width="80px">Type</th> <th bgcolor="#F0FFFF" width="300px">Group</th> <th bgcolor="#F0FFFF" width="130px">Time spent</th> <th bgcolor="#F0FFFF" width="180px">Ressource</th> </tr> </thead> <tbody> <tr> <td>FAA</td> <td>K7</td> <td>45</td> <td>Arnold</td> </tr> <tr> <td>SDG</td> <td>G5</td> <td>49</td> <td>Hee</td> </tr> <?php while ($data = mysql_fetch_assoc($req)) { ?> <tr> <td><?php echo $data['id']; ?></td> <td><?php echo $data['titre']; ?></td> <td><?php echo $data['description']; ?></td> <td><?php echo $data['lien']; ?></td> </tr> <?php } ?> </tbody> <tfoot> <tr> <th colspan="4"> </th> </tr> </tfoot> </table> </body>
$(document).ready( function () { $('#example').dataTable( { "bJQueryUI": true, "sPaginationType": "full_numbers", "sDom": '<"H"Tfr>t<"F"ip>', "oTableTools": { "aButtons": [ "copy", "csv", "xls", "pdf", { "sExtends": "collection", "sButtonText": "Save", "aButtons": [ "csv", "xls", "pdf" ] } ] } } ); } );
<script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/ZeroClipboard.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/TableTools.js"></script>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Test 4.4 activation des bouttons Datatables // TableTools</title> <!-- CSS --> <link rel="stylesheet" href="media\css\demo_page.css" type="text/css" /> <link rel="stylesheet" href="media\css\demo_table.custom.css" type="text/css" /> <link rel="stylesheet" href="media\css\demo_table_jui.css" type="text/css" /> <link rel="stylesheet" href="media\css\jquery.dataTables.css" type="text/css" /> <link rel="stylesheet" href="media\css\jquery.dataTables_themeroller.css" type="text/css" /> <link rel="stylesheet" href="media\css\TableTools.css" type="text/css" /> <link rel="stylesheet" href="media\css\TableTools_JUI.css" type="text/css" /> <link rel="stylesheet" href="media\css\jquery-ui-1.10.4.custom.css"/> <!-- general JavaScript --> <script type="text/javascript" src="media\js\jquery-1.11.0.js"></script> <script type="text/javascript" src="media\js\jquery-ui-1.10.4.custom.js"></script> <!-- latest version of DataTables --> <script type="text/javascript" src="media\js\jquery.dataTables.js"></script> <!-- DataTables plugin for table export--> <script type="text/javascript" src="media\js\ZeroClipboard.js"></script> <script type="text/javascript" src="media\js\TableTools.js"></script> <script type="text/javascript"> // Datatables $(document).ready( function () { $('#example').dataTable( { "bJQueryUI": true, "sPaginationType": "full_numbers", "sDom": 'T<"clear">lfrtip', "oTableTools": { "aButtons": [{ "sExtends": "csv", "bFooter": true }, { "sExtends": "pdf", "bFooter": true }, { "sExtends": "copy", "bFooter": true } ], "sSwfPath": "media/swf/copy_csv_xls_pdf.swf", }, } ); } ); </script> </head> <body > <table width="100%" border="0" cellpadding="0" cellspacing="0" class="display" id="example"> <thead> <tr> <th>Rendering engine</th> <th>Browser</th> <th>Platform(s)</th> <th>Engine version</th> <th>CSS grade</th> </tr> </thead> <tbody> <tr class="gradeX"> <td>Trident</td> <td>Internet Explorer 4.0</td> <td>Win 95+</td> <td class="center">4</td> <td class="center">X</td> </tr> <tr class="gradeC"> <td>Trident</td> <td>Internet Explorer 5.0</td> <td>Win 95+</td> <td class="center">5</td> <td class="center">C</td> </tr> <tr class="gradeA"> <td>Trident</td> <td>Internet Explorer 5.5</td> <td>Win 95+</td> <td class="center">5.5</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Trident</td> <td>Internet Explorer 6</td> <td>Win 98+</td> <td class="center">6</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Trident</td> <td>Internet Explorer 7</td> <td>Win XP SP2+</td> <td class="center">7</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Trident</td> <td>AOL browser (AOL desktop)</td> <td>Win XP</td> <td class="center">6</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Firefox 1.0</td> <td>Win 98+ / OSX.2+</td> <td class="center">1.7</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Firefox 1.5</td> <td>Win 98+ / OSX.2+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Firefox 2.0</td> <td>Win 98+ / OSX.2+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Firefox 3.0</td> <td>Win 2k+ / OSX.3+</td> <td class="center">1.9</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Camino 1.0</td> <td>OSX.2+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Camino 1.5</td> <td>OSX.3+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Netscape 7.2</td> <td>Win 95+ / Mac OS 8.6-9.2</td> <td class="center">1.7</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Netscape Browser 8</td> <td>Win 98SE+</td> <td class="center">1.7</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Netscape Navigator 9</td> <td>Win 98+ / OSX.2+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.0</td> <td>Win 95+ / OSX.1+</td> <td class="center">1</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.1</td> <td>Win 95+ / OSX.1+</td> <td class="center">1.1</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.2</td> <td>Win 95+ / OSX.1+</td> <td class="center">1.2</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.3</td> <td>Win 95+ / OSX.1+</td> <td class="center">1.3</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.4</td> <td>Win 95+ / OSX.1+</td> <td class="center">1.4</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.5</td> <td>Win 95+ / OSX.1+</td> <td class="center">1.5</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.6</td> <td>Win 95+ / OSX.1+</td> <td class="center">1.6</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.7</td> <td>Win 98+ / OSX.1+</td> <td class="center">1.7</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Mozilla 1.8</td> <td>Win 98+ / OSX.1+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Seamonkey 1.1</td> <td>Win 98+ / OSX.2+</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Gecko</td> <td>Epiphany 2.20</td> <td>Gnome</td> <td class="center">1.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>Safari 1.2</td> <td>OSX.3</td> <td class="center">125.5</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>Safari 1.3</td> <td>OSX.3</td> <td class="center">312.8</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>Safari 2.0</td> <td>OSX.4+</td> <td class="center">419.3</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>Safari 3.0</td> <td>OSX.4+</td> <td class="center">522.1</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>Google Chrome 1.0</td> <td>Win XP+</td> <td class="center">525</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>OmniWeb 5.5</td> <td>OSX.4+</td> <td class="center">420</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>iPod Touch / iPhone</td> <td>iPod</td> <td class="center">420.1</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Webkit</td> <td>S60</td> <td>S60</td> <td class="center">413</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 7.0</td> <td>Win 95+ / OSX.1+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 7.5</td> <td>Win 95+ / OSX.2+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 8.0</td> <td>Win 95+ / OSX.2+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 8.5</td> <td>Win 95+ / OSX.2+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 9.0</td> <td>Win 95+ / OSX.3+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 9.2</td> <td>Win 88+ / OSX.3+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera 9.5</td> <td>Win 88+ / OSX.3+</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Opera for Wii</td> <td>Wii</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Nokia N800</td> <td>N800</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>Presto</td> <td>Nintendo DS browser</td> <td>Nintendo DS</td> <td class="center">8.5</td> <td class="center">C/A<sup>1</sup></td> </tr> <tr class="gradeC"> <td>KHTML</td> <td>Konqureror 3.1</td> <td>KDE 3.1</td> <td class="center">3.1</td> <td class="center">C</td> </tr> <tr class="gradeA"> <td>KHTML</td> <td>Konqureror 3.3</td> <td>KDE 3.3</td> <td class="center">3.3</td> <td class="center">A</td> </tr> <tr class="gradeA"> <td>KHTML</td> <td>Konqureror 3.5</td> <td>KDE 3.5</td> <td class="center">3.5</td> <td class="center">A</td> </tr> <tr class="gradeX"> <td>Tasman</td> <td>Internet Explorer 4.5</td> <td>Mac OS 8-9</td> <td class="center">-</td> <td class="center">X</td> </tr> <tr class="gradeC"> <td>Tasman</td> <td>Internet Explorer 5.1</td> <td>Mac OS 7.6-9</td> <td class="center">1</td> <td class="center">C</td> </tr> <tr class="gradeC"> <td>Tasman</td> <td>Internet Explorer 5.2</td> <td>Mac OS 8-X</td> <td class="center">1</td> <td class="center">C</td> </tr> <tr class="gradeA"> <td>Misc</td> <td>NetFront 3.1</td> <td>Embedded devices</td> <td class="center">-</td> <td class="center">C</td> </tr> <tr class="gradeA"> <td>Misc</td> <td>NetFront 3.4</td> <td>Embedded devices</td> <td class="center">-</td> <td class="center">A</td> </tr> <tr class="gradeX"> <td>Misc</td> <td>Dillo 0.8</td> <td>Embedded devices</td> <td class="center">-</td> <td class="center">X</td> </tr> <tr class="gradeX"> <td>Misc</td> <td>Links</td> <td>Text only</td> <td class="center">-</td> <td class="center">X</td> </tr> <tr class="gradeX"> <td>Misc</td> <td>Lynx</td> <td>Text only</td> <td class="center">-</td> <td class="center">X</td> </tr> <tr class="gradeC"> <td>Misc</td> <td>IE Mobile</td> <td>Windows Mobile 6</td> <td class="center">-</td> <td class="center">C</td> </tr> <tr class="gradeC"> <td>Misc</td> <td>PSP browser</td> <td>PSP</td> <td class="center">-</td> <td class="center">C</td> </tr> <tr class="gradeU"> <td>Other browsers</td> <td>All others</td> <td>-</td> <td class="center">-</td> <td class="center">U</td> </tr> </tbody> <tfoot> <tr> <th>Rendering engine</th> <th>Browser</th> <th>Platform(s)</th> <th>Engine version</th> <th>CSS grade</th> </tr> </tfoot> </table> </body>
"sSwfPath": "http://datatables.net/release-datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
"oTableTools": {