Aspose.Cells vs Apache POI SS (HSSF + XSSF) v 1.5

Aspose.Cells vs Apache POI SS (HSSF + XSSF) v 1.5

Release contain the open source code comparison examples among features of Aspose.Cells Java and Apache POI HSSF and XSSF - Dealing Microsoft Excel of MS Office and OpenOffice Calc Spreadsheets.

✨ What's New ?

• Create Different Cell Types
• Create Date Cell
• Create Charts
• Create Pivot Tables

✨ Existing Examples

Working with Workbook

• Create New Workbook
• Add Data in Cells
• Set Print Area
• Page Setup - Fit to Page Setting

Working with Worksheets

• Create New Worksheet
• Convert Worksheet to CSV
• 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 and 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

Feedback and Suggestions

• Many more examples are available at Aspose Docs.
• Raise your queries and suggest more examples via Aspose Forums or via this social coding site.