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 includes an enhancement for copying a cell over a range of cells. A new overload was added: AutoFitColumns (int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options), making it possible to use auto-fitting options even in a range. Similarly, you may now copy tables when copying ranges. issues with rendering Excel files, rendering PivotTables and Pivot Charts, Excel to HTML, applying conditional formatting, rendering image files from worksheets, and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed.

Aspose.Cells for .NET – Freecode