当前位置: 首页>>代码示例 >>用法及示例精选 >>正文

jQWidgets jqxDataTable exportSettings属性用法及代码示例


jQWidgets是一个 JavaScript 框架，用于为 PC 和移动设备制作基于 Web 的应用程序。它是一个非常强大、优化、独立于平台且得到广泛支持的框架。这jqx数据表用于读取和显示来自的数据HTML 表格。它还用于显示来自各种数据源(例如 XML、JSON、Array、CSV 或 TSV)的数据。

exportSettings 属性用于设置或返回每当调用exportData 方法时显示的jqxDataTable 使用的数据的导出设置。它是对象类型，默认值为{columnsHeader: true,hiddenColumns: false, serverURL: null,characterSet: null,recordsInView: true, fileName:“jqxDataTable”}。

这里使用的参数列表如下：

  • columnsHeader:它用于确定是否导出列标题。
  • hiddenColumns:它用于确定是否导出隐藏列。
  • serverURL:它用于确定服务器的 URL。
  • characterSet:它用于确定字符集。
  • recordsInView:它用于确定是否要导出所有记录，或者还考虑过滤和排序。
  • fileName:它用于确定文件的名称。

用法:

设置导出设置属性。

$('Selector').jqxDataTable({ 
    exportSettings: { hiddenColumns: true }
});

返回导出设置属性。

var exportSettings = 
    $('Selector').jqxDataTable('exportSettings');

链接文件：下载jQWidgets从给定的链接。在 HTML 文件中，找到下载文件夹中的脚本文件。

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxlistbox.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdropdownlist.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdatatable.js”></script>

示例 1：下面的例子说明了jqxDataTable导出设置jQWidgets 中的属性。

HTML


<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" 
          type="text/css"/> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable 
            exportSettings Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" style="margin:29px;" 
               id="jqxbtn" value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                exportSettings: { 
                    columnsHeader: true 
                }, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var es = $('#Data_Table') 
                    .jqxDataTable('exportSettings'); 
                $('#log').text(es.columnsHeader); 
            }); 
        }); 
    </script> 
</body> 
  
</html>

输出：

示例 2：下面是jqxDataTable的另一个例子导出设置jQWidgets 中的属性。

HTML


<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" 
          type="text/css"/> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable 
            exportSettings Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" style="margin:29px;" 
               id="jqxbtn" value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                exportSettings: { 
                    hiddenColumns: false 
                }, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var es = $('#Data_Table') 
                    .jqxDataTable('exportSettings'); 
                if (es === null) { 
                    $('#log').text("Null!"); 
                } 
                else { 
                    $('#log').text("Not null!"); 
                } 
            }); 
        }); 
    </script> 
</body> 
  
</html>

输出：

参考： https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxdatatable/jquery-datatable-api.htm



相关用法


注：本文由纯净天空筛选整理自nidhi1352singh大神的英文原创作品 jQWidgets jqxDataTable exportSettings Property。非经特殊声明，原始代码版权归原作者所有，本译文未经允许或授权，请勿转载或复制。