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 Altova Mapforce to convert to xml from excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Altova Mapforce to convert to xml from excel file" Watch "Altova Mapforce to convert to xml from excel file" New topic
Author

Altova Mapforce to convert to xml from excel file

sai rama krishna
Ranch Hand

Joined: May 29, 2009
Posts: 225
Hi,

I am new to Altova Mapforce. I would like to use that to convert from complext xls(which has multple tables, lot of headings, subheadings, sections) file with multiple sheets into corresponding XML file. How can I use it. ANy sample examples on using it. Any other better ideas to do it highly appreciated.
Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
Jeff Verdegan
Bartender

Joined: Jan 03, 2004
Posts: 6109
    
    6

This doesn't seem to be related to Java, and certainly not to Beginning Java. You'll probably have a better chance of getting an answer using whatever support resources Altova provides.

Moving to the XML forum in case this question has to do with a Java API to the product that somebody there may be able to help with.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

I went to the Mapforce home page and it didn't take very long for me to notice a link to a page about how to map Excel documents. Looks like exactly what you asked for.
sai rama krishna
Ranch Hand

Joined: May 29, 2009
Posts: 225
Link looks good. But it outputs to OOXML but I need output as XML. What are the differences between OOXML and XML. Is there is link that outputs to XML. IS there is a way i can convert OOXML to XML. Please advise
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

sai rama krishna wrote:But it outputs to OOXML but I need output as XML.


That page says

XML data to/from Excel (OOXML)


That includes "XML data from Excel (OOXML)", doesn't it? Which certainly sounds like "output as XML" to me.

What are the differences between OOXML and XML.


Here's a link to the Wikipedia article about OOXML: Office Open XML.

But really, these things I have been showing you are extremely easy to find on the internet. Don't you think it's about time you started looking for them yourself?
sai rama krishna
Ranch Hand

Joined: May 29, 2009
Posts: 225
Sure
 
wood burning stoves
 
subject: Altova Mapforce to convert to xml from excel file
 
Similar Threads
Stylus Studio Offers Altova XMLSpy and Mapforce Users a FREE Upgrade to Stylus Studio
Looking for ideas on best way to do this with XML....
how to use Altova Mapforce java code
convert XMLs with different .xsd
xdr to xsd conversion