jXLS – Excel Reports from XLS templates
September 24th, 2006
A common requirement for many reporting applications is to provide the ability to export reports to Microsoft Excel format. This can be challenging for a number of reasons, including:
- Most reporting engines require the use of a report design tool to develop reports.
- Reports designed to be exported to PDF or HTML do not always translate well to XLS format.
- Advanced Excel functionality such as complex forumlas, macros, and charts are not always available through the reporting engines.
jXLS is an open source Java library that greatly simplies this process by providing the ability to use XLS templates as the basis for generating reports in Excel format.
jXLS is now fully integrated into OpenReports. OpenReports supports the use of jXLS templates as the ouput format for QueyReports. OpenReports also supports the use of embedded SQL in jXLS templates. This is a powerful feature that allow the generation of Excel reports containing the results of multiple queries. The OpenReports Tomcat distribution contains a number of Spreadsheet Report examples that illustrate the use of jXLS templates in OpenReports.
Entry Filed under: All
9 Comments
1. Lisa Shields | September 24th, 2006 at 11:05 pm
Can’t wait to try it out. We have been using Jasper for a while and jxls recently, and now that we have OpenReports pro, we have been able to add chart reports to our arsenal as well. This is a fabulous product and the speed of feature enhancements is impressive.
2. Pierce Wetter | October 4th, 2006 at 3:38 pm
Very cool!
3. Saurabh Gupta | November 21st, 2006 at 8:01 am
this is very easy to use & Performance also very good.
i am using jxl in my project.
4. razvan | February 26th, 2007 at 5:05 pm
How can i execute an oracle sql stored procedure using JXLS???
Please HELP!
5. JP | May 15th, 2007 at 6:24 pm
Very Cool product…. I have used in my system…. Its a very fun to play with Macros and stuff………. JXLS is a very good Open Source Reporting tool….
No need of alignment Problems….
No need of XML
Easy Excel Templates….
Have to know Expression language and its Attributes.
Totally it is a good Reporting tool.
6. Suresh | July 2nd, 2007 at 11:23 am
Hi , I am enjoying the functionality provided by JXLS . But i am having one problem. I have tried an example to generate ans excel file using JXLS. it works fine . I am able to get exactly the same template with the filled data. The problem is I am using a web application to down a excel file generated by JXLS .I am downlaoding it . but when i am open the document the cells are out of alignment with the template and i am not able to get the graphs and colours in the downlaoded file .
Any one gone thro this sour of proplem can help me.
7. Suresh | July 2nd, 2007 at 11:23 am
Hi , I am enjoying the functionality provided by JXLS . But i am having one problem. I have tried an example to generate ans excel file using JXLS. it works fine . I am able to get exactly the same template with the filled data. The problem is I am using a web application to down a excel file generated by JXLS .I am downlaoding it . but when i am open the document the cells are out of alignment with the template and i am not able to get the graphs and colours in the downlaoded file .
Any one gone thro this sour of proplem can help me.
8. Eric Ricci | July 17th, 2007 at 6:12 pm
Can be a response to use stored procedure:
9. Raj | September 19th, 2007 at 12:52 pm
How to set width to write text using Jxl ?
Trackback this post