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
Benefits of Automating Excel Reports with a .NET Excel API
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, Merge, and Filter Data
Group or set outline groups over your data with repeat, merge or list properties and sort data based on one or more columns in ascending, descending order and filter data from multiple data sources.
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.
Employee Management
Create Excel templates to bind with employee data, define conditional formatting on template cells and see your data expand.
Generate Tax Forms
Use the 'form' property to define PDF Form Fields and related properties within Excel Templates. Generate bound, un-bound PDF Forms.
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 .NET Excel API Features for Automating Excel Reports
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.
Maintain Image Aspect Ratio
Maintain image aspect ratio in Excel Templates, allowing images to fit within the cell size regardless of height or width.
Support for Global Setting
Convert Excel Templates to PDF Forms with HTML5 Input Types
DsExcel .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.
Generate Paginated Spreadsheet Reports
Paginate Spreadsheets into multiple worksheets with a fixed number of rows or on-page size. Configure Page/Group Header/Footer, set grouping properties, keep together grouped content, and more.
Change Sort Order of Template Data
Sort the template data based on the values of one or more data fields, and/or using unique cell values.
Filter Data from Single/Multiple Data Sources
Filter related data from single/multiple data sources by defining Conditional or Slice filter conditions in Excel Template to expand the data accordingly.
Document Solutions Data Viewer
Check out the new Document Solutions Data Viewer (DsDataViewer) to view multiple data documents on the web. Take advantage of the seamless API to embed the JavaScript data viewer in cross-platform applications.
Explore the Advanced Features of a C# .NET Excel API
It also showcases numerous API features and includes code samples you can download and apply now. Click the button below to see the demos.
What's New
- Filter Data from Single/Multiple Data Sources
- Integrate data from single/multiple data sources.
- Define Conditional and Slice Filters with new Filter property syntax.
- Implement complex business scenario where data is extracted from multiple tables by applying filter conditions for related data.
- Bind Templates with JSON Data Source
- Excel Templates can now be bound to JSON files.
- In addition, the above Filtering support also works with data from multiple JSON data sources.