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

This sample demonstrates how to configure the display content and the default value when importing the CSV (XLS, XLSX) file.

function excelCSVImport() {
  var option = {
    layoutChangeOption:0,
    headerRowCount:3,
    headerRowCountVisible:true,
    UTF8:false,
    UTF8Visible:false,
    useGroupedColumn:true,
    csvDefaultCharSet: "utf-8"
  };

  gridRoot.excelCSVImport(0, "https://www.koolchart.com/koolgrid/server/importCSV.php");
}
layoutChangeOption layout change options - 0 : ask to the user, 1 : import data in the current layout, 2 : import data by reconfiguring the layout
headerRowCount It sets the default value of the number of the header rows.
headerRowCountVisible Whether or not to display the number of the header rows.
UTF8 It sets the default value of the UTF8 checkbox.
UTF8Visible Whether or not to display the UTF8 checkbox
useGroupedColumn Whether or not to create the group column. if it is set to "false", then a single-line column will be created.
csvDefaultCharSet CSV file encoding

© 2017 KoolChart. All rights reserved.