• Support for multiple data sources

    Bind with DataSet/Data Table/Custom Object/Variable or Array/List.

  • Simple language syntax and notations in Excel Templates

    Create Excel templates, define Data fields, inline fields, formulas, and display nested data and expression fields.

  • Expand data horizontally or vertically

    Expand data horizontally or vertically depending on the report layout, using simple property.

  • Define Context or range for data expansion

    Expand data in pairs and calculate formulas over a cell context or a range.

  • Group, Sort, Merge your data

    Group or set outline groups over your data with Repeat, Merge, or List properties and sort data in Ascending or Descending order.

  • Set Styles

    Set cell and merge style to preserve data upon cell expansion.

Create multiple reports in a single sheet

Create templates that include data from one or multiple data sources to generate reports with multiple tables.

Add page breaks

Similar to page breaks in Microsoft Excel, you can add vertical, horizontal, or both.

Generate multiple worksheets

Define template field in worksheet's name and generate multiple worksheets at runtime, each having a fixed template.

Mail-merge reports

Add inline fields to generate full mail-merge reports with Excel templates.

Explore the advanced features of this spreadsheet API

Click through to view the code, generate the spreadsheet, and download the sample