Tabulator

本家サイト: tabulator

データダウンロード可能(csv:json:pdf他) : tabulator download

JSONデータ読み込み

  var sampleData = [
    {id:1, name:"Oli Bob", progress:12, gender:"male", rating:1, col:"red", dob:"", car:1, lucky_no:5, cheese:"Cheader"},
    {id:2, name:"Mary May", progress:1, gender:"female", rating:2, col:"blue", dob:"14/05/1982", car:true, lucky_no:10, cheese:"Gouda"},
    {id:3, name:"Christine Lobowski", progress:42, gender:"female", rating:0, col:"green", dob:"22/05/1982", car:"true", lucky_no:12, cheese:"Manchego"},
    {id:4, name:"Brendon Philips", progress:100, gender:"male", rating:1, col:"orange", dob:"01/08/1980", lucky_no:18, cheese:"Brie"},
    {id:5, name:"Margret Marmajuke", progress:16, gender:"female", rating:5, col:"yellow", dob:"31/01/1999", lucky_no:33, cheese:"Cheader"},
  ];

  var table1 = new Tabulator("#tabulator0", {
    data:sampleData,
    columns:[
        {title:"Name", field:"name", sortable:true, width:200},
        {title:"Progress", field:"progress", sortable:true, sorter:"number"},
        {title:"Gender", field:"gender", sortable:true},
        {title:"Favourite Color", field:"col", sortable:false},
        {title:"Date Of Birth", field:"dob"},
        {title:"Cheese Preference", field:"cheese"},
      ],
});


Column Groups

var table2 = new Tabulator("#columnGroups", {
    columnVertAlign:"bottom", //align header contents to bottom of cell
    columns:[
    {title:"Name", field:"name", width:160},
    {//create column group
        title:"Work Info",
        columns:[
        {title:"Progress", field:"progress", align:"right", sorter:"number", width:100},
        {title:"Rating", field:"rating", align:"center", width:80},
        {title:"Driver", field:"car", align:"center", width:80},
        ],
    },
    {//create column group
        title:"Personal Info",
        columns:[
        {title:"Gender", field:"gender", width:90},
        {title:"Favourite Color", field:"col", width:140},
        {title:"Date Of Birth", field:"dob", align:"center", sorter:"date", width:130},
        ],
    },
    ],
});