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
• 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
• Auto Fit 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

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