This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi, I am pretty new to XMLBeans. I have created a JSP page that would use XMLBeans to display an XML . That works pretty fine. What I want to know is if it is possible to write a generic class that would take any XML format of a Excel file and display in JSP.
I don't know what you mean when you say "display an XML in a JSP". If you just want to dump the XML to the browser, you don't need anything special at all. You just read the XML and write it to the response's output.
But you are asking about XML output by Excel as if it were special in some way. It is still XML. Perhaps you are expecting something Excel-like to happen in the browser? It would help if we understood your goals.
Joined: Dec 13, 2005
Thx for the response paul. What I meant was let us say there is a xml which has something like this <po:line-item> <po escription>jaya</po escription> <po:nrOfItems>10</po:nrOfItems> <po :price>100</po :price> </po:line-item>
I want a JSP page that displays them in a proper format in a user friendly interface. Description : Jaya Nr od Items : 10 Price : USD 100
This is how I want my JSP.
Now in XMLBeans, this needs a particular xsd of that xml file. My requirement is that I want a web interface for any kind of xml file that can be generated from an excel.
I am not sure if that is possible atall.
Hope I clarified yr question.
Regards, Jay. [ June 16, 2006: Message edited by: Jay Ram ]
Well, you can download the schemas from Microsoft if I'm not mistaken.
And you could surely write an XSLT that converted those XML documents into whatever you think of as user-friendly. Although this would take a very long time for a beginner, as Excel has an extremely large number of features to deal with.
And perhaps you could even write XMLBeans schemas to map the Excel XML documents to Java, but again it would be a long process. The last time I looked at accessing Excel by Java I noticed there were over 500 object types that could appear.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: web interface for the XML format of the Excel file