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 supports reading of Excel files containing millions of records with the LightCells API. It is now possible to find all cells with a common style or formatting, and to generate a transparent image of your worksheet.
Release Notes: This release supports fitting all worksheet columns on a single PDF page. It also provides a feature for detecting file format type and checking if the file is encrypted. Sometimes you need to detect a file’s format before opening it because the file extension does not guarantee that the file content is appropriate, or the file might be encrypted (a password protected file). Issues around rendering Microsoft Excel file formats (XLS, XLSX, ODS, CSV, XLSB, etc.), rendering and manipulating pivot tables, rendering images from Excel worksheets, exporting Excel workbooks to PDF format have been resolved.
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.