• 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

Converting excel to XML,Reading And Writing

 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello all,
well I have a question i have an operation of converting excel file into XML .
The excel file is having multiple tab in each tab elements are there in that values are set.

My work is to convert all tab and corresponding element into XML.

well you people can give me idea on that .

secondly what i have done i read the excel file(.xlsx) for multiple tab like pages is a tab ,labels is a tab i have created multiple method all stored in a list object ,a datalist and a
taglist.my idea is to create a method and writeXml which takes ArrayList parameter after getting the datalist and taglist object i can use DOM api to convert to XML.but anybody can please refer me how to write that code or how to implement that one?
well I have Used POI api for reading
 
Author and all-around good cowpoke
Posts: 13078
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If I understand your problem correctly, you do not need to go through a DOM step if you know what the resulting XML should look like in terms of elements and hierarchy of elements.

Recall that an XML document is just text and you can output text a variety of ways, for example with a FileWriter.

Bill
 
I think I'll just lie down here for a second. And ponder this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic