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

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

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 ?

• Convert Worksheet to CSV
• Split Panes
• Insert Cell Comments
• Cell Alignment Settings
• Page Setup - Fit to Page Setting

✨ Existing Examples

Working with Workbook

• Create New Workbook
• Add Data in Cells
• Set Print Area

Working with Worksheets

• Create New Worksheet
• 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

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.

Aspose.Cells Java for PHP - v1.0.0

Aspose.Cells Java for PHP - v1.0.0

Aspose Cells Java for PHP is a PHP project that demonstrates / provides the Aspose.Cells for Java API usage examples in PHP by using PHP/JAVA Bridge.

You will need to configure PHP/Java Bridge before using any of the Aspose provided Java APIs in PHP e.g Aspose.Words, Aspose.Cells and Aspose.Slides etc.

For the configuration/setup of PHP/Java Bridge, please see:

http://php-java-bridge.sourceforge.net/pjb/index.php

To download Aspose.Cells for Java API to be used with these examples through PHP/Java Bridge
Please navigate to:

http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

For most complete documentation of the project, check Aspose.Cells Java for PHP confluence wiki link:

http://www.aspose.com/docs/display/cellsjava/5.+Aspose.Cells+Java+for+PHP

Aspose.Cells Java for Struts 1.3

Demonstrates the Aspose.Cells for Java API usage within Struts 1.3 and Maven Framework.

Aspose.Cells for Java API is very rich in features, however this demo web application only gives simple usage example i.e initiate / creation of Work Book, Sheets, Applying Styles to Cells and Writing texts to it.

For complete features list of Aspose.Cells for Java API, you are recommended to browse the following url:

http://www.aspose.com/java/excel-component.aspx

Aspose.Cells Java for Ruby - v1.0.0

Aspose Cells Java for Ruby is a gem that provides the Aspose.Cells for Java API usage examples in Ruby by using Rjb - Ruby Java Bridge.

You will need to configure RJB gem before using any of the Aspose provided Java APIs in Ruby e.g; Aspose.Words, Aspose.Cells and Aspose.Slides etc;

To download Aspose.Cells for Java API to be used with these examples through RJB gem, Please navigate to:

http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

For most complete documentation of the project, check Aspose.Cells Java for Ruby confluence wiki link:

http://www.aspose.com/docs/display/cellsjava/4.+Aspose.Cells+Java+For+Ruby

Aspose.Cells Features Missing in Apache POI HSSF and XSSF - v 1.4

Release contain the Aspose.Cells features missing in Apache POI HSSF + XSSF for dealing with Microsoft Excel and OpenOffice spreadsheets.

What's New in v 1.4?

• Display and Hide Tabs of Workbook
• Display and Hide Scrollbars of Workbooks
• Convert Workbook to HTML
• Encrypt Workbook
• Change Chart Position and Size
• Create Pivot Table

Existing Examples

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 in Spreadsheets

Working with Worksheets

• Set Worksheet Tab Color
• Save Each Worksheet to Different PDF
• Add Word Art Watermark to Worksheet
• Read CSV File With Multiple Encodings
• Detect Merged Cells
• Convert Spreadsheet to PDF

Working with Charts

• Create Charts
• Convert Chart to Images
• Create Pivot Charts
• Add Word Art Watermark to Chart

Working with Workbooks

• Set Print Titles
• Printing Workbooks

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.