Available in the Full Version

Javascript Excel - Import Data From Excel

This sample shows how to populate igGrid from excel worksheet using the Ignite UI JavaScript Excel library.
  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.

The Excel file is read into Uint8Array object, which is then passed to the load method exposed by the Excel library. Once the worksheet is 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. The data in the Excel file must start from the A1 cell. First-row values are used to build column definitions array for the igGrid, but you can also let the grid auto-generate the columns.

Code View

Copy to Clipboard