Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports a robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects, and importing or creating charts. You can also create Excel files using a designer spreadsheet, smart marker, or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF, and all file formats from Excel 97 to Excel 2007.

Changes

This release includes several enhancements and fixes a number of user issues/bugs. Some unnecessary older obsolete methods for the Sheet-to-Image feature are now removed. This release includes support for getting the document properties for an encrypted XLS file without even knowing its password. There are enhancements for the Smart Markers feature. You may now group data in some complex scenarios in which you also need to place dynamic rows for Sub-Totals, Totals, and Grand Totals in between the sections of data. The GridDesktop control provided by Aspose.Cells now supports shapes while loading Excel files.

URL: Aspose.Cells for .NET - Documentation