Available in the Full Version

Javascript Excel > Import Data From Excel

  1. Download this sample Excel file
  2. Click Choose File/Browse button below and pick the sample Excel file or another excel file.

This sample is designed for a larger screen size.

On mobile, try rotating your screen, view full size, or email to another device.

This sample shows how to populate igGrid from excel worksheet using the Ignite UI JavaScript Excel library. The excel file is read into Uint8Array object and then this object is passed to the load method exposed by the excel library. Once we have the worksheet loaded into the excel library object we can read each cell value and build a json array that will be used as the igGrid data source. It is required that the data in the excel file start from A1 cell. First row values are used to build column defitinitons array for the igGrid, but one can leave the grid auto generate the columns as well.

Code View

Copy to Clipboard