React Excel Library Overview

The Infragistics React Excel Library allows you to work with spreadsheet data using familiar Microsoft® Excel® spreadsheet objects like Workbook, Worksheet, Cell, Formula and many more. The Infragistics React Excel Library makes it easy for you to represent the data of your application in an Excel spreadsheet as well as transfer data from Excel into your application.

React Excel Library Example

Dependencies

When installing the excel package, the core package must also be installed.

npm install --save igniteui-react-core
npm install --save igniteui-react-excel

Component Modules

The React excel library requires the following modules:

import { IgrExcelModule } from 'igniteui-react-excel';

IgrExcelModule.register();

Supported Versions of Microsoft Excel

The following is a list of the supported versions of Excel.**

• Microsoft Excel 97

• Microsoft Excel 2000

• Microsoft Excel 2002

• Microsoft Excel 2003

• Microsoft Excel 2007

• Microsoft Excel 2010

• Microsoft Excel 2013

• Microsoft Excel 2016

Load and Save Workbooks

Now that the Excel Library module is imported, next step is to load a workbook.

In the following code snippet, an external ExcelUtility class is used to save and load a Workbook.

In order to load and save Workbook objects, you can utilize the Save method of the actual Workbook object, as well as its static Load method.

import { Workbook } from "igniteui-react-excel";
import { WorkbookSaveOptions } from "igniteui-react-excel";
import { WorkbookFormat } from "igniteui-react-excel";
import { ExcelUtility } from "ExcelUtility";

var workbook = ExcelUtility.load(file);
ExcelUtility.save(workbook, "fileName");

API References