This sample uses CTP (Community Technical Preview) features. The API and behavior may change when these features are released with full support.
- Download this sample Excel file
- Click Choose File/Browse button below and pick the sample Excel file or another excel file.
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.