Essential XlsIO ASP.NET Samples : Syncfusion

XlsIO

descriptionfeatured samples

Essential XlsIO is a .NET library that can read and write Microsoft Excel files (BIFF 8 format). It features a full-fledged object model just like the Microsoft Office COM libraries. XlsIO does not use COM interop and is built from scratch in C#. It can be used on systems that do not have Microsoft Excel installed, making it an excellent report engine for tabular data.

Essential XlsIO can create new spreadsheets purely from code or templates, it has full support for formatting, styles for the cells, formulae, page setups etc. It has also many advanced features like Data validation, Charts, Conditional formatting, Comments, Rich text support and worksheet security.

Embedded Chart

This sample is used to format and modify chart settings; it is similar to modifying chart properties using Excel

ExcelToPDF

Essential XlsIO allows to export the Excel document into PDF document. Use the Convert method of ExcelToPDFConverter class to convert the Excel files to PDF files and save the PDF document

Sparklines

Essential XlsIO has APIs for creating sparkline. The SparklineGroup class represents the sparklines in memory. This object can be used to format and modify sparkline settings; it is similar to modifying sparkline properties using Excel.

Invoice

This sample focuses on creating an application using an Essential XlsIO and ADO connection.

Pivot Table

A pivot table is often used to summarize large reports;XlsIO provides pivot table creation and formatting with built-in styles, allowing more flexibility in summarizing reports.