jQuery仿Excel表格編輯功能的實作代碼_jquery

   
   

//資料
            var data = [
                      {id: 2, name : "約翰", isActive: false, 顏色: "黑色"},
              {id: 3, 姓名: "Al 名稱: "Ben", isActive: false, color: "blue"}
            ];
        unction (instance, td, row, col, prop, value, cellProperties) {
              Handsontable.TextCell.renderer.apply(this, argument);
              背景: '黃色'
              });
       //綠色渲染方法
            var greenRenderer = function (instance, td, row, col, prop, value,cellPropertcheap   ;
              $(td }).css({
                背景: '綠色'
                     // 初始化
            var $container = $("#範例1");              資料：數據，
          s: true,
              minSpareRows: 1,
          ”}，
                {data: "name", type: {renderer: YellowRenderer}}, //黃色渲染
   
                { 資料: "color",
                  type: Handsontable.AutocompleteCell, //自動完成者
   green", "blue", "gray", "black " , "white"] //資料來源
                }
          row, col, prop) {
                if (row === 0 && col === 0) {
                                  }
            });


注意是div容器載入完了之後進行初始化：

demo代碼：