What's New in Ignite UI for React - The Complete Microsoft Excel Solution

Daizen Ikehara / Friday, February 15, 2019

As part of our Ignite UI for React release (take a peek at our general overview blog or our blogs on the React Data Grid and React Data Chart) the native React UI toolset includes numerous controls to build modern experiences for web and mobile.

In this blog, I'll highlight all of the Microsoft Excel capabilities that Ignite UI for React provides in our release.

The Complete Microsoft Excel Solution

Ignite UI for React includes the most complete Microsoft Excel solution on the market. With zero dependencies, you can deliver a complete Excel experience in a native React application, including support for more than 300 formulas, import & export data from any source, rich reporting with charts, and more.

Infragistics Excel Engine

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

Key features of Infragistics Excel Engine:

  • No Excel Dependency - The Infragistics Excel Engine runs completely independently of Microsoft Excel, so you do not require it to be installed.
  • Workbook Object Model - This represents all the Excel objects available to you, such as Workbooks, Worksheets, Cells, Formulas and many more.

We provide objects used in Excel with APIs so that you can access and manipulate Excel data.


The most important object found within Infragistics' Excel assembly is the Workbook object. Without a Workbook instance, you simply cannot create a Microsoft® Excel® file. A workbook contains a collection of worksheets, and each worksheet holds a grid of data in cells. In addition, the Workbook object contains global settings and collections of custom views, named references, and styles. The global settings on the Workbook are options that affect a workbook as a whole, such as the author of the document. Most of the primitive properties exposed off the Workbook object control various formula calculation options. You can also protect the structure of the workbook using the protection feature by setting passwords. 


Worksheets fill workbooks. A workbook must have at least one Worksheet visible at all times. The worksheet contains the actual data in a workbook, as each worksheet holds a grid of cells and each cell can hold a form of data. Aside from the collections and complex properties on the worksheet, the Worksheet object includes properties to change its default row and column sizes, its image background (tiled across the worksheet), and its name. Here are popular worksheet features

  • Gridlines
  • Headers
  • Freezing and Splitting Panes
  • Worksheet Filtering
  • Worksheet Conditional Formatting
  • Worksheet Sorting


The WorksheetCell objects in an Excel worksheet is the object that holds your actual data values for the worksheet. This object provides common features for Excel cells.

  • Comments
  • Formulas
  • Cell Formats
  • Copying a Cell’s Format
  • Merging Cells

Infragistics Excel Engine also provides Excel Charts and Sparklines support. What this means is that you can create Excel’s native charts / sparklines with the engine. They are not images. After saving the Excel object to a file and then open with Excel application, you can still interact those generated charts/sparklines.

Chart support

The Infragistics Excel Engine's WorksheetChart functionality allows you to add visual charting representations of data trends across regions of cells in a worksheet. For example, if you want to see your Excel data in a region of cells visualized as a column, line, or over 70 other chart types, this feature can help you to achieve that.
Ignite UI for React - Excel Engine - Charts

Sparklines support

The Infragistics Excel Library has support for adding sparklines to an Excel Worksheet. These can be used to show simple visual representations of data trends across a region of cells of data in your worksheet. For example, if you wanted to see your Excel data across a particular cell region visualized as a simple column or line sparkline chart, this feature can help you to achieve that.

The following is a list of the supported predefined sparkline types.

  • Line
  • Column
  • Stacked (Win/Loss)

Ignite UI for React - Excel Engine - Sparklines

Get Started with Ignite UI for React

To get started with Ignite UI for React, you can visit the product page and browse the online sample. You can also download a project that includes samples that can run on your local environment with npm packages.

Happy Coding!

Ignite UI for React