File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes HTML Tags through JAVA into Excel Sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "HTML Tags through JAVA into Excel Sheet" Watch "HTML Tags through JAVA into Excel Sheet" New topic

HTML Tags through JAVA into Excel Sheet

Yogendra Joshi
Ranch Hand

Joined: Apr 04, 2006
Posts: 213
Hi Folks,

We have a application in which a student's lesson progess details are populated on a screen viz, a JSP from a database column. This is generated as a Jasper Report and the values extracted from database contains a lot of String Data and inserted into an excel sheet.

One of the problems that we came across recently was, Teachers created an assignment by copying and pasting a mathematics formula as a assignment name. The Formula is like this X(Square)+2x, here Square refers to the actual raise to the power 2, now when this data is inserted in excel sheet, it is inserted like this : x<sup>2</sup>+2x which is so hard to read and teachers and students are complaining about this incorrect data.

Is there anyway in Java that we can parse the HTML tags as actual mathematics formula inside an excel sheet directly, like generally if we want to superscript a value we use superscript function of excel sheet,the same functionality we need on the data that is getting populated inside the excel sheet.

Thanks a lot in advance,
Yogendra N Joshi.

Meri Zindagi Hain Tab Tak.. Jab Tak Tera Sahara.... Har Taraf Tu Hi Tu Hain SAI Tera Hi Hain Nazara.....
James Sabre
Ranch Hand

Joined: Sep 07, 2004
Posts: 781

I write a fair number of documents containing mathematical equations and I use the Open Office Maths program. I have never used the interface but given that Open Office has a Java interface you may be able to use it to display the equations by converting them to images prior to display. It will mean that a different mark up language will need to be learned by those writing the equations but the result is pretty impressive.

Retired horse trader.
 Note: double-underline links may be advertisements automatically added by this site and are probably not endorsed by me.
I agree. Here's the link:
subject: HTML Tags through JAVA into Excel Sheet
It's not a secret anymore!