Build Professional .NET Excel Reports using .XLSX Templates

Define Excel templates in .NET to automate and generate comprehensive .xlsx reports such as invoices, sales reports, receipts, shipping labels, purchase orders, and more.

  • Generate professional Excel reports advanced layouts
  • Create reports from Chart templates, Sparklines, Tables
  • Bind data from multiple data sources
  • Supports reporting features to arrange/calculate data in Excel templates
  • Define global settings for Template processing
  • No need to learn complex API to generate reports - use simple language syntax to define Templates
  • Edit the Templates anytime you want
  • Supports Microsoft Excel formulas for fast data calculation and conditional formatting
  • Generate .XLSX or .PDF reports
  • Generate reports for any platform - Windows, Linux, or macOS
DOWNLOAD FREE TRIAL (V 5.2.2)

Support for Multiple Data Sources

Bind with dataset/data table/custom object/variable or array/list.

Expand Data Horizontally or Vertically

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

Group, Sort, and 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.

Simple Language Syntax and Notations

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

Define Context or Range for Data Expansion

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

Set Styles

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

Generate Tax Forms

Use the 'form' property to define PDF Form Fields and related properties within Excel Templates. Generate bound, un-bound PDF Forms.

Employee Management

Create Excel templates to bind with employee data, define conditional formatting on template cells and see your data expand.

Sales Tracker

Create an Excel chart template and bind with data. Configure the chart series name, values and axis label to the template cells. Your data will always be updated when the underlying database expands.

Product Catalogs

Create product catalogs with multiple images, bind Excel templates with database having images. Add price values, descriptions of products and see your data expand into a full Excel report.

Logistics Reports

Generate reports at high speed-replace manual tasks of creating invoices, purchase, and shipping orders. Create the invoice template and see your data expanding and following the invoice layout.

Financial Reports

Customize templates as per your needs and generate financial dashboards, budget analysis, cash flow reports, and more.

Sales Reports

Define fields in complex Tablix-type templates to generate full sales report analyzes for one year. You do not have to enter data in each cell. Define the template fields and see how your data expands with few lines of code.

Top Features

Expand Templates with Sparklines

Define the data binding of Sparklines with template cells.

 

Expand Templates with Excel Tables

Expand Templates by defining Templates in Tables cells.

 

Generate Excel Reports with Fixed Layout

Use FillMode and FillRange to control layout of the report.

 

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 expanding mail-merge reports with Excel templates.

 

Excel Chart Templates

Bind Excel charts with data by defining the chart template for the series data. The charts will bind to data upon processing of the template.

Bind Excel Templates with Images

Bind your Excel templates with Image fields in the database.

                                                                                                                                    

Support for Conditional Formatting

Set conditional formatting rules for the template cells and expand your data. All types of conditional formatting rules are supported.

 

 

Export Excel Formula

Export the formula you applied to your template to see how it applies to the expanded data. Re-use the formula in an existing file or another Excel file.

 

 

Support for Global Setting

Specify default settings on the Excel Template so that it applies to the entire data when the template expands. Keep the height/width of rows/columns similar throughout the template. Insert extra spaces as rows/columns or cells in your final report. Or create paginated reports.

Convert Excel Templates to PDF Forms with HTML5 Input Types

GcExcel .NET Excel Library provides tools to create templates and define form fields in the templates, and utilize validation in the fields to ensure data accuracy and consistency. Messages can be assigned based on the validation type, like required fields or specific format types.

Explore the Advanced Features Excel API

Each main feature demo link listed below contains several demos that show how to use a particular feature. Click a link to learn more.

Feature

Description

