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 adds enhancements for copying ranges and number formatting and an enhancement to the List objects and Tables, which are now copied when copying ranges between workbooks. Similarly, macros and VBA codes are copied in the XSLM file when you use the Workbook.Copy() method. This release fixes a few exceptions when manipulating PivotTables in the template file. Several important issues like rendering MS Excel files, rendering PivotTables, manipulating advanced conditional formatting, rendering image files, and exporting to PDF have been resolved. GridWeb now allows reading a data list on the client side.

Aspose.Cells for .NET – Freecode