[![][1] 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

Below listed are some examples showing code comparison side by side for both the platforms. Source code of these examples is hosted on [CodePlex][2], [GitHub][3], [Bitbucket][4] and [SourceForge][5].

Working with Workbook

  • [Create New Workbook][6].
  • [Add Data in Cells][7].
  • [Set Print Area][8].

Working with Worksheets

  • [Create New Worksheet][9].
  • [Copy Sheet Within Workbook][10].
  • [Re-Order Sheets Within Workbook][11].
  • [Zoom Factor][12].
  • [Header and Footers][13].

Working with Cells, Rows and Columns

  • [Freeze Panes][14].
  • [Hide / Unhide Cells][15].
  • [Merge Cells][16].
  • [Auto Fit Row and Column][17].

Working with Formatting Features

  • [Working with Fonts][18].
  • [Working with Colors][19].
  • [Working with Borders][20].

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][21], [GitHub][22], [Bitbucket][23] and [SourceForge][24].

Data Handling Features

  • [Find Value in Cells][25].
  • [Calculate Sub Totals][26].
  • [Formula Calculation Engine][27].
  • [Import Data to Worksheets][28].
  • [Export Data from Worksheets][29].
  • [Tracing Precedents and Dependents][30].
  • [Sort Data][31].

Working with Charts

  • [Create Charts][32].
  • [Convert Charts to Images][33].
  • [Create Pivot Charts][34].

More Examples

  • [Set Print Titles][35].
  • [Printing Workbooks][36].
  • [Create Pivot Table][37].
  • [Convert XLS to PDF][38].
  • [Detect Merged Cells][39].

Feedback and Suggestions

  • Many more examples are available at Aspose Docs.
  • Raise your queries and suggest more examples via [Aspose Forums][40] or via any of the above mentioned social coding site.

[1]: https://blog.aspose.com/wp-content/uploads/sites/2/2014/05/aspose_cells-for-java.png “Aspose.Cells for Java”)](http://www.aspose.com/java/total-component.aspx “Aspose.Cells for Java”)Project [Aspose for Apache POI](https://docs.aspose.com/ [2]: https://docs.aspose.com/ [3]: https://github.com/asposemarketplace/Aspose_for_Apache_POI [4]: https://bitbucket.org/asposemarketplace/aspose-for-apache-poi [5]: https://sourceforge.net/projects/asposeforapachepoi/ [6]: https://docs.aspose.com/ [7]: https://docs.aspose.com/ [8]: https://docs.aspose.com/ [9]: https://docs.aspose.com/ [10]: https://docs.aspose.com/ [11]: https://docs.aspose.com/ [12]: https://docs.aspose.com/ [13]: https://docs.aspose.com/ [14]: https://docs.aspose.com/ [15]: https://docs.aspose.com/ [16]: https://docs.aspose.com/ [17]: https://docs.aspose.com/ [18]: https://docs.aspose.com/ [19]: https://docs.aspose.com/ [20]: https://docs.aspose.com/ [21]: https://docs.aspose.com/ [22]: https://github.com/asposemarketplace/Aspose_for_Apache_POI [23]: https://bitbucket.org/asposemarketplace/aspose-for-apache-poi [24]: https://sourceforge.net/projects/asposeforapachepoi/ [25]: https://docs.aspose.com/ [26]: https://docs.aspose.com/ [27]: https://docs.aspose.com/ [28]: https://docs.aspose.com/ [29]: https://docs.aspose.com/ [30]: https://docs.aspose.com/ [31]: https://docs.aspose.com/ [32]: https://docs.aspose.com/ [33]: https://docs.aspose.com/ [34]: https://docs.aspose.com/ [35]: https://docs.aspose.com/ [36]: https://docs.aspose.com/ [37]: https://docs.aspose.com/ [38]: https://docs.aspose.com/ [39]: https://docs.aspose.com/ [40]: http://www.aspose.com/community/forums/default.aspx