Showcase Explore complete code demonstrating how to generate an Excel file, or you may have your own Excel files and just want to open and update some of its contents at server side.
Quick Start In this tutorial, we create a real-life scenario with GrapeCity Documents for Excel to give you a fundamental understanding of what it can do.
Range Operations Execute operations on cells, rows or columns in Excel documents with the help of Range property of the IWorksheet interface.
Formatting GcExcel provides many properties to customise the appearance of a range.
Tables Manage Tables independently in Excel worksheets, format rows & columns, perform calculations for a specific table range.
Conditional Formatting Create conditional formatting rules for individual cells or a range of cells based on cell values.
Data Validation Validate data by restricting the information format and the values that can be entered in cells of a worksheet. Create distinct validation scenarios for individual cells or for a range of cells.
Formulas Create and use 450+ built-in functions formulas that let you calculate the value of a cell quickly and accurately. You can also use built-in functions and operators to generate formulas and calculate values in cells.
Grouping Summarise large amounts of information in groups so that complex spreadsheets are easier to navigate. You can expand and collapse details with the click of a button in the group header row.
Barcode GcExcel provides API to add barcodes in worksheets. Create and use 11 types of barcodes to enable scanning information easily and quickly within your PDF template.
Cell Rich Text Apply rich text formatting in the cells of the worksheet.
Custom Functions Create your own custom functions, allowing you to easily create any custom arithmetic logic you may need.
Data binding GcExcel supports one-way data binding with cell, sheet and Table binding in Excel spreadsheets.
Find and replace Find and replace text in Excel workbook with different options.
Form Controls GcExcel supports Form Controls, like buttons, check boxes, drop downs and more, to collect and present data in your spreadsheet.
HTML Exporting GcExcel allows users to export a workbook, worksheet, or any specific range to an HTML file making it convenient to publish and share spreadsheet data on a website.
Image Exporting Explore complete code demonstrating how to export sheet/range/shape/chart to image files at server side.
JSON GcExcel .NET supports the import and export of a json stream using .NET core. A JSON file can also be used as the data source of a GcExcel Template.
Page Setup Specify page setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook.
PDF Exporting Export Excel .xlsx spreadsheets to PDF at server side with various PDF options.
Pivot Charts GcExcel allows you to create a PivotChart in the worksheet. PivotCharts provide graphical representations of the data in their associated PivotTables. PivotCharts are also interactive, allowing users to filter and sort the underlying data.
Digital Signatures GcExcel allows users to add digital signatures to Excel spreadsheets to make them authentic and easier to validate.
SpreadJS Features GcExcel supports features to interact with SpreadJS (a comprenehsive enterprise JavaScript solution developed by GrapeCity) by json in a lossless way.
Filtering GcExcel supports all types of filters which you can apply on selected range of data.
Sorting GcExcel provides the Sort method to perform data sorting based on a range of cells, range by value, color or icon in a worksheet. The Apply method is used to apply the selected sort state and display the results.
SparklineEx GcExcel provides a way to visualize data at the cell level with SparklineEx.
Sparklines GcExcel supports adding sparklines in template layout, which are visible in the Excel report generated after processing the template. A sparkline referring to template cells, will be copied and adjusted accordingly after template processing.
Charts GcExcel provides a comprehensive charting API to add charts in Excel.
Shape Embed drawing objects like shapes and pictures in the cells of a worksheet. You can insert arrows, lines, charts, slicers, pictures, and general shapes.
Picture Add a picture to a worksheet, use the AddPicture method of the worksheet's Shapes collection to create, delete, cut, copy and duplicate pictures in the worksheet.
Slicer Slicers are visual filters that you can use to filter a table or pivot table. GcExcel supports adding both built-in and custom slicer styles in Excel workbook.
Comments GcExcel enables users to annotate worksheets, write comments for cells to add information about the data it contains.
Pivot Table Add pivot table to Excel workbook for data summarization, automatically count, total, or average the data stored in a spreadsheet, and display the resulting summarized data in a second table.
Hyperlinks Apply hyperlinks to a range using the IWorksheet.Hyperlinks.Add or IRange.Hyperlinks.Add method. Apply hyperlinks to a shape using the IWorksheet.Hyperlinks.Add method.
Theme GcExcel provides you with a set of built-in themes so you can quickly change the overall appearance of a workbook. It also lets you create custom themes and apply them to workbooks.
Workbook GcExcel provides all the necessary properties and methods required to create a workbook, perform complex operations on the data residing in the spreadsheets and make use of several workbook events that are triggered when called explicitly by the user through code.
Worksheets In GcExcel, you can use the methods of IWorksheets to execute different tasks in a spreadsheet including insertion of a new worksheet in the workbook, deletion of a worksheet from the collection, assigning an active sheet, and so much more.
Templates GcExcel introduces new templates support with comprehensive syntax and API to bind Excel documents to data and generate Excel reports with advanced layouts. With flexible syntax and easy notations for data expansion and formulas, the new template syntax and API will make it easy to define Excel templates and generate Excel reports supporting numerous use cases.
SpreadJS Viewer Examples in this folder demonstrate how to use GrapeCity Documents for Excel and SpreadJS. GrapeCity Documents for Excel works on the server side to import and export Excel template files. Spread.Sheets works in the browser (client side) as a viewer or editor.

What's New

  • Paginated Templates - We have introduced TemplateOptions.PaginationMode to paginate your workbook into separate worksheets. 
  • Excel Form controls - GcExcel supports new API to create Excel forms with standard Form controls, customize them and additionally collect data from your users or programmatically retrieve Form control values.
  • JSON Data Source - GcExcel has included the new class JsonDataSource to bind a report template directly with a JSON data source.