Aspose.Cells Product Family - Summary

by Aspose - Product Type: Component / ASP.NET WebForms / .NET WinForms / .NET Class / Java Class

Summary

Aspose.Cells Product Family by Aspose

URLs: aspose-cells-product-family, aspose cells product family, asposecellsproductfamily, aspose

Create and manage Excel Spreadsheets without requiring Microsoft Excel. Aspose.Cells Product Family Pack includes Aspose.Cells for .NET, Java, Reporting Services and JasperReports. Aspose.Cells Product Family offers a robust and flexible set of Excel spreadsheet reporting components that enable either .NET or Java applications to manage Excel spreadsheets without utilizing Microsoft Excel. Aspose.Cells Product Family also allows you to export your reports from Microsoft SQL Server Reporting Services, JasperReports and JasperServer to Microsoft Excel format. Aspose.Cells Product Family licenses include maintenance and support for 1 Year.

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

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Pricing: Aspose.Cells Product Family 1 Developer with Deployment to 1 Physical Location - Small Business Subscription License - Includes Maintenance and Support (1 Year) , Aspose.Cells Product Family 1 Developer with Deployment to Unlimited Physical Locations - OEM Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells Product Family 10 Developer with Deployment to 10 Physical Locations - Site Small Business Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells Product Family 10 Developer with Deployment to Unlimited Physical Locations - Site OEM Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Post Expiry 1 Developer Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Post Expiry 1 Developer OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Post Expiry 1 Site Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Post Expiry 1 Site OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Pre Expiry 1 Developer Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Pre Expiry 1 Developer OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Pre Expiry 1 Site Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells Product Family - Subscription Renewals Pre Expiry 1 Site OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose Priority Support Developer Small Business 1 Year Priority Support License, Aspose Priority Support Developer OEM 1 Year Priority Support License, Aspose Priority Support Site Small Business 1 Year Priority Support License, Aspose Priority Support Site OEM 1 Year Priority Support License

Evals & Downloads: View the Aspose.Cells for Java Documentation, Read the Aspose License Agreement - Requires Acrobat Reader, Read the Aspose.Cells help file, Download the Aspose.Cells V7.1 evaluation on to your computer - Output Displays Evaluation Label, Download the Aspose.Cells Java V7.0 evaluation on to your computer - Output Displays Evaluation Label, Download the Aspose.Cells for Reporting Services V1.5.1 evaluation on to your computer - Output Displays Evaluation Messages

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: ASP.NET WebForms, .NET WinForms, .NET Class, Java Class

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft SQL Server 2008, Microsoft SQL Server 2005, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, .NET Framework 1.1, Eclipse V3.5, Eclipse V3.4, IntelliJ IDEA 7, IntelliJ IDEA 8

Keywords: aspose.cells product family, aspose cells product family, asposecells product family, aspose.cells family, aspose excel family, aspose excel product, aspose xls family, aspose xls product, aspose xlsx family, aspose xlsx product, aspose cells family, asposecells family, aspose cells family distributor, aspose cells family reseller, aspose cells family developer, aspose cells family enterprise, aspose cells family license, aspose cells family site, aspose cells product subscription, aspose. cells family oem, aspose cells renewal, aspose cells family upgrade, buy aspose cells family, order aspose cells family, purchase aspose cells family

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl

Part numbers: PC-534379-268628 534379-268628 PC-534379-268631 534379-268631 PC-534379-268634 534379-268634 PC-534379-268637 534379-268637 PC-534379-268640 534379-268640 PC-534379-268643 534379-268643 PC-534379-268646 534379-268646 PC-534379-268649 534379-268649 PC-534379-268616 534379-268616 PC-534379-268619 534379-268619 PC-534379-268622 534379-268622 PC-534379-268625 534379-268625 PC-534379-389606 534379-389606 PC-534379-389647 534379-389647 PC-534379-389688 534379-389688 PC-534379-389729 534379-389729

Mfr. Part No: APPFCEDE APPFCEDO APPFCESE APPFCESO