|
|
|
| | | |
| |
Essential XlsIO is a .NET library that can read and write Microsoft Excel files (BIFF 8 format). It features a full-fledged object model similar to the Microsoft Office Automation libraries. It can be used on systems that do not have Microsoft Excel installed, making it an excellent report engine for tabular data.
|
|
|
|
|
|
Overview
XlsIO can be used to generate a new XLS document from scratch, extract data from an existing spreadsheet document or even edit an existing spreadsheet.
| |
|
|
|
|
Excel 2007 Support
Essential XlsIO is one of the first products to natively support Excel 2007 Xlsx file format. 100% support for all Excel object types is not yet available, but several commonly used elements are already supported.
| |
|
|
|
|
Formatting
Numerous formatting options are available for customizing the look and feel of the cells in the worksheet.
| |
|
|
|
|
Calculations
Essential XlsIO has advanced support for working with Formulas in cells.
| |
|
|
|
|
Data Manipulation
Essential XlsIO has advanced support for working with Data in a worksheet. Here are some key functionalities that enables working with data easier.
| |
|
|
|
|
|
|
Comments
Essential XlsIO has APIs for reading and writing comments for cells in a worksheet.
| |
|
|
|
|
Charts
Essential XlsIO has advanced support for creating and modifying Excel charts inside a workbook. There is an option to choose between creating a chart as an embedded chart or as a worksheet chart.
| |
|
|
|
|
Security
Essential XlsIO has support for securing the content, structure and windows of a Excel workbook and worksheet.
| |
|
|
|
|
Document Settings
Essential XlsIO can work with spreadsheets that are stored as streams and can also save to a stream.
| |
|
|
|
|
|
|
Performance
Essential XlsIO is known for its high performance for generating Excel files with large number of rows and columns. It has superior performance over MS Excel in the context of report generation processes.
| |
|
|
|
|
|
|
|
|
