Syncfusion Essential XlsIO lets you add Microsoft Excel reporting capabilities to your .NET applications within minutes.
Let designers visually design reports using Microsoft Excel, and then use Essential XlsIO to populate it with dynamic data during run time, to generate an invoice for example.
You can save the final report to a local file, stream, stream it to the client browser, or even export to other formats we support.
Excel Template Workbook Designed Visually Using Microsoft Excel
The above Template after XlsIO Dynamically Populated the Data
This approach also allows you to add some XlsIO unsupported features like macros into your Excel files through MS Excel rather than through XlsIO.
When you read an existing Excel document using XlsIO, the entire document is parsed and available for manipulation through its object model.
This makes consuming data stored in Excel documents as simple as loading a workbook and accessing the data through XlsIO’s intuitive object model.
XlsIO also provides APIs that makes working with ADO.NET data sources very easy. It only takes one line of code to import an ADO.NET DataTable into a worksheet or vice versa. There are APIs for working with other data sources like DataView, DataColumn, Arrays etc.
Code to Export the Worksheet Data
Freeze Columns and Rows to the left and on top using the XlsIO APIs.
Frozen 1st row and 1st column
Group and ungroup rows and columns to easily expand/collapse them.
Grouped Rows and Columns
Specify custom Row Height and Column Width for rows and columns in a worksheet. You can also show/hide rows and columns as well as add/remove rows and columns.
Custom Row width and Column height
Simple APIs allow you to Auto Fit specific columns and rows, making them resize automatically to fit it's contents.
Auto Fit Columns
Essential XlsIO lets you specify the exact horizontal and vertical Page Breaks while printing.
Page Breaks while printing
You can also programatically insert Page Header and Page Footer for printed sheets.
Page Header and Footer
Essential XlsIO has APIs to specify the Page Orientation(landscape or portrait) and other page setup properties while printing. You can also specify Page Margins for printed sheets.
Page Margins
Essential XlsIO has rich set of APIs for reading, inserting, and deleting both regular and rich text comments for cells in a workbook. The APIs allow you to
paint the background of the comment window with different styles such as gradient, solid color, texture, picture, and pattern.
Different styles of Comments
Add Embedded Charts to an Excel file with support for different chart types, 3D effects, custom chart area look and feel, custom data points look and feel, custom axis formats, legend customization and numerous other options.
Finally specify the range of cells from which to populate the data for the chart.
Excel Report with Charts Created Using XlsIO.
There is also support for creating Chart Worksheets where a single chart is rendered in the whole worksheet. Several formatting options are available to customize
the look and feel of such charts as well.
Chart Worksheets Created Using XlsIO.
By using Password Encryption in Essential XlsIO, you can secure the data in your reports and make it impossible for anyone to view the workbook without the password.
There are also several other options available to restrict specific user actions like inserting, formatting, and deleting rows.
Essential XlsIO lets you add Workbook Protection to protect a workbook's structure or windows. By protecting the structure, you can prevent the user from moving the workbooks around, inserting new ones, etc.
By protecting the windows in the workbook, you can control the size of the workbook, etc.
Essential XlsIO has support for adding Worksheet Protection. This prevents the end user from editing the contents of the worksheet while optionally letting the end users perform some operations on the worksheet like format cells, etc.
Worksheet Protected in XlsIO
While opening a workbook through XlsIO you will also have the ability to decrypt or unprotect a workbook/worksheet using the appropriate passwords.
The built-in document properties such as Application Name, Document Title, Category, Keywords, Company, etc. can be set for the documents using Essential XlsIO.
It is also possible to set custom document properties as well.
Document Properties set through XlsIO seen in Excel
Essential XlsIO was one of the first Excel manipulation libraries available for the .NET platform when it was released in 2003. Over the years the constant feedback
from our customers has helped us transform it into the most advanced Excel reporting library available in the market today. Besides the features listed above, more features available include support for named ranges, end-user report customization, Unicode, right-to-left tex,t and adding Excel and custom add-ins.
