Aspose-cells

Release contain the open source code comparison examples among features of Aspose.Cells Java and Apache POI HSSF and XSSF - Dealing Microsoft Excel of MS Office and OpenOffice Calc Spreadsheets.

[](http://www.aspose.com/java/excel-component.aspx) [](https://poi.apache.org/)

:sparkles: What's New ?
- [Create Different Cell Types](http://www.aspose.com/docs/display/cellsjava/Create+Different+Cell+Types+in+Apache+POI+and+Aspose.Cells)
- [Create Date Cell](http://www.aspose.com/docs/display/cellsjava/Create+Date+Cell+in+Apache+POI+and+Aspose.Cells)
- [Create Charts](http://www.aspose.com/docs/display/cellsjava/Create+Charts+using+Apache+POI+and+Aspose.Cells)
- [Create Pivot Tables](http://www.aspose.com/docs/display/cellsjava/Create+Pivot+Tables+using+Apache+POI+and+Aspose.Cells)

[](https://asposecellsjavaapachepoi.codeplex.com/releases/view/619964)

:sparkles: Existing Examples

**Working with Workbook**
- [Create New Workbook](http://www.aspose.com/docs/display/cellsjava/Create+New+Workbook)
- [Add Data in Cells](http://www.aspose.com/docs/display/cellsjava/Add+Data+in+Cells)
- [Set Print Area](http://www.aspose.com/docs/display/cellsjava/Set+Print+Area)
- [Page Setup - Fit to Page Setting](http://www.aspose.com/docs/display/cellsjava/Page+Setup+-+Fit+to+Page+Setting)

**Working with Worksheets**
- [Create New Worksheet](http://www.aspose.com/docs/display/cellsjava/Create+New+Worksheet)
- [Convert Worksheet to CSV](http://www.aspose.com/docs/display/cellsjava/Convert+Worksheet+to+CSV)
- [Copy Sheet Within Workbook](http://www.aspose.com/docs/display/cellsjava/Copy+Sheet+Within+Workbook)
- [Re-Order Sheets Within Workbook](http://www.aspose.com/docs/display/cellsjava/Re-Order+Sheets+Within+Workbook)
- [Zoom Factor](http://www.aspose.com/docs/display/cellsjava/Zoom+Factor+using+Apache+POI+and+Aspose.Cells)
- [Header and Footers](http://www.aspose.com/docs/display/cellsjava/Header+and+Footers)
- [Add Images in Worksheet](http://www.aspose.com/docs/display/cellsjava/Add+Images+in+Worksheet)

**Working with Cells, Rows and Columns**
- [Freeze Panes](http://www.aspose.com/docs/display/cellsjava/Freeze+Panes+in+Apache+POI+and+Aspose.Cells)
- [Hide and Unhide Cells](http://www.aspose.com/docs/display/cellsjava/Hide+and+Unhide+Cells)
- [Merge Cells](http://www.aspose.com/docs/display/cellsjava/Merge+Cells)
- [Auto Fit Row and Column](http://www.aspose.com/docs/display/cellsjava/Auto+Fit+Row+and+Column)
- [Iterate Rows and Columns](http://www.aspose.com/docs/display/cellsjava/Iterate+Rows+and+Columns)
- [Split Panes](http://www.aspose.com/docs/display/cellsjava/Split+Panes+in+Apache+POI+and+Aspose.Cells)
- [Insert Cell Comments](http://www.aspose.com/docs/display/cellsjava/Insert+Cell+Comments)
- [Cell Alignment Settings](http://www.aspose.com/docs/display/cellsjava/Cell+Alignment+Settings)

**Working with Data**
- [Getting Cell Contents](http://www.aspose.com/docs/display/cellsjava/Getting+Cell+Contents)
- [New Line in Cells](http://www.aspose.com/docs/display/cellsjava/New+Line+in+Cells)
- [Insert Hyperlinks in Worksheet](http://www.aspose.com/docs/display/cellsjava/Insert+Hyperlinks+in+Worksheet)

**Working with Formatting Features**
- [Working with Fonts](http://www.aspose.com/docs/display/cellsjava/Working+with+Fonts+in+Apache+POI+and+Aspose.Cells)
- [Working with Colors](http://www.aspose.com/docs/display/cellsjava/Working+with+Colors+in+Apache+POI+and+Aspose.Cells)
- [Working with Borders](http://www.aspose.com/docs/display/cellsjava/Working+with+Borders+in+Apache+POI+and+Aspose.Cells)

[](https://asposecellsjavaapachepoi.codeplex.com/releases/view/619964)

Feedback and Suggestions
- Many more examples are available at [Aspose Docs](http://www.aspose.com/docs/display/cellsjava).
- Raise your queries and suggest more examples via [Aspose Forums](http://www.aspose.com/community/forums/default.aspx) or via this social coding site.


Aspose.Cells_Java_for_Jython-v1.0.0
Demonstrates the **Aspose.Cells for Java API** usage within Jython.

**Aspose.Cells for Java API** is very rich in features, however this release provides usage examples for following features:

**Quick Start**
- Hello World

**Working With Files**
- Converting ExcelFiles into Html
- Converting to Mhtml files
- Converting to XPS
- Converting Worksheet to SVG
- Excel to Pdf conversion
- Managing Document Properties
- Opening Files
- Saving Files
- Worksheet to Image

**Working with Rows and Columns**
- Rows and Columns

**Working with Worksheets**
- Adding Worksheets to New Excel File
- Copying And Moving Worksheets
- Display Hide Gridlines
- Display Hide Scroll Bars
- Freeze Panes
- Hide Unhide Worksheet
- Page Break Preview
- Protecting Worksheet
- Removing Worksheets using Sheet Index
- Removing Worksheets using Sheet Name
- Setting Page Options
- Split Panes
- Unprotecting Password Protected Worksheet
- Unprotecting Simply Protected Worksheet
- Zoom Factor


Aspose.Cells-Java-for-NetBeans-8.1-(Maven)-v1.0.0.0
:sparkles: What's New

The release contains the following wizards:

1. **Aspose.Cells Maven Project** wizard
2. **Aspose.Cells Code Example** wizard


Aspose.Cells Maven Project wizard creates Maven project for using Aspose.Cells for Java API i.e by adding its latest Maven Dependency reference in pom.xml.

Aspose.Cells Code Examples wizard lets you import / copy downloaded [Code Examples](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples) into the project along with the required data files for examples.

Aspose.Cells Code Example wizard currently integrates the following [Aspose.Cells](http://goo.gl/c1eSD2) examples with the NetBeans IDE:
- **[Charts](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts)**

> - **[Fundamental](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts/fundamental)**
> - **[Management](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts/management)**
- **[Data](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data)**

> - **[Addons](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon)**
>
> > - **[Hyperlinks](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/hyperlinks)**
> > - **[Merging](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/merging)**
> > - **[Named Ranges](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/namedranges)**
> - **[Handling](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling)**
>
> > - **[Accessing Cells](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/accessingcells)**
> > - **[Find](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/find)**
> > - **[Importing](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/importing)**
> - **[Processing](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/processing)**
>
> > - **[Filtering And Validation](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/processing/filteringandvalidation)**
- **[Files](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files)**

> - **[Handling](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files/handling)**
> - **[Utility](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files/utility)**
- **[Rows Columns](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/rowscolumns)**
- **[WorkSheets](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets)**

> - **[Display](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/display)**
> - **[Management](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/management)**
> - **[Security](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security)**
>
> > - **[Protecting](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security/protecting)**
> > - **[UnProtecting](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security/unprotecting)**


Aspose.Cells-Java-for-NetBeans-8.0-(Maven)-v1.0.0.0
:sparkles: What's New

The release contains the following wizards:

1. **Aspose.Cells Maven Project** wizard
2. **Aspose.Cells Code Example** wizard


Aspose.Cells Maven Project wizard creates Aspose.Cells for Java API Maven project for using Aspose.Cells for Java API.

Aspose.Cells Code Example wizard lets you import / copy downloaded [Code Examples](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples) into the project along with the required resources needed by the examples.

Aspose.Cells Code Example wizard currently integrates the following [Aspose.Cells](http://goo.gl/c1eSD2) examples with the NetBeans IDE:
- **[Charts](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts)**

> - **[Fundamental](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts/fundamental)**
> - **[Management](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts/management)**
- **[Data](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data)**

> - **[Addons](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon)**
>
> > - **[Hyperlinks](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/hyperlinks)**
> > - **[Merging](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/merging)**
> > - **[Named Ranges](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/namedranges)**
> - **[Handling](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling)**
>
> > - **[Accessing Cells](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/accessingcells)**
> > - **[Find](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/find)**
> > - **[Importing](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/importing)**
> - **[Processing](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/processing)**
>
> > - **[Filtering And Validation](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/processing/filteringandvalidation)**
- **[Files](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files)**

> - **[Handling](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files/handling)**
> - **[Utility](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files/utility)**
- **[Rows Columns](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/rowscolumns)**
- **[WorkSheets](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets)**

> - **[Display](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/display)**
> - **[Management](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/management)**
> - **[Security](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security)**
>
> > - **[Protecting](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security/protecting)**
> > - **[UnProtecting](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security/unprotecting)**


Aspose.Cells_Java_for_Xlsx4j-v1.0.0
This initial version of the plugin is enriched with the following examples that are helpful for developers who want to compare **Xlsx4j** with **Aspose.Cells** OR migrate from **Xlsx4j** to **Aspose.Cells**.

Aspose.Cells vs Xlsx4j

Examples for code comparison in **Aspose.Cells** and **Xlsx4j**:

**Working with Spreadsheet**
- [Create New Spreadsheet](http://www.aspose.com/docs/display/cellsjava/2.2.1.1+Create+New+Spreadsheet)
- [Add Images in Spreadsheet](http://www.aspose.com/docs/display/cellsjava/2.2.1.4+Add+Images+in+Spreadsheet)
- [Open and Save Spreadsheet](http://www.aspose.com/docs/display/cellsjava/2.2.1.2+Open+and+Save+Spreadsheet)
- [Add Comments in Spreadsheet](http://www.aspose.com/docs/display/cellsjava/2.2.1.3+Add+Comments+in+Spreadsheet)
- [Row Column Height Adjustment](http://www.aspose.com/docs/display/cellsjava/2.2.1.5+Row+Column+Height+Adjustment)

Missing Features of Xlsx4j

Examples for code with missing features in **Xlsx4j** in comparison with **Aspose.Cells**:

**Working with Worksheets**
- [Set Worksheet Tab Color](http://www.aspose.com/docs/display/cellsjava/2.3.3.1+Set+Worksheet+Tab+Color)
- [Save Each Worksheet to Different PDF](http://www.aspose.com/docs/display/cellsjava/2.3.3.2+Save+Each+Worksheet+to+Different+PDF)
- [Detect Merged Cells](http://www.aspose.com/docs/display/cellsjava/2.3.3.3+Detect+Merged+Cells)
- [Display and Hide Tabs of Workbook](http://www.aspose.com/docs/display/cellsjava/2.3.3.4+Display+and+Hide+Tabs+of+Workbook)
- [Display and Hide Scrollbars of Workbooks](http://www.aspose.com/docs/display/cellsjava/2.3.3.5+Display+and+Hide+Scrollbars+of+Workbooks)
- [Convert Workbook to HTML](http://www.aspose.com/docs/display/cellsjava/2.3.3.6+Convert+Workbook+to+HTML)

**Working with Charts**
- [Create Charts](http://www.aspose.com/docs/display/cellsjava/2.3.2.1+Create+Charts)
- [Convert Chart to Image](http://www.aspose.com/docs/display/cellsjava/2.3.2.2+Convert+Chart+to+Image)
- [Create Pivot Charts](http://www.aspose.com/docs/display/cellsjava/2.3.2.3+Create+Pivot+Charts)

**Data Handling Features**
- [Find Value in Cells](http://www.aspose.com/docs/display/cellsjava/2.3.1.1+Find+Value+in+Cells)
- [Calculate Sub Totals](http://www.aspose.com/docs/display/cellsjava/2.3.1.2+Calculate+Sub+Totals)
- [Import Data to Worksheets](http://www.aspose.com/docs/display/cellsjava/2.3.1.3+Import+Data+to+Worksheets)
- [Export Data from Worksheets](http://www.aspose.com/docs/display/cellsjava/2.3.1.4+Export+Data+from+Worksheets)
- [Sort Data](http://www.aspose.com/docs/display/cellsjava/2.3.1.5+Sort+Data)
- [Tracing Precedents and Dependents](http://www.aspose.com/docs/display/cellsjava/2.3.1.6+Tracing+Precedents+and+Dependents)
- [Formula Calculation Engine](http://www.aspose.com/docs/display/cellsjava/2.3.1.7+Formula+Calculation+Engine)

**Miscellaneous Examples**
- [Convert Spreadsheet to PDF](http://www.aspose.com/docs/display/cellsjava/2.3.4.2+Convert+Spreadsheet+to+PDF)
- [Set Print Titles](http://www.aspose.com/docs/display/cellsjava/2.3.4.1+Set+Print+Titles)
- [Create Pivot Table](http://www.aspose.com/docs/display/cellsjava/2.3.4.4+Create+Pivot+Table)
- [Printing Workbooks](http://www.aspose.com/docs/display/cellsjava/2.3.4.3+Printing+Workbooks)


Aspose.Cells_Java_for_Apache_POI_SS-v1.0.0
This initial version is enriched with the following examples that are helpful for developers who want to compare **Apache POI SS** with **Aspose.Cells for Java** OR migrate from **Apache POI SS** to **Aspose.Cells for Java**.

Aspose.Cells vs Apache POI SS

**Working with Workbooks**
- [Create New Workbook](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.1.1+Create+New+Workbook)
- [Add Data in Cells](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.1.2+Add+Data+in+Cells)
- [Set Print Area](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.1.3+Set+Print+Area)
- [Page Setup - Fit to Page Setting](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.1.4+Page+Setup+-+Fit+to+Page+Setting)

**Working with Worksheets**
- [Create New Worksheet](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.2.1+Create+New+Worksheet)
- [Copy Sheet Within Workbook](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.2.2+Copy+Sheet+Within+Workbook)
- [Re-Order Sheets Within Workbook](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.2.3+Re-Order+Sheets+Within+Workbook)
- [Zoom Factor](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.2.4+Zoom+Factor)
- [Header and Footers](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.2.5+Header+and+Footers)
- [Add Images in Worksheet](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.2.6+Add+Images+in+Worksheet)

**Working with Cells, Rows and Columns**
- [Freeze Panes](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.1+Freeze+Panes)
- [Hide / Unhide Cells](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.2+Hide+and+Unhide+Cells)
- [Merge Cells](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.3+Merge+Cells)
- [Auto Fit Row and Column](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.4+Auto+Fit+Row+and+Column)
- [Iterate Rows and Columns](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.5+Iterate+Rows+and+Columns)
- [Split Panes](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.6+Split+Panes)
- [Insert Cell Comments](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.7+Insert+Cell+Comments)
- [Cell Alignment Settings](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.3.8+Cell+Alignment+Settings)

**Working with Data**
- [Getting Cell Contents](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.4.1+Getting+Cell+Contents)
- [New Line in Cells](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.4.2+New+Line+in+Cells)
- [Insert Hyperlinks in Worksheet](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.4.3+Insert+Hyperlinks+in+Worksheet)

**Working with Formatting Features**
- [Working with Fonts](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.5.1+Working+with+Fonts)
- [Working with Colors](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.5.2+Working+with+Colors)
- [Working with Borders](http://docs.aspose.com:8082/docs/display/cellsjava/1.2.5.3+Working+with+Borders)

Features of Aspose.Cells missing in Apache POI SS

**Working with Worksheets**
- [Add Word Art Watermark to Worksheet](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.3+Add+Word+Art+Watermark+to+Worksheet)
- [Save Each Worksheet to Different PDF](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.2+Save+Each+Worksheet+to+Different+PDF)
- [Set Worksheet Tab Color](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.1+Set+Worksheet+Tab+Color)
- [Read CSV File With Multiple Encodings](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.4+Read+CSV+File+With+Multiple+Encodings)
- [Detect Merged Cells](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.5+Detect+Merged+Cells)
- [Display and Hide Tabs of Workbook](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.6+Display+and+Hide+Tabs+of+Workbook)
- [Display and Hide Scrollbars of Workbooks](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.7+Display+and+Hide+Scrollbars+of+Workbooks)
- [Convert Workbook to HTML](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.8+Convert+Workbook+to+HTML)
- [Encrypt Workbook](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.2.9+Encrypt+Workbook)

**Working with Charts**
- [Create Charts](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.3.1+Create+Charts)
- [Convert Chart to Images](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.3.2+Convert+Chart+to+Images)
- [Create Pivot Charts](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.3.3+Create+Pivot+Charts)
- [Add Word Art Watermark to Chart](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.3.4+Add+Word+Art+Watermark+to+Chart)
- [Change Chart Position and Size](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.3.5+Change+Chart+Position+and+Size)

**Data Handling Features**
- [Sort Data in Spreadsheets](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.7+Sort+Data+in+Spreadsheets)
- [Find Value in Cells](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.1+Find+Value+in+Cells)
- [Calculate Sub Totals](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.2+Calculate+Sub+Totals)
- [Formula Calculation Engine](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.3+Formula+Calculation+Engine)
- [Import Data to Worksheets](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.4+Import+Data+to+Worksheets)
- [Export Data from Worksheets](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.5+Export+Data+from+Worksheets)
- [Tracing Precedents and Dependents](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.6+Tracing+Precedents+and+Dependents)
- [Create Pivot Table](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.8+Create+Pivot+Table)

**Miscellaneous Examples**
- [Set Print Titles](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.4.1+Set+Print+Titles)
- [Printing Workbooks](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.4.2+Printing+Workbooks)
- [Convert Spreadsheet to PDF](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.4.3+Convert+Spreadsheet+to+PDF)


Aspose.Cells_Java_for_IntelliJ_IDEA(Maven)-v1.0.0.0
:sparkles: What's New

The release contains the following wizards:

1. **Aspose.Cells Maven Project** wizard
2. **Aspose.Cells Examples** wizard


Aspose.Cells Maven Project wizard creates Aspose.Cells for Java API Maven project for using Aspose.Cells for Java API.

Aspose.Cells Examples wizard lets you import / copy downloaded [Examples Source Codes](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples) into the project along with the required resources for the execution of examples.

The [wizard](http://www.aspose.com/docs/display/cellsjava/7.2.2.2+Aspose.Cells+Examples+Wizard) currently integrates the following [Aspose.Cells](http://goo.gl/c1eSD2) examples with the IntelliJ IDEA:
- **[Charts](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts)**

> - **[Fundamental](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts/fundamental)**
> - **[Management](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/charts/management)**
- **[Data](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data)**

> - **[Addons](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon)**
>
> > - **[Hyperlinks](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/hyperlinks)**
> > - **[Merging](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/merging)**
> > - **[Named Ranges](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/addon/namedranges)**
> - **[Handling](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling)**
>
> > - **[Accessing Cells](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/accessingcells)**
> > - **[Find](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/find)**
> > - **[Importing](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/handling/importing)**
> - **[Processing](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/processing)**
>
> > - **[Filtering And Validation](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/data/processing/filteringandvalidation)**
- **[Files](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files)**

> - **[Handling](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files/handling)**
> - **[Utility](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/files/utility)**
- **[Rows Columns](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/rowscolumns)**
- **[WorkSheets](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets)**

> - **[Display](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/display)**
> - **[Management](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/management)**
> - **[Security](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security)**
>
> > - **[Protecting](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security/protecting)**
> > - **[UnProtecting](https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples/src/main/java/com/aspose/cells/examples/worksheets/security/unprotecting)**

Please also check this [Blog Post on Aspose blogs](http://goo.gl/ozzy4I) for the **plugin release v1.0.0.0**


More_Aspose.Cells_Java_vs_Xlsx_v1.3

- [Display and Hide Tabs of Workbook](http://www.aspose.com/docs/display/cellsjava/1.3.2.6+Display+and+Hide+Tabs+of+Workbook)
- [Display and Hide Scrollbars of Workbooks](http://www.aspose.com/docs/display/cellsjava/1.3.2.7+Display+and+Hide+Scrollbars+of+Workbooks)
- [Convert Workbook to HTML](http://www.aspose.com/docs/display/cellsjava/1.3.2.8+Convert+Workbook+to+HTML)
- [Encrypt Workbook](http://www.aspose.com/docs/display/cellsjava/1.3.2.9+Encrypt+Workbook)
- [Change Chart Position and Size](http://www.aspose.com/docs/display/cellsjava/1.3.3.5+Change+Chart+Position+and+Size)
- [Create Pivot Table](http://docs.aspose.com:8082/docs/display/cellsjava/1.3.1.8+Create+Pivot+Table)

Existing Examples

**Data Handling Features**
- [Find Value in Cells](http://www.aspose.com/docs/display/cellsjava/1.3.1.1+Find+Value+in+Cells)
- [Calculate Sub Totals](http://www.aspose.com/docs/display/cellsjava/1.3.1.2+Calculate+Sub+Totals)
- [Formula Calculation Engine](http://www.aspose.com/docs/display/cellsjava/1.3.1.3+Formula+Calculation+Engine)
- [Import Data to Worksheets](http://www.aspose.com/docs/display/cellsjava/1.3.1.4+Import+Data+to+Worksheets)
- [Export Data from Worksheets](http://www.aspose.com/docs/display/cellsjava/1.3.1.5+Export+Data+from+Worksheets)
- [Tracing Precedents and Dependents](http://www.aspose.com/docs/display/cellsjava/1.3.1.6+Tracing+Precedents+and+Dependents)
- [Sort Data in Spreadsheets](http://www.aspose.com/docs/display/cellsjava/1.3.1.7+Sort+Data+in+Spreadsheets)

**Working with Worksheets**
- [Set Worksheet Tab Color](http://www.aspose.com/docs/display/cellsjava/1.3.2.1+Set+Worksheet+Tab+Color)
- [Save Each Worksheet to Different PDF](http://www.aspose.com/docs/display/cellsjava/1.3.2.2+Save+Each+Worksheet+to+Different+PDF)
- [Add Word Art Watermark to Worksheet](http://www.aspose.com/docs/display/cellsjava/1.3.2.3+Add+Word+Art+Watermark+to+Worksheet)
- [Read CSV File With Multiple Encodings](http://www.aspose.com/docs/display/cellsjava/1.3.2.4+Read+CSV+File+With+Multiple+Encodings)
- [Detect Merged Cells](http://www.aspose.com/docs/display/cellsjava/1.3.2.5+Detect+Merged+Cells)
- [Convert Spreadsheet to PDF](http://www.aspose.com/docs/display/cellsjava/1.3.4.3+Convert+Spreadsheet+to+PDF)

**Working with Charts**
- [Create Charts](http://www.aspose.com/docs/display/cellsjava/1.3.3.1+Create+Charts)
- [Convert Chart to Images](http://www.aspose.com/docs/display/cellsjava/1.3.3.2+Convert+Chart+to+Images)
- [Create Pivot Charts](http://www.aspose.com/docs/display/cellsjava/1.3.3.3+Create+Pivot+Charts)
- [Add Word Art Watermark to Chart](http://www.aspose.com/docs/display/cellsjava/1.3.3.4+Add+Word+Art+Watermark+to+Chart)

**Working with Workbooks**
- [Set Print Titles](http://www.aspose.com/docs/display/cellsjava/1.3.4.1+Set+Print+Titles)
- [Printing Workbooks](http://www.aspose.com/docs/display/cellsjava/1.3.4.2+Printing+Workbooks)

Feedback and Suggestions
- Many more examples are available at [Aspose Docs](http://www.aspose.com/docs/display/cellsjava/Home).
- Raise your queries and suggest more examples via [Aspose Forums](http://www.aspose.com/community/forums/default.aspx) or via this social coding site.

Release contain the open source code showing features that are only available in Aspose.Cells for Java but missing in Xlsx4j API of Project Docx4j - Dealing Microsoft Excel of MS Office and Apache OpenOffice Calc Spreadsheets.

[](http://www.aspose.com/java/excel-component.aspx) [](http://www.docx4java.org/trac/docx4j)

:sparkles: What's New ?
- [Display and Hide Tabs of Workbook](http://www.aspose.com/docs/display/cellsjava/2.3.3.4+Display+and+Hide+Tabs+of+Workbook)
- [Display and Hide Scrollbars of Workbooks](http://www.aspose.com/docs/display/cellsjava/2.3.3.5+Display+and+Hide+Scrollbars+of+Workbooks)
- [Convert Workbook to HTML](http://www.aspose.com/docs/display/cellsjava/2.3.3.6+Convert+Workbook+to+HTML)
- [Tracing Precedents and Dependents](http://www.aspose.com/docs/display/cellsjava/2.3.1.6+Tracing+Precedents+and+Dependents)
- [Formula Calculation Engine](http://www.aspose.com/docs/display/cellsjava/2.3.1.7+Formula+Calculation+Engine)

[](https://asposejavadocx4j.codeplex.com/releases)

:sparkles: Existing Examples

**Data Handling Features**
- [Find Value in Cells](http://www.aspose.com/docs/display/cellsjava/2.3.1.1+Find+Value+in+Cells)
- [Calculate Sub Totals](http://www.aspose.com/docs/display/cellsjava/2.3.1.2+Calculate+Sub+Totals)
- [Import Data to Worksheets](http://www.aspose.com/docs/display/cellsjava/2.3.1.3+Import+Data+to+Worksheets)
- [Export Data from Worksheets](http://www.aspose.com/docs/display/cellsjava/2.3.1.4+Export+Data+from+Worksheets)
- [Sort Data](http://www.aspose.com/docs/display/cellsjava/2.3.1.5+Sort+Data)

**Working with Charts**
- [Create Charts](http://www.aspose.com/docs/display/cellsjava/2.3.2.1+Create+Charts)
- [Convert Chart to Image](http://www.aspose.com/docs/display/cellsjava/2.3.2.2+Convert+Chart+to+Image)
- [Create Pivot Charts](http://www.aspose.com/docs/display/cellsjava/2.3.2.3+Create+Pivot+Charts)

**Working with Worksheets**
- [Set Worksheet Tab Color](http://www.aspose.com/docs/display/cellsjava/2.3.3.1+Set+Worksheet+Tab+Color)
- [Save Each Worksheet to Different PDF](http://www.aspose.com/docs/display/cellsjava/2.3.3.2+Save+Each+Worksheet+to+Different+PDF)
- [Detect Merged Cells](http://www.aspose.com/docs/display/cellsjava/2.3.3.3+Detect+Merged+Cells)

**Miscellaneous Examples**
- [Set Print Titles](http://www.aspose.com/docs/display/cellsjava/2.3.4.1+Set+Print+Titles)
- [Convert Spreadsheet to PDF](http://www.aspose.com/docs/display/cellsjava/2.3.4.2+Convert+Spreadsheet+to+PDF)
- [Printing Workbooks](http://www.aspose.com/docs/display/cellsjava/2.3.4.3+Printing+Workbooks)
- [Create Pivot Table](http://www.aspose.com/docs/display/cellsjava/2.3.4.4+Create+Pivot+Table)

[](https://asposejavadocx4j.codeplex.com/releases)

Feedback and Suggestions
- Many more examples are available at [Aspose Docs](http://www.aspose.com/docs/display/cellsjava).
- Raise your queries and suggest more examples via [Aspose Forums](http://www.aspose.com/community/forums/default.aspx) or via this social coding site.


Aspose.Cells_Java_vs_POI_SS_v1.4

Aspose Cells Java for PHP is a PHP project that demonstrates / provides the Aspose.Cells for Java API usage examples in PHP by using PHP/JAVA Bridge.

You will need to configure PHP/Java Bridge before using any of the Aspose provided Java APIs in PHP e.g Aspose.Words, Aspose.Cells and Aspose.Slides etc.

For the configuration/setup of PHP/Java Bridge, please see:

http://php-java-bridge.sourceforge.net/pjb/index.php

To download Aspose.Cells for Java API to be used with these examples through PHP/Java Bridge
Please navigate to:

http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

For most complete documentation of the project, check Aspose.Cells Java for PHP confluence wiki link:

http://www.aspose.com/docs/display/cellsjava/5.+Aspose.Cells+Java+for+PHP


Aspose.Cells_Java_for_Struts_1.3-v1.0
Demonstrates the **Aspose.Cells for Java API** usage within Struts 1.3 and Maven Framework.

**Aspose.Cells for Java API** is very rich in features, however this demo web application only gives simple usage example i.e initiate / creation of Work Book, Sheets, Applying Styles to Cells and Writing texts to it.

For complete features list of **Aspose.Cells for Java API**, you are recommended to browse the following url:

http://www.aspose.com/java/excel-component.aspx


Aspose.Cells_Java_for_Ruby-v1.0.0
Aspose Cells Java for Ruby is a gem that provides the Aspose.Cells for Java API usage examples in Ruby by using Rjb - Ruby Java Bridge.

You will need to configure RJB gem before using any of the Aspose provided Java APIs in Ruby e.g; Aspose.Words, Aspose.Cells and Aspose.Slides etc;

To download Aspose.Cells for Java API to be used with these examples through RJB gem, Please navigate to:

http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

For most complete documentation of the project, check Aspose.Cells Java for Ruby confluence wiki link:

http://www.aspose.com/docs/display/cellsjava/4.+Aspose.Cells+Java+For+Ruby


More-Aspose.Cells-vs-POI-SS-v1.4
 Release contain the Aspose.Cells features missing in Apache POI HSSF + XSSF for dealing with Microsoft Excel and OpenOffice spreadsheets.