• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

HTML Tags through JAVA into Excel Sheet

Ranch Hand
Posts: 213
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Ranch Hand
Posts: 781
Netbeans IDE Ubuntu Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

A teeny tiny vulgar attempt to get you to buy our stuff
how do I do my own kindle-like thing - without amazon
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!