HTML Tags through JAVA into Excel Sheet

[Yogendra Joshi]

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²+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.

[James Sabre]

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.