import data (easyui datagrid, jQuery)

 

1.read excel to json jquery:

http://jsfiddle.net/d2atnbrt/3/

2. easyui data grid load json file

http://jsfiddle.net/xAnDj/

<div id="buttondiv" >

  <input type="file" id="inputfile" />

  <input type="button" id="viewfile" value="Import file" />

</div>

<table class="easyui-datagrid", id="dg">

    <thead>

        <tr>

            <th data-options="field:'EmpID'">EmpID</th>

            <th data-options="field:'EmpName'">EmpName</th>

            <th data-options="field:'test'">test</th>

        </tr>

    </thead>

</table>

===============

var empData = [

{"EmpID":289,"EmpName":"\u66f9\u6587\u771f","test":"test1"},

{"EmpID":290,"EmpName":"\u675c\u6c38\u5f3a","test":"test1"},

{"EmpID":291,"EmpName":"\u51af\u7acb\u660e","test":"test1"},

 

];

$('#dg').datagrid({

 data:empData, 

});

http://jsfiddle.net/gh/get/jquery/1.9.1/igniteuisamples/jsfiddle-samples/tree/master/EN/HtmlSamples/javascript-excel-library/excel-import-data/