Next
Update
Prev
Import
Scan Record
Change History
Change History (XML)

This sample demonstrates how to import the Excel file (xls,xlsx) into the grid. (This feature is implemented using an open source, SheetJS, and jszip.min.js, xlsx.min.js and shim.js(IE8 and Below) must be included.)

Try to click on the "Import" button and enter the line number of the data you want to add and select the file by clicking on the "Choose file" button. If you click on the "Scan Each Record" button, then you will be able to view the imported data.

function excelImport() {
  var option = {
    layoutChangeOption:0,
    headerRowCount:3,
    headerRowCountVisible:true,
    useGroupedColumn:true
  };

  gridRoot.excelImport(option, "https://www.koolchart.com/koolgrid/server/importExcel.php");
}

© 2017 KoolChart. All rights reserved.