當前位置: 首頁>>代碼示例 >>用法及示例精選 >>正文

jQWidgets jqxGrid exportdata()用法及代碼示例


jQWidgets是一個 JavaScript 框架，用於為 PC 和移動設備製作基於 Web 的應用程序。它是一個非常強大、優化、獨立於平台且得到廣泛支持的框架。這江青網格用於說明以表格形式顯示數據的 jQuery 小部件。此外，它還全麵支持數據連接、分頁、分組、排序、過濾和編輯。

exportdata() 方法用於將顯示的 jqxGrid 中加載的每一行導出到 XLS、XML、CSV、TSV、HTML 或 JSON 中。它不返回任何內容。

注意：為了將數據導出為 PDF，需要支持 HTML5 的瀏覽器。

用法:

$('Selector').jqxGrid('exportdata', "xml", "jqxGrid");

參數值：

  • dataType:這是規定的出口類型。可能的值為‘xls’、“XML”、‘html’、“JSON”、‘pdf’, ‘tsv’ 或“CSV”。它是字符串類型。
  • fileName:這是文件的指定名稱。如果未給出文件名，則顯示的 jqxGrid 必須將加載的數據導出到本地變量中。它是字符串類型。
  • exportHeader:它是一個可選參數，有助於指定是否導出列標題。但是，默認情況下，導出器會導出列標題。它是布爾類型。
  • rows:它是要導出的指定行數組。但是，默認情況下會導出每一行。為了導出每一行，該參數的值必須設置為空。它是數組類型的可選參數。
  • exportHiddenColumns:它有助於指定是否導出隱藏列。此外，默認情況下，導出器不會導出隱藏列。它是一個布爾類型的可選參數。
  • serverURL:它有助於指定導出服務器的 URL。導出器通過 jQWidgets 服務器呈現。它是字符串類型。
  • charSet:它指定字符集。它是一個可選參數，類型為 String。

鏈接文件：下載jQWidgets從給定的鏈接。在 HTML 文件中，找到下載文件夾中的腳本文件。

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery-1.11.1.min.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqx-all.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/jqxmenu.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxgrid.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxgrid.selection.js”></script>

示例 1：下麵的例子說明了jqxGridexportdata()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-1.11.1.min.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/jqxmenu.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxgrid.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxgrid.selection.js"> 
    </script> 
      <script type="text/javascript" 
            src="jqwidgets/jqxgrid.columnsresize.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color: green"> 
            GeeksforGeeks 
        </h1>         
        <h3> 
              jQWidgets jqxGrid exportdata()  
            method 
        </h3><br />       
        <div id="jqxg"></div>        
        <div> 
            <input type="button" 
                   id="jqxBtn" 
                   style="margin-top: 25px" 
                   value="Click here" /> 
        </div>         
        <div id="log"></div>       
    </center> 
  
    <script type="text/javascript"> 
        $(document).ready(function () { 
            var d = new Array(); 
            var subjectNames = 
                ["C++", "Scala", "Java", "C", "R", "JavaScript"]; 
  
            var pageNumber = 
                ["7", "8", "12", "11", "10", "19"]; 
  
            for (var j = 0; j < 50; j++) { 
                var r = {}; 
                r["subjectnames"] = 
                    subjectNames[(Math.floor( 
                        Math.random() * subjectNames.length)) 
                    ]; 
  
                r["pagenumber"] = 
                    pageNumber[(Math.floor( 
                        Math.random() * pageNumber.length)) 
                    ]; 
                d[j] = r; 
  
            } 
            var src = { 
                localdata: d, 
                datatype: "array", 
            }; 
            var data_Adapter = new $.jqx.dataAdapter(src); 
            $("#jqxg").jqxGrid({ 
                source: data_Adapter, 
                theme: 'energyblue', 
                height: "210px", 
                width: "240px", 
                columns: [ 
                    { 
                        text: "Subject Name", 
                        datafield: "subjectnames", 
                        width: "120px", 
                    }, 
                    { 
                        text: "Page No.", 
                        datafield: "pagenumber", 
                        width: "120px", 
                    }, 
                ], 
            }); 
  
            $("#jqxBtn").jqxButton({ 
                width: "180px", 
                height: "30px", 
            }); 
            $("#jqxBtn").on("click", function () { 
                $('#jqxg').jqxGrid('exportdata', "json", "jqxGrid"); 
                $("#log").text("Data exported to json!"); 
            }); 
        }); 
    </script> 
</body> 
  
</html>

輸出：

示例 2：下麵是另一個說明 jqxGrid 的示例exportdata()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-1.11.1.min.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/jqxmenu.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxgrid.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxgrid.selection.js"> 
    </script> 
      <script type="text/javascript" 
            src="jqwidgets/jqxgrid.columnsresize.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color: green"> 
            GeeksforGeeks 
        </h1>         
        <h3> 
              jQWidgets jqxGrid exportdata()  
            method 
        </h3><br />       
        <div id="jqxg"></div>        
        <div> 
            <input type="button" 
                   id="jqxBtn" 
                   style="margin-top: 25px" 
                   value="Click here" /> 
        </div>         
        <div id="log"></div>       
    </center> 
  
    <script type="text/javascript"> 
        $(document).ready(function () { 
            var d = new Array(); 
            var subjectNames = 
                ["C++", "Scala", "Java", "C", "R", "JavaScript"]; 
  
            var pageNumber = 
                ["7", "8", "12", "11", "10", "19"]; 
  
            for (var j = 0; j < 50; j++) { 
                var r = {}; 
                r["subjectnames"] = 
                    subjectNames[(Math.floor( 
                        Math.random() * subjectNames.length)) 
                    ]; 
  
                r["pagenumber"] = 
                    pageNumber[(Math.floor( 
                        Math.random() * pageNumber.length)) 
                    ]; 
                d[j] = r; 
  
            } 
            var src = { 
                localdata: d, 
                datatype: "array", 
            }; 
            var data_Adapter = new $.jqx.dataAdapter(src); 
            $("#jqxg").jqxGrid({ 
                source: data_Adapter, 
                theme: 'energyblue', 
                height: "210px", 
                width: "240px", 
                columns: [ 
                    { 
                        text: "Subject Name", 
                        datafield: "subjectnames", 
                        width: "120px", 
                    }, 
                    { 
                        text: "Page No.", 
                        datafield: "pagenumber", 
                        width: "120px", 
                    }, 
                ], 
            }); 
  
            $("#jqxBtn").jqxButton({ 
                width: "180px", 
                height: "30px", 
            }); 
            $("#jqxBtn").on("click", function () { 
                var ed = $('#jqxg').jqxGrid('exportdata', "html"); 
                if (ed === null) { 
                    $('#log').text("Data not exported!"); 
                } 
                else { 
                    $('#log').text("Data exported!"); 
                } 
            }); 
        }); 
    </script> 
</body> 
  
</html>

輸出：

參考： https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm?search=



相關用法


注：本文由純淨天空篩選整理自nidhi1352singh大神的英文原創作品 jQWidgets jqxGrid exportdata() Method。非經特殊聲明，原始代碼版權歸原作者所有，本譯文未經允許或授權，請勿轉載或複製。