Aspose.Cells Product Family

Aspose.Cells Product Family Pack includes Aspose.Cells for .NET, Java, Reporting Services and JasperReports.

Aspose.Cells .NET
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

Aspose.Cells Java
Aspose.Cells for Java is a Java spreadsheet creation engine. It can read, modify and write Excel files compatible with different platforms such as Windows, Linux and Unix. With this component, your Java programs will have the ability to present data a most popular and way.

Common Features

• Create native excel files
• Read excel files
• Supports file formats of Microsoft Excel 97-2003 Editions
• Supports unicode
• Supports Multi-worksheets
• Easy to use APIs
• Supports to configure sheet display options settings
• Supports cell data access and manipulation
• Provides total control of cell formattings
• Supports rich text settings in a cell
• Supports to configure Row/Column settings
• Supports to configure Range settings
• Import data from JDBC Resultset
• Formula settings
• Hyperlinks
• Preserving Pictures, charts, macros and pivottables in template file
• Page Setup support
• Pagebreaks settings
• Validations settings
• Worksheet Protection
• Freeze Panes

Advanced Features

• Open excel files and save to streams
• Send output to a client browser
• Import/Export data from different data sources, such as a DataTable, DataView, DataGrid or an Array
• Import images and charts
• Create images and charts at runtime through API
• Import formula from a designer spreadsheet
• Supports add-ins
• Supports VBA
• Supports macros
• Supports page setup through API

Aspose.Cells for Reporting Services is a product that generates Xls, Excel2007 Xlsx, and SpreadsheetML reports in Microsoft SQL Server 2005 Reporting Services. After installing Aspose.Cells for Reporting Services on your server, you will get access to three additional export formats:

• Xls – Excel Workbook via Aspose.Cells
• Excel2007Xlsx – Excel 2007 via Aspose.Cells
• SpreadsheetML – SpreadsheetML via Aspose.Cells
• CSV – CSV via Aspose.Cells
• TXT – TabDelimited via Aspose.Cells

Aspose.Cells for Reporting Services
Aspose.Cells for Reporting Services creates Excel files on the server without utilizing Microsoft Excel. Aspose.Cells for Reporting Services makes it possible to export any report in Xls, Xlsx or SpreadsheetML format.

Features Description

• Xls, Xlsx and SpreadsheetML Export - Export reports as Microsoft Excel files from Microsoft SQL Server 2005/2008 Reporting Services without utilizing Microsoft Excel.
• High Fidelity to the Report Design - Xls, Xlsx and SpreadsheetML reports have same layout
• Easy and Lightweight Deployment - Aspose.Cells for Reporting Services is a rendering extension for Microsoft SQL Server 2005/2008 Reporting Services