• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

web interface for the XML format of the Excel file

 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Marshal
Posts: 28177
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Marshal
Posts: 28177
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic