Welcome to the Aspose.Cells documentation!

 

Aspose.Cells is the most flexible component that enables .NET and Java Applications to create and manage Excel Spreadsheets without requiring Microsoft Excel to be installed on the system. Unlike similar products from other vendors, Aspose.Cells not only supports spreadsheet generation and other basic file formatting features, but also supports a number of advanced features. These advanced features make it much more convenient for the developers to manipulate spreadsheet contents, cells formatting and files protection. Aspose.Cells also allows to import data into spreadsheets from different data sources, add common and complex Mathematical, DateTime, Financial, Text Formulas / Functions, supports manipulation of charts, pictures, comments, drawing objects and controls etc.

 

Product Description

 

Aspose.Cells comes out with two flavors: one for .NET (written in managed C#) and other for Java platforms (written in Java). Aspose.Cells is designed to be used with any of the .NET supported languages like C#, VB.NET and J# etc  or with Java language. Aspose.Cells can be used with any kind of application whether it's an ASP.NET Web Application / Java Web Application or a Windows Application / Java Desktop Application. Moreover, the library can also be used with some other solutions like ASP, PHP etc. Aspose.Cells provides fully featured demos and working examples written in C#,  VB.NET and Java languages for developers to have a better understanding of the features exposed by the component.

 

Besides supporting common features like creating or reading native Excel files, Aspose.Cells also offers 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, ResultSet or an Array, importing images and charts, creating images and charts through API, importing formulae from a designer spreadsheet, converting designer chart to image and configuring page setup through API. Aspose.Cells also supports Addins, VBA and macros.

 

Moreover, there are also a number of unique features that the developers can only find in Aspose.Cells such as the support of CSV and SpreadsheetML formats, 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 or above, manipulating named ranges, locating APIs, supporting custom chart API and formula calculation engine etc.

 

Document Features

 

• Open Plain or Encrypted Excel files (Excel97- Excel2007) from different sources
• Save Excel files (Excel97- Excel2007) 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

 

• Desktop Windows Application
• Enterprise Web Application
• Linux
• Unix