XML.orgXML.org
FOCUS AREAS |XML-DEV |XML.org DAILY NEWSLINK |REGISTRY |RESOURCES |ABOUT
OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
RE: [xml-dev] Converting Excel Table to XML document

Title: Re: [xml-dev] XML Schema: "Best used with the ______ tool"

Hi Oscar,

 

Altova MapForce is a powerful data mapping tool that supports a wide variety of data formats including XML, Excel 2007, and flat files.

 

http://www.altova.com/products/mapforce/excel2007_ooxml_mapping.html

 

It also supports automation through code generation and the command line.

 

Best regards,

Liz

 

Liz Andrews

Technical Marketing Manager
Altova, Inc.

www.altova.com

 


This e-mail and any attachments are intended only for the person/entity to which they are addressed and may contain confidential and/or privileged material. If you received this in error, please notify the sender and delete the message.

 

From: Oscar Rodriguez [mailto:orodriguez@innoveer.com]
Sent: Thursday, December 18, 2008 1:13 PM
To: xml-dev@lists.xml.org
Subject: [xml-dev] Converting Excel Table to XML document

 

Hi - I have the following reference table in Excel

SourceApp    TargetApp

Competitor   Commercial
Partner        Business Partner
...

Does anyone know an easy way to convert the above table to an XML that looks as follows?

<?xml version="1.0" encoding="UTF-8"?>
<dvm name="Customer" isNew="null">
  <description>DVM description</description>
  <columns>
     <column name="SourceApp"/>
     <column name="TargetApp"/>
  </columns>
  <rows>
    <row>
      <cell>Competitor</cell>
      <cell>COMMERICAL</cell>
    </row>
  </rows>
</dvm>


Thanks in advance
- Oscar

 



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 1993-2007 XML.org. This site is hosted by OASIS