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.
|Tags||3D effects MS Excel 2010 Sparklines 3D effects on charts Duplicate values Formula Calculation Engine linked picture|
|Licenses||Evaluation License Developer Enterprise License Developer OEM License Site Enterprise|
|Operating Systems||Windows Unix Linux Mac OS X|
|Implementation||Java C# .Net VB.NET|
Release Notes: This release added support for calculating the color selected by MS Excel when ColorScale Conditional formatting is used in the template file. Support for encrypted files was enhanced. Generation of password protected Excel files was enhanced. Several issues with rendering Microsoft Excel file formats, rendering and manipulating pivot tables, rendering images from Excel worksheets, manipulating custom document properties, working with advanced conditional formatting (MS Excel 2007/2010), and rendering and manipulating Charts have been resolved.
Release Notes: This release lets you select a different paper source when printing worksheets. Some significant enhancements are added for reading non-native Microsoft Excel files: now the component throws the appropriate exception when loading such files. This release improves the module for inserting OLE objects. It supports re-sampling images added to slides to reduce the overall file size and improve performance (e.g. if you want to compress images while saving Excel to PDF format). It fixes a few exceptions when reading/writing Excel files and refreshing pivot tables in the template files.
Release Notes: Reading and writing of page setup options in HTML files was enhanced. Rendering, manipulating, and refreshing PivotTables was enhanced. A few exceptions when reading and writing Excel files and manipulating PivotTables in a template file were fixed. Issues with rendering Excel files, rendering and manipulating PivotTables, rendering image files, converting Excel files to HTML/MTHML, and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed.
Release Notes: 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.
Release Notes: This release includes how to get icon sets, data bars, or color scales objects used when adding conditional formatting to a cell or a range of cells. Support for rendering a worksheet’s background in an output HTML file and parsing custom views and scenarios while converting from one Excel file format to another are added. Moreover, this release improves the Excel to PDF rendering feature, which sometimes took more time to convert large Excel files to PDF. Issues around reading and writing Microsoft Excel (2003 – 2007/2010) file formats have been fixed.