Apache POI VS JExcel

Apache POI VS JExcel

First, here are the things where both APIs have the same end functionality:

·         Both are free

·         Cell styling: alignment, backgrounds (colors and patterns), borders (types and colors), font support (font names, colors, size, bold, italic, strikeout, underline)

·         Formulas

·         Hyperlinks

·         Merged cell regions

·         Size of rows and columns

·         Data formatting: Numbers and Dates

·         Text wrapping within cells

·         Freeze Panes

·         Header/Footer support

·         Read/Write existing and new spreadsheets

·         Both attempt to keep existing objects in spreadsheets they read in intact as far as possible.

However, there are many differences:

·         Perhaps the most significant difference is that Java JXL does not support the Excel 2007+ ".xlsx" format; it only supports the old BIFF (binary) ".xls" format. Apache POI supports both with a common design.

·         Additionally, the Java portion of the JXL API was last updated in 2009 (3 years, 4 months ago as I write this), although it looks like there is a C# API. Apache POI is actively maintained.

·         JXL doesn't support Conditional Formatting, Apache POI does, although this is not that significant, because you can conditionally format cells with your own code.

·         JXL doesn't support rich text formatting, i.e. different formatting within a text string; Apache POI does support it.

·         JXL only supports certain text rotations: horizontal/vertical, +/- 45 degrees, and stacked; Apache POI supports any integer number of degrees plus stacked.

·         JXL doesn't support drawing shapes; Apache POI does.

·         JXL supports most Page Setup settings such as Landscape/Portrait, Margins, Paper size, and Zoom. Apache POI supports all of that plus Repeating Rows and Columns.

·         JXL doesn't support Split Panes; Apache POI does.

·         JXL doesn't support Chart creation or manipulation; that support isn't there yet in Apache POI, but an API is slowly starting to form.

·         Apache POI has a more extensive set of documentation and examples available than JXL.

Additionally, POI contains not just the main "usermodel" API, but also an event-based API if all you want to do is read the spreadsheet content.

Home

SAOP vs RESTful web services

SOAP vs RESTful Difference

	SOAP	RESTful
Developer View	Object Oriented	Resource oriented
Standards Based	Yes	No
Security	SSL, WS-Security	SSL
Transactions	WS-Atomic transaction	No
Reliability	WS-Reliable Messaging	Application Specific
Performance	Good	Better
Caching	No	GET operation can be cached.
Message Size	Heavy , has SOAP and WS-* specific mark-up	Lightweight, no extra mark-up
Message  Communication Protocol	XML	XML, JSON, Other valid MIME type.
Message Encoding	Yes	No
Service Description	WSDL	No formal contract defined.
Human Intelligible Payload	No	Yes
Developer Tooling	Yes	Minimal or none
Orientation	Wraps business logic	Accesses resources/data
Abbreviation	Simple Object Access Protocol	Representational State Transfer
Simplicity	No	Yes
Transport Protocol Support	HTTP, SMTP, JMS	HTTP

HOME

Java

Java

Java is a high-level programming language originally developed by Sun Microsystems and released in 1995. Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX. This tutorial gives a complete understanding of Java.

Java is a computer programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible. It is intended to let application developers "write once, run anywhere", meaning that code that runs on one platform does not need to be recompiled to run on another. Java applications are typically compiled to bytecode  that can run on any Java virtual machine (JVM) regardless of computer architecture.

Topics:

Apache POI VS JExcel

Web Services

Web Services

Web services are client and server applications that communicate over the World Wide Web’s (WWW) HyperText Transfer Protocol (HTTP). As described by the World Wide Web Consortium (W3C), web services provide a standard means of interoperating between software applications running on a variety of platforms and frameworks. Web services are characterized by their great interoperability and extensibility, as well as their machine-processable descriptions, thanks to the use of XML. Web services can be combined in a loosely coupled way to achieve complex operations. Programs providing simple services can interact with each other to deliver sophisticated added-value services.

Types of Web Services

·         SOAP Web Services

·         RESTful Web Services

Topics

SAOP vs RESTfulweb services