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

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

• Features
• Efforts required to use the library
• Performance

If you are a Java developer looking to choose a spreadsheet processing library to process spreadsheets, you may want to compare Apache POI HSSF and XSSF SDK with Aspose.Cells. In this case, this very project will help you to compare features and code using both the 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 in 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 Row and Column
  • 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 are yet to be available soon.