Code Comparison for Common Features in Aspose.Cells and Apache POI - HSSF and XSSF

Developers looking for spreadsheet processing libraries may need to walk through the features provided by the libraries available on the market. Mainly, a few factors are considered when choosing an option:

• Features
• Effort required to use the library
• Performance

If you are a Java developer looking to choose a spreadsheet processing library, you may want to compare Apache POI’s HSSF and XSSF SDKs with Aspose.Cells. In this case, this project will help you compare features and code using both libraries.

This section includes the following Code Comparison Examples:

• Working with Worksheets in Apache POI and Aspose.Cells
  • Create New Worksheet
  • Add Images in Worksheet
  • Convert Worksheet to CSV
  • Copy Sheet Within Workbook
  • Re‑Order Sheets Within Workbook
  • Header and Footers
  • Zoom Factor using Apache POI and Aspose.Cells
• Working with Workbooks in Apache POI and Aspose.Cells
  • Add Data to Cells
  • Create New Workbook
  • Page Setup – Fit to Page Setting
  • Set Print Area
• Working with Cells, Rows, and Columns in Apache POI and Aspose.Cells
  • Auto Fit Rows and Columns
  • Cell Alignment Settings
  • Hide and Unhide Cells
  • Insert Cell Comments
  • Iterate Rows and Columns
  • Merge Cells
  • Split Panes in Apache POI and Aspose.Cells
  • Freeze Panes in Apache POI and Aspose.Cells
  • Create Date Cell in Apache POI and Aspose.Cells
  • Create Different Cell Types in Apache POI and Aspose.Cells
• Working with Data in Apache POI and Aspose.Cells
  • Getting Cell Contents
  • Insert Hyperlinks in Worksheet
  • New Line in Cells
  • Create Pivot Tables using Apache POI and Aspose.Cells
  • Create Charts using Apache POI and Aspose.Cells
• Working with Formatting Features in Apache POI and Aspose.Cells
  • Working with Borders in Apache POI and Aspose.Cells
  • Working with Colors in Apache POI and Aspose.Cells
  • Working with Fonts in Apache POI and Aspose.Cells

Note: Many more code comparisons will be available soon.