Project Aspose for Apache POI shows how different tasks can be performed using Aspose Java APIs in comparison with Apache POI. The project also covers the Aspose features that are not available in Apache POI SS.
Examples for Aspose.Cells vs Apache POI SS
Working with Workbook
Working with Worksheets
- Create New Worksheet.
- Copy Sheet Within Workbook.
- Re-Order Sheets Within Workbook.
- Zoom Factor.
- Header and Footers.
Working with Cells, Rows and Columns
Working with Formatting Features
Examples for Missing Features of Apache POI SS in Aspose.Cells
There are many features that are only available in Aspose API but not in Apache POI SS. Below mentioned are some of these examples and source code is also hosted on CodePlex, GitHub, Bitbucket and SourceForge.
Data Handling Features
- Find Value in Cells.
- Calculate Sub Totals.
- Formula Calculation Engine.
- Import Data to Worksheets.
- Export Data from Worksheets.
- Tracing Precedents and Dependents.
- Sort Data.
Working with Charts
Feedback and Suggestions
- Many more examples are available at Aspose Docs.
- Raise your queries and suggest more examples via Aspose Forums or via any of the above mentioned social coding site.