Aspose.Cells Java for Python - v1.0

Aspose.Cells Java for Python - v1.0

Aspose.Cells for Java is an advanced class library for Java that enables you to perform a great range of document processing tasks directly within your Java
applications.

Aspose.Cells for Java supports processing Cells (DOC, DOCX, OOXML, RTF) HTML, OpenDocument, PDF, EPUB, XPS, SWF and all image formats. With Aspose.Cells you can generate, modify, and convert documents without using Microsoft Cells.

✨ What's New ?

Quick Start

• Hello World in Python

Working With Files in Python

• Opening Files in Python
• Saving Files in Python
• Converting Excel Files to HTML in Python
• Converting Excel Files to HTML in Python
• Converting To MHTML Files in Python
• Converting Worksheet to Image in Python
• Converting Worksheet to SVG in Python
• Managing Document Properties in Python

Working With Rows And Columns in Python

• Adjusting Row Height and Column Width in Python
• Autofit Rows and Columns in Python
• Copying Rows and Columns in Python
• Grouping and Ungrouping Rows and Columns in Python
• Hiding and Showing Rows and Columns in Python
• Inserting and Deleting Rows and Columns in Python

Working With Worksheets in Python

• Display or Hide Gridlines in Python
• Display or Hide Scroll Bars in Python
• Display or Hide Tabs in Python
• Freeze Panes in Python
• Hide or Unhide a Worksheet in Python
• Page Break Preview in Python
• Split Panes in Python
• Zoom Factor in Python
• Setting Page Options in Python
• Protecting Worksheets in Python
• Unprotect a Worksheet in Python
• Copying and Moving Worksheets in Python
• Managing Page Breaks in Python

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 (Maven) for Eclipse – v1.0

This is new Plugin for Eclipse IDE by Aspose. The Plugin intended for developers using Maven platform for Java developments and want to use Aspose.Cells for Java in their projects.

NOTE: Aspose.Cells for Java is Java API developed by Aspose that offers easy Microsoft Excel spreadsheets creation and manipulation right from within Java Projects. For the API detailed features list check the link.

The release contains the following features:

Aspose.Cells Maven Project (wizard)

• By using this wizard plugin creates Maven project for using Aspose.Cells for Java from New -> Project -> Maven-> Aspose.Cells Maven Project
• The wizard will also give option for downloading latest available Code Examples for using the API.

Aspose.Cells Code Example (wizard)

• By using this wizard plugin lets you copy the downloaded Code Examples into your project for using Aspose.Cells for Java from New -> Other -> Java -> Aspose.Cells Code Example
• The wizard will also look for and updates for newly available Code Examples from Aspose.Cells for Java examples repository.
  (Selected Code Examples (category) source codes will be copied under "com.aspose.cells.examples" package. Resources needed for running examples will be copied to the corresponding directory (package) within "src/main/resources").

Other Features

• Supports latest Eclipse Mars.1 (4.5.1) version
• Compatible with Mac, Linux Flavors and Windows
• Native IDE user experience
• Open Source

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.

Aspose.Cells Java for Jython - v1.0.0

Demonstrates the Aspose.Cells for Java API usage within Jython.

Aspose.Cells for Java API is very rich in features, however this release provides usage examples for following features:

Quick Start

• Hello World

Working With Files

• Converting ExcelFiles into Html
• Converting to Mhtml files
• Converting to XPS
• Converting Worksheet to SVG
• Excel to Pdf conversion
• Managing Document Properties
• Opening Files
• Saving Files
• Worksheet to Image

Working with Rows and Columns

• Rows and Columns

Working with Worksheets

• Adding Worksheets to New Excel File
• Copying And Moving Worksheets
• Display Hide Gridlines
• Display Hide Scroll Bars
• Freeze Panes
• Hide Unhide Worksheet
• Page Break Preview
• Protecting Worksheet
• Removing Worksheets using Sheet Index
• Removing Worksheets using Sheet Name
• Setting Page Options
• Split Panes
• Unprotecting Password Protected Worksheet
• Unprotecting Simply Protected Worksheet
• Zoom Factor

Aspose.Cells Java for NetBeans 8.1 (Maven) Plugin - v1.0.0

✨ What's New

The release contains the following wizards:

1. Aspose.Cells Maven Project wizard
2. Aspose.Cells Code Example wizard

Aspose.Cells Maven Project wizard creates Maven project for using Aspose.Cells for Java API i.e by adding its latest Maven Dependency reference in pom.xml.

Aspose.Cells Code Examples wizard lets you import / copy downloaded Code Examples into the project along with the required data files for examples.

Aspose.Cells Code Example wizard currently integrates the following Aspose.Cells examples with the NetBeans IDE:

• Charts

• Fundamental
• Management

• Data

• Addons

• Hyperlinks
• Merging
• Named Ranges

• Handling

• Accessing Cells
• Find
• Importing

• Processing

• Filtering And Validation

• Files

• Handling
• Utility

• Rows Columns
• WorkSheets

• Display
• Management
• Security

• Protecting
• UnProtecting

Aspose.Cells Java for NetBeans 8.0 (Maven) Plugin - v1.0.0

✨ What's New

The release contains the following wizards:

1. Aspose.Cells Maven Project wizard
2. Aspose.Cells Code Example wizard

Aspose.Cells Maven Project wizard creates Aspose.Cells for Java API Maven project for using Aspose.Cells for Java API.

