File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes XML and Related Technologies and the fly likes web interface for the XML format of the Excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "web interface for the XML format of the Excel file" Watch "web interface for the XML format of the Excel file" New topic
Author

web interface for the XML format of the Excel file

Jay Ram
Ranch Hand

Joined: Dec 13, 2005
Posts: 40
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.

Thanks,
Jay.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18655
    
    8

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.
Jay Ram
Ranch Hand

Joined: Dec 13, 2005
Posts: 40
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 ]
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18655
    
    8

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 agree. Here's the link: http://aspose.com/file-tools
 
subject: web interface for the XML format of the Excel file