DataTable TableTools初始化 [英] DataTable TableTools initialisation

问题描述

通过以下导入，我可以执行数据表功能:

With following imports, I have my datatable functioning:

<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css"
    href="<c:url value="css/jquery.themeroller.css" />" />
<!-- TableTools CSS -->
<link rel="stylesheet" type="text/css"
    href="<c:url value="css/TableTools_JUI.css" />" />

<!-- jQuery -->
<script type="text/javascript" charset="utf8"
    src="jQuery/jquery-1.8.2.min.js"></script>

<!-- DataTables -->
<script type="text/javascript" charset="utf8"
    src="jQuery/jquery.dataTables.min.js"></script>

<!-- TableTools -->
<script type="text/javascript" charset="utf8"
    src="jQuery/TableTools.js"></script>
<script type="text/javascript" charset="utf8"
    src="jQuery/ZeroClipboard.js"></script>

我现在正在尝试为表提供tabletools选项(打印，保存，复制，xls按钮). 我已经插入

I am now trying to have tabletools options (print, save, copy, xls buttons) for my table. I have inserted

oTable = $('#myTable').dataTable({
        "bJQueryUI" : true,
        "iDisplayLength" : 10,
        "sPaginationType" : "full_numbers",
        "aaSorting" : [ [ 7, "desc" ] ],
        "sDom": '<"H"lfr>t<"F"ip>' )}

但没有变化.

我是否需要更改任何导入查询或添加CSS或其他东西才能使tabletool工作? 我已经尝试过"sDom":

Do I have to change any of import queries or add css or something to get tabletools working? I have tried "sDom":

"sDom": '<"H"lfr>t<"F"ip>'
"sDom": '<"H"lfrT>t<"F"ip>', 
"sDom": '<"H"lfr>t<"F"ip>T',

我有这个用于sSwfPath:

I had this for sSwfPath:

"C:/JAVA ENVIRONMENT/Workspace/Test/DisplayTable3/DataTables-1.9.4/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"

一无所有

预先感谢

推荐答案

更改"C:/JAVA环境/工作区/测试/DisplayTable3/DataTables-1.9.4/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf" 到您的网络服务器上的网络路径.这是与瑞士法郎安全相关的常见问题.在DataTables网站上找到它.您也不能重新声明sDom.

Change "C:/JAVA ENVIRONMENT/Workspace/Test/DisplayTable3/DataTables-1.9.4/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf" to a web path on your webserver. It's a common problem related to swf security. Found it on DataTables website. Also you can't redeclare sDom.

这是我在TableTools和ColVis上的工作代码:

This is my working code with TableTools and ColVis:

$(document).ready( function () {
    $('#results').dataTable( {
        "sDom": 'T<"clear">Clfrtip',

        "oTableTools": {
            "sSwfPath": "http://192.168.78.7/cdtc/app/custom/libs/DataTables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",

这篇关于DataTable TableTools初始化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！