Aspose.Cells Code Example wizard lets you import / copy downloaded Code Examples into the project along with the required resources needed by the examples.

Aspose.Cells Code Example wizard currently integrates the following Aspose.Cells examples with the NetBeans IDE:

• Charts

• Fundamental
• Management

• Data

• Addons

• Hyperlinks
• Merging
• Named Ranges

• Handling

• Accessing Cells
• Find
• Importing

• Processing

• Filtering And Validation

• Files

• Handling
• Utility

• Rows Columns
• WorkSheets

• Display
• Management
• Security

• Protecting
• UnProtecting

Aspose.Cells Java for Xlsx4j - v1.0.0

This initial version of the plugin is enriched with the following examples that are helpful for developers who want to compare Xlsx4j with Aspose.Cells OR migrate from Xlsx4j to Aspose.Cells.

Aspose.Cells vs Xlsx4j

Examples for code comparison in Aspose.Cells and Xlsx4j:

Working with Spreadsheet

• Create New Spreadsheet
• Add Images in Spreadsheet
• Open and Save Spreadsheet
• Add Comments in Spreadsheet
• Row Column Height Adjustment

Missing Features of Xlsx4j

Examples for code with missing features in Xlsx4j in comparison with Aspose.Cells:

Working with Worksheets

• Set Worksheet Tab Color
• Save Each Worksheet to Different PDF
• Detect Merged Cells
• Display and Hide Tabs of Workbook
• Display and Hide Scrollbars of Workbooks
• Convert Workbook to HTML

Working with Charts

• Create Charts
• Convert Chart to Image
• Create Pivot Charts

Data Handling Features

• Find Value in Cells
• Calculate Sub Totals
• Import Data to Worksheets
• Export Data from Worksheets
• Sort Data
• Tracing Precedents and Dependents
• Formula Calculation Engine

Miscellaneous Examples

• Convert Spreadsheet to PDF
• Set Print Titles
• Create Pivot Table
• Printing Workbooks

Aspose.Cells Java for Apache POI SS - v1.0.0

This initial version is enriched with the following examples that are helpful for developers who want to compare Apache POI SS with Aspose.Cells for Java OR migrate from Apache POI SS to Aspose.Cells for Java.

Aspose.Cells vs Apache POI SS

Working with Workbooks

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

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 / 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

Features of Aspose.Cells missing in Apache POI SS

Working with Worksheets

• Add Word Art Watermark to Worksheet
• Save Each Worksheet to Different PDF
• Set Worksheet Tab Color
• Read CSV File With Multiple Encodings
• Detect Merged Cells
• Display and Hide Tabs of Workbook
• Display and Hide Scrollbars of Workbooks
• Convert Workbook to HTML
• Encrypt Workbook

Working with Charts

• Create Charts
• Convert Chart to Images
• Create Pivot Charts
• Add Word Art Watermark to Chart
• Change Chart Position and Size

Data Handling Features

• Sort Data in Spreadsheets
• Find Value in Cells
• Calculate Sub Totals
• Formula Calculation Engine
• Import Data to Worksheets
• Export Data from Worksheets
• Tracing Precedents and Dependents
• Create Pivot Table

Miscellaneous Examples

• Set Print Titles
• Printing Workbooks
• Convert Spreadsheet to PDF

Aspose.Cells Java for IntelliJ IDEA(Maven) Plugin - v1.0.0

✨ What's New

The release contains the following wizards:

1. Aspose.Cells Maven Project wizard
2. Aspose.Cells Examples wizard

Aspose.Cells Maven Project wizard creates Aspose.Cells for Java API Maven project for using Aspose.Cells for Java API.

Aspose.Cells Examples wizard lets you import / copy downloaded Examples Source Codes into the project along with the required resources for the execution of examples.

The wizard currently integrates the following Aspose.Cells examples with the IntelliJ IDEA:

• Charts

• Fundamental
• Management

• Data

• Addons

• Hyperlinks
• Merging
• Named Ranges

• Handling

• Accessing Cells
• Find
• Importing

• Processing

• Filtering And Validation

• Files

• Handling
• Utility

• Rows Columns
• WorkSheets

• Display
• Management
• Security

• Protecting
• UnProtecting

Please also check this Blog Post on Aspose blogs for the plugin release v1.0.0.0

Aspose.Cells Features Missing in Xlsx4j - v 1.3

Aspose.Cells Features Missing in Xlsx4j - v 1.3

Release contain the open source code showing features that are only available in Aspose.Cells for Java but missing in Xlsx4j API of Project Docx4j - Dealing Microsoft Excel of MS Office and Apache OpenOffice Calc Spreadsheets.

✨ What's New ?

• Display and Hide Tabs of Workbook
• Display and Hide Scrollbars of Workbooks
• Convert Workbook to HTML
• Tracing Precedents and Dependents
• Formula Calculation Engine

✨ Existing Examples

Data Handling Features

• Find Value in Cells
• Calculate Sub Totals
• Import Data to Worksheets
• Export Data from Worksheets
• Sort Data

Working with Charts

• Create Charts
• Convert Chart to Image
• Create Pivot Charts

Working with Worksheets

• Set Worksheet Tab Color
• Save Each Worksheet to Different PDF
• Detect Merged Cells

Miscellaneous Examples

• Set Print Titles
• Convert Spreadsheet to PDF
• Printing Workbooks
• Create Pivot Table

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.