Features

Aspose.Cells for .NET

Aspose.Cells for Java

General

Written Completely in C#

Yes

.NET Environment required

Yes

Written Completely in Java

Yes

Java runtime required

Yes

Platforms Supported

Desktop applications

Yes

Yes

Web applications

Yes

Yes

Documentation

Microsoft Help 2

Yes

Html Help

Yes

Yes

Fully Featured Demos

Visual Basic.NET

Yes

C#

Yes

Java

Yes

Working Examples

Visual Basic.NET

Yes

C#

Yes

Java

Yes

Excel Creation

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Smart Marker

Yes

Yes

File Formats Supported

Excel 97

Yes

Yes

Excel 2000

Yes

Yes

Excel XP

Yes

Yes

Excel 2003

Yes

Yes

Excel 2007 Xlsx

Yes

Yes

Excel 2007 Xlsm

Yes

Yes

Excel 2007 Xltm

Yes

Yes

Excel 2007 Xltx

Yes

Yes

Pdf

Yes

CSV

Yes

Yes

Tab Delimited Text

Yes

Yes

SpreadsheetML

Yes

Yes

Html

Yes

Yes

ODS

Yes

Aspose.Pdf.xml format (that can be used by Aspose.Pdf to create PDF files)

Yes

Yes

Spreadsheet Content

Cell Data

Yes

Yes

Formula

Yes

Yes

Hyperlinks

Yes

Yes

Data Validations

Yes

Yes

Apply Formatting

Cell Formatting

Yes

Yes

Conditional Formatting

Yes

Yes

Apply Formulae & Functions

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Create & Access Named Ranges

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Configure Page Setup Options

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Document Properties

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Managing Rows & Columns

Insertion & Deletion

Yes

Yes

Hiding & Unhiding

Yes

Yes

Grouping & Ungrouping

Yes

Yes

Worksheet Protection

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Workbook Encryption

Open Encrypted File

Yes

Yes

Auto-Filtering of Data

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Drawing Objects

Pictures

Yes

Yes

Standard Charts

Yes

Yes

Custom Charts

Yes

Comments

Yes

Yes

Text Boxes

Yes

Yes

Check Boxes

Yes

Yes

Ole Objects

Yes

Yes

AutoFit Rows & Columns

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Add-ins Supported

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

VBA Supported

Using Designer Spreadsheet

Yes

Yes

Pivot Tables

Using Designer Spreadsheet

Yes

Yes

Using API

Yes

Yes

Formula Calculation Engine

Using API

Yes

Yes