Aspose.Cells for .NET

What's new in Aspose.Cells for .NET V7.1?

• Apply conditional formatting to pivot tables
• Read the configuration of pivot table group fields
• Convert worksheets to SVG file format

What's new in Aspose.Cells for .NET V7.0?

• Import formulae with values from an Excel file
• Import Excel files from a stream without calculating all formulae
• Export to XPS files
• Create write-protected XLSX files
• Load data asynchronously
• Supports IE9 without using compatibility mode
• Set background image for a cell's Button control

What's new in Aspose.Cells for .NET V5.3.2?

• Supports Arabic text rendering in PDF conversion
• Supports calculating array constants in formulas
• Supports multiple non-sequential cell operations
• Supports calculating array constants in formulas
• Supports MS Excel 2010 encryption
• Disable/hide printing
• Process dialog box
• Supports changing paper source while printing
• Supports setting grouped row state to 'Expanded' or 'Collapsed' on the client side

What's new in Aspose.Cells for .NET V5.3?

• Chart-to-Image feature has been enhanced
• Excel-to-PDF feature has been enhanced
• R/W ODS files feature has been enhanced
• Auto-fit rows feature has been enhanced
• All features of the control now work in in FireFox.
• Provides support for converting a list collection to a DataTable object.
• Supports SMALL function/formula.
• Imports auto-filters in Excel files.
• The performance of client scripts for IE is enhanced.
• Supports whether to extend maximum row/column automatically when calculating formulas.

What's new in Aspose.Cells for .NET V5.2?

• Supports signing and validating Digital Signatures in XLSX files.
• Supports reading and writing Pivot Tables in XLS and XLSX files.
• Calculates Pivot Table data in cells

What's new in Aspose.Cells for .NET V5.1.2?

• Now supports setting visibilility of context menu items
• Provides support for text rotation (90 and -90 degrees)
• Supports firing CellDataChanged event when a formula is evaluated

What's new in Aspose.Cells for .NET V5.1?

• Includes Smart Tags support for XLSX files.
• Converts Sparklines to images.
• Provides support for image Smart Markers.
• Supports Cell’s gradient fills and theme of XLS file.
• Renders Cell’s pattern fills in the generated PDF file. 
• Adds support for Pdf/A-1b compliance.
• Improves performance and quality of the generated PDF files.
• 46 enhancement and fixes.

What's new in Aspose.Cells for .NET V5.0?

• Now includes MS Excel 2007 XLSB file format support
• Provides Copy and Paste Special feature
• Supports sorting smart markers
• 37 enhancement and fixes

What's new in Aspose.Cells for .NET V4.8.2?

What's changed in Aspose.Cells:

• Set IDataReader as a date source of Smart Markers
• R/W ListObject (Table) of MS Excel2007 Xlsx files
• Update data from external referenced links
• Copy Data Validation in copying rows operation
• The Formula Calculation Engine is enhanced
• Copy ListObject (Table) in copying worksheet or workbook
• Export richly formatted text to the html string value
• 65 fixes and other enhancements

What’s changed in Aspose.Cells.GridWeb:

• Add ADDRESS, ROW, ROWS, COLUMN, COLUMNS, OFFSET and INDIRECT functions
• Include hyperlink click event of binding column at client side
• Support CustomCommandButton click event and double click row event at client side
• 3 fixes and other enhancements

What's new in Aspose.Cells for .NET V4.8.1?

What's changed in Aspose.Cells:

• External workbook references from Excel 2007 xlsx file are supported.
• Supports Summary Below Data for Subtotals.
• Allows more than 3 data sorter keys.
• Provides support for Excel 2007 Themes and Colors.
• Formula Calculation Engine is enhanced.
• Includes Area3D chart in the supported chart list for Chart -to- Image feature.
• Named Range comments can be accessed.
• Sets picture as a background fill format of the chart.

What's changed in Aspose.Cells.GridWeb:

• Provides support for importing or exporting xlsx files.
• Adds some valuable overloaded methods: AutoFitColumns, AutoFitColumn, AutoFitRows, AutoFitRow.
• Formula Calculation Engine is enhanced.
• Supports MEDIAN, ISERR and ISNUMBER formulas/functions.
• Memory usage for styles is optimized.
• Calculation dependence tree for formulas in Ajax mode is supported.
• Handles events at client side before submitting.
• All operators, behaviors and operations work in Ajax mode.
• Supports setting style to a specified range of cells.

What's changed in Aspose.Cells.GridDesktop:

• Implements match mode in custom row filter.
• Formula Calculation Engine is enhanced.
• Supports MEDIAN, ISERR and ISNUMBER formulas/functions.
• Allows maximum 1048576 rows and 1024 columns.
• Provides support to sum up selected cells' values.
• Blanks, NonBlanks and AutoRowFilter options are included in auto-filters.
• Memory usage is optimized.
• Includes Find/Replace feature.
• Enhances Undo/Redo feature for the change in the operations: apply styles, insertion/deletion and resizing rows/columns.
• Provides support to customize behaviors when validation is failed.
• Supports copying/pasting when hosted within IE.

What's new in Aspose.Cells for .NET V4.8?

• Merged Aspose.Grid suite into Aspose.Cells
• Optimized the performance of Formula recalculations
• Improved the performance of inserting/deleting Rows/Columns
• Enhanced the performance of Auto-fit Rows/Columns feature
• Added WordArt shapes to XLS file
• You can now read gradient fill effects for the charts
• Now create spreadsheets with First Page or Even/Odd Header/Footer attributes for Page Setup
• Support for multiple Print Areas in Worksheet-to-Image feature added
• Added Formula Calculation support for some new MS Excel built-in functions
• You can now set the background image for a Chart type Worksheet
• Now provides support for setting Image Options in Chart-to-Image and Worksheet-to-Image features
• 101 fixes and other enhancements

What's new in Aspose.Cells for .NET V4.7.1?

• Direct exporting of Excel files to PDF streams
• Now can apply Subtotals to worksheet tables
• Improved performance of encrypting and decrypting Excel 2007 files
• 55 fixes and enhancements

What's New Aspose.Cells for .Net V4.6x?

• Supports to export PivotTable to Excel 2007 file.
• Supports to add pivot calculated item to pivot table in 97-2003 xls file.
• Supports Page setup Header(s) and Footer(s) in Worksheet2Image.
• Supports to R/W xltm , xlmx file.

What's New Aspose.Cells for .Net V4.5x?

•  Convert Worksheets to images
•  Support to convert Excel files to HTML file format
•  Support to sort the data from left to right

What's New Aspose.Cells for .Net V4.4x?

• Now allows to delete defined names from template files
• Support to create an encrypted Excel file from scratch
• Now can write formula calculation results back to a file
• Chart2image conversion enhancement
• Xls2pdf feature enhancement
• Support to set vertical text in text box

Aspose.Cells was developed using Managed C# and it can be used with any .NET language like C#, VB.NET and J# etc. Aspose.Cells can be used with any kind of application either as an ASP.NET Web Application or a Windows Application. Aspose.Cells provides fully featured demos and working examples written in both C# and VB.NET for developers to have a better understanding of Aspose.Cells.

Besides supporting common features like creating or reading native Excel files, Aspose.Cells also supports many advanced features such as saving and opening Excel files to and from streams, sending output to a client browser, importing and exporting data from a DataTable, DataView or Array, importing images and charts, creating images and charts through API, importing formulae from a designer spreadsheet and configuring page setup through API. Aspose.Cells also supports Addins, VBA and macros.

Moreover, there are also a number of advanced features such as the support of CSV format, adding the copy of an existing worksheet (with full contents, images and charts etc.) to a file, setting gradient background for charts through API, creating comments, auto-filters and page breaks through API, setting complex formulae, supporting conditional formatting, supporting protection options introduced in Microsoft Excel XP, manipulating named ranges, locating APIs, supporting custom chart API and formula calculation engine etc.

Document Features

• Open Plain or Encrypted Excel files from different sources
• Save Excel files in different formats
• Convert Excel file to PDF document
• Modify the Document Properties of Excel files

Worksheet Features - Display Options

• Hide or Unhide a Worksheet
• Display or Hide Tabs, Scroll Bars, Gridlines & Row/Column Headers
• Preview Page Breaks
• Set Zoom Level for the Worksheet
• Make selected data remain visible while scrolling using Freeze Panes

Worksheet Protection

• Protect Contents, Objects and Scenarios of a Worksheet

Page Setup Options

• Set Page Orientation, Scaling, Paper Size, Print Quality etc.
• Set Page Margins like Top, Left, Right, Bottom etc.
• Set Headers and Footers
• Set Print Area, Print Title etc.
• Page Breaks
• Insert Horizontal and Vertical Page Breaks at a specified cell

Rows & Columns Features

• Adjust Row Height according to your desire
• Adjust Column Width as required
• Auto size the width and height of cells according to their contents
• Insert or Delete Rows and Columns
• Hide or Unhide Rows and Columns
• Group or Ungroup Rows and Columns

Data Management Features

• Access any Cell in the worksheet
• Add data to desired Cells at runtime
• Import data into Worksheets from different data sources
• Retrieve data from cells according to their data types
• Export cells data to DataTable
• Find or Search specific data in cells
• Set Formulae with Built-in or Add-in Functions
• Set Array and R1C1 reference style Formula
• Add different kinds of Hyperlinks
• Create or Access Named Ranges
• Apply Data Validation and Auto-Filtering

Formatting Features

• Apply different Styles on the Cells
• Apply Number Format Settings for the Cells
• Format Cell as a Date
• Set Text Alignment
• Merge multiple Cells into single one
• Apply different kinds of Font Settings for the Cells
• Apply different Colors to Cells, Fonts, Gridlines, Graphic Objects etc.
• Set Rich Text in a Single Cell
• Apply different Border Settings on Cells
• Apply different Background Patterns on Cells
• Apply Format Settings on a Worksheet, Row or Column etc.
• Apply Conditional Formatting on Cells

Charting & Graphics Features

• Supports all standard Chart Types like Column, Bar, Line, Pie, Scatter etc.
• Create Different kinds of Charts easily
• Customize Charts by setting their different properties
• Set Data for the Charts dynamically
• Add Custom Charts to Worksheets using API
• Add Pictures to Worksheets at runtime
• Create and Add Comments to cells

Advance Features

• Supports Designer Spreadsheets and Smart Markers
• Supports Formula Calculations using robust Formula Calculation Engine
• Supports accessing Aspose.Cells from COM Clients
• Change Source Data of a Pivot Table at runtime

Platforms Supported

• Window Forms Support
• Web Forms Support