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.

This release supports adding custom data sorting. It adds some significant enhancements for copying ranges with conditional formatting and clearing the Textbox collection. It fixes a few exceptions when reading and writing Excel files and writing legend entries in charts. Several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating PivotTables, converting Excel files to HTML format, adding background watermarks in worksheets, rendering charts, rendering image files, and exporting to PDF have been resolved

Aspose.Cells for .NET – Freecode