Spreadsheet（电子试算表）

最新推荐文章于 2024-08-09 07:34:23 发布

菜鸟kevin的成长日记

最新推荐文章于 2024-08-09 07:34:23 发布

阅读量440

点赞数

分类专栏： js之jqwidgets

js之jqwidgets 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

unbound mode feature （自由的模式）




    In this demo is illustrated how to use the jqxGrid's unbound mode feature to create a Spreadsheet.
     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/jqxdata.export.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.edit.js"></script>  
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.selection.js"></script> 
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.columnsresize.js"></script> 
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.export.js"></script> 
    <script type="text/javascript" src="../../scripts/demos.js"></script>
     <script type="text/javascript">
         $(document).ready(function () {
         
             // renderer for grid cells.
             var numberrenderer = function (row, column, value) {
                 return '
   
   
    
    ' + (1 + value) + '
   
   ';
             }
             
             
             // create Grid datafields and columns arrays.
             var datafields = [];
             var columns = [];
             for (var i = 0; i < 26; i++) {
                 var text = String.fromCharCode(65 + i);
                 if (i == 0) {
                     var cssclass = 'jqx-widget-header';
                     if (theme != '') cssclass += ' jqx-widget-header-' + theme;
                     columns[columns.length] = {pinned: true, exportable: false, text: "", columntype: 'number', cellclassname: cssclass, cellsrenderer: numberrenderer };
                 }
                 datafields[datafields.length] = { name: text };
                 columns[columns.length] = { text: text, datafield: text, width: 60, align: 'center' };
             }
             var source =
            {
                unboundmode: true,
                totalrecords: 100,
                datafields: datafields,
                updaterow: function (rowid, rowdata) {
                    // synchronize with the server - send update command   
                }
            };
             var dataAdapter = new $.jqx.dataAdapter(source);
             // initialize jqxGrid
             $("#jqxgrid").jqxGrid(
            {
                width: 850,
                source: dataAdapter,
                editable: true,
                columnsresize: true,
                selectionmode: 'multiplecellsadvanced',
                columns: columns
            });
            $("#excelExport").jqxButton({ theme: theme });
            $("#excelExport").click(function () {
                $("#jqxgrid").jqxGrid('exportdata', 'xls', 'jqxGrid', false);
            });
        });
    </script>