Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Welcome to jXLS

Excel generation is required in many Java applications that have some kind of reporting functionality.

Tutorial Details:

The most complete library to manipulate XLS files from Java is Jakarta POI library. The problems appear when it is required to create a lot of custom and complex Excel reports with rich formatting and enhanced functionality.

In this case you have to write a great bunch of Java code for creating workbook with all required formatting, formulas and other specific settings and correctly export data from a set of Java objects. Such code is hard to debug and the task of its creating is usually errorprone and timeconsuming. The other problem is that there are many Excel components for which there is no manipulation API provided.

Fortunately POI API allows to read Excel file trying to preserve it as is and then modify it as required. It is obvious it would be much easier to create all correctly formatted report template in some Excel editing tool and specify places where real data should appear.

Main Features:-
* Using SQL queries directly in XLS templates
* Simple property access notation
* Full expression language support
* Complex object graph export
* Flexible collection export
* Flow-Control Tags support


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Welcome to jXLS

View Tutorial:
Welcome to jXLS

Related Tutorials:

Welcome to the WfMOpen project
WfMOpen is a J2EE based implementation of a workflow facility (workflow engine) as proposed by the Workflow Management Coalition (WfMC) and the Object Management Group (OMG).
 
Apache Geronimo
Apache Geronimo Welcome to Apache Geronimo, the J2EE server project of the Apache Software Foundation. Please help us make this a world class, certified J2EE container!
 
Creating EL-Aware Taglibs Using XDoclet
Creating EL-Aware Taglibs Using XDoclet When the JSP Tag Extensions (also known as taglibs) first came out, the only option to pass dynamic values as tag attributes was using Request Time (RT) expressions. With the advent of JSTL 1.0, another option ha
 
Eclipse 3.0 is out
Eclipse 3.0 is out Welcome to eclipse.org Eclipse is a kind of universal tool platform - an open extensible IDE for anything and nothing in particular.
 
Welcome to the Tonic Look & Feel.
Welcome to the Tonic Look & Feel. This pluggable look and feel is a free substitute for the default native look and feel of Swing, 'Metal', distributed under the GNU Lesser General Public License.
 
STRAP - Interactive alignment program for proteins
Structural Alignment Program for Proteins Welcome to STRAP, an editor for multiple sequence alignments of proteins. The computer program STRAP supports the analysis of hundreds of proteins and integrates amino acid sequence, secondary structure, 3D-struc
 
Ruling Out: Rule Engines and Declarative Programming Come to Java
What practical gain can be found in researching rule engines? Is this just another round in the hype cycle, where writers like me talk up the newest "geegaw" technology and try to pawn it to the masses?
 
Welcome to the Apache Struts Tutorial
This is the complete Struts Tutorial. Explains ActionForm Action Class Validation Framework.
 
What's New in Swing?
A new skinnable look and feel (Synth), printing support for |JTable| components, the ability to add components directly to a frame, these are a few of the new features in Swing for J2SE 5.0.
 
Chat Transcript: Project Looking Glass
Where did the original Looking Glass idea come from? Read the answer to this and other interesting questions about Project Looking Glass, a project that explores the next generation (3-dimensional) desktop.
 
Welcome to Java Developers paradise!
Welcome to Java Developers paradise! T his site contains many quality Java, JSP, RMI, MySQL downloads, tutorials, source codes and links to other java resources. We have large number of links to the tutorials on java which will help you learn java
 

Welcome
 

Welcome
 

Welcome
 
Introduction To Enterprise Java Bean(EJB). Developing web component.
Introduction To Enterprise Java Bean(EJB). Developing web component. Developing web component Introduction To Java Beans J2EE specification defines the structure of a J2EE application. According to the specification J2EE application consists of
 
Welcome to the Jboss 3.0 Tutorial
Welcome to the Jboss 3.0 Tutorial Welcome to the Jboss 3.0 Tutorial 10 Minutes Guide to Ant Comprehensive description of Ant with example. Building Web Application With Ant and Deploying on Jboss 3.0 This lesson shows you how to build you web
 
Welcome to the MySQL Tutorials
Welcome to the MySQL Tutorials Welcome to the MySQL Tutorials Using MYSQL Database This lesson is intended to provide hands an experience with MYSQL database Backing Up and Restoring A MySQL Database In this lession you will learn how to take
 
Welcome! to the News letter archive
Welcome! to the News letter archive News Letter Archive Date Subject Dec-29-2001 Adding slash " \ " character before quote " ' " in a query
 
What is WAP? Detailed discussion of WAP API with examples.
What is WAP? Detailed discussion of WAP API with examples. Learn WAP in 60 minutes W ireless Application Protocol or WAP for short, allows the developers to develop next generation web application for cellular devices. Through WAP enabled mobile
 
Web Site promotion services at roseindia.net
Web Site promotion services at roseindia.net Welcome to RoseIndia.net Web Submission Services Our Web site services will help you get listed in major search engines and directory of the world. Our own site traffic comes from the major search
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.