Feature Comparison of Aspoce.Cells vs Apache POI SS (HSSF + XSSF)

Project Aspose.Cells Java for Apache POI SS shows how different tasks can be performed using Aspose.Cells for Java API in comparison with Apache POI SS. The project also covers the features that are only available in Aspose.Cells for Java APIs but not in Apache POI for Microsoft Excel.

Downloads

Please check the link below to find instructions on downloading and configure Aspose.Cells Java for Apache POI SS.

• Downloads

OR

You can download the latest version from:

• CodePlex
• GitHub

Aspose.Cells vs Apache POI SS - Code Examples

These are examples of code comparison in Aspose.Cells and Apache POI SS.

Working with Workbooks

• Create New Workbook
• Add Data in Cells
• Set Print Area
• Page Setup - Fit to Page Setting

Working with Worksheets

• Create New Worksheet
• Copy Sheet Within Workbook
• Re-Order Sheets Within Workbook
• Zoom Factor
• Header and Footers
• Add Images in Worksheet

Working with Cells, Rows, and Columns

• Freeze Panes
• Hide / Unhide Cells
• Merge Cells
• AutoFit Row and Column
• Iterate Rows and Columns
• Split Panes
• Insert Cell Comments
• Cell Alignment Settings

Working with Data

• Getting Cell Contents
• New Line in Cells
• Insert Hyperlinks in Worksheet

Working with Formatting Features

• Working with Fonts
• Working with Colors
• Working with Borders

Features of Aspose.Cells Missing in Apache POI SS

There are many features that are only available in Aspose.Cells API but not in Apache POI SS.

Working with Worksheets

• Add Word Art Watermark to Worksheet
• Save Each Worksheet to Different PDF
• Set Worksheet Tab Color
• Read CSV File With Multiple Encodings
• Detect Merged Cells
• Display and Hide Tabs of Workbook
• Display and Hide Scrollbars of Workbooks
• Convert Workbook to HTML
• Encrypt Workbook

Working with Charts

• Create Charts
• Convert Chart to Images
• Create Pivot Charts
• Add Word Art Watermark to Chart
• Change Chart Position and Size

Data Handling Features

• Sort Data in Spreadsheets
• Find Value in Cells
• Calculate Sub Totals
• Formula Calculation Engine
• Import Data to Worksheets
• Export Data from Worksheets
• Tracing Precedents and Dependents
• Create Pivot Table

Miscellaneous Examples

• Set Print Titles
• Printing Workbooks
• Convert Spreadsheet to PDF

Aspose.Cells Java for Apache POI SS Documentation

Aspose.Cells Java for Apache POI SS Documentation is available to guide developers to get familiar with the specific resources and operations within the Aspose.Cells Java for Apache POI SS.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with Aspose. Once you have signed up, you are ready to try powerful file processing features offered by Aspose file format APIs.

Customer Feedback

Your feedback is very important to us. Please feel free to provide feedback and raise feature requirements. We are keen to implement customer-driven features since we are a 100% customer-driven